Ignore EXTERNAL tables?
CMeese
Posts: 7 Bronze 1
in SQL Compare
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.
Best Answer
-
Rob C
Posts: 419 Gold 2
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.
RobSoftware Engineer
Redgate Software
Answers