Ignore EXTERNAL tables?

CMeeseCMeese 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.
Tagged:
· Share on Twitter

Best Answer

  • Rob CRob C Posts: 419 Gold 2
    Answer ✓
    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
    Software Engineer
    Redgate Software
    · Share on Twitter

Answers

Sign In or Register to comment.