Ignore EXTERNAL tables?

CMeese

When comparing SQL Azure databases, is there a way to ignore EXTERNAL tables? We have a lot of EXTERNAL tables in production that we will never have in production, so every time we compare dev to prod they come up as DROPs.

Rob C

Hi CMeese,

Apologies for this problem. SQL Compare doesn't currently support external tables but we're working on this right now. When this is done it will be easy to filter them out because they'll be a separate object type. In the mean time, I'd suggest filtering them out based on the table names.

Rob

CMeese

OK, thanks for the feedback Rob.