What are the challenges you face when working across database platforms? Take the survey

Ignore EXTERNAL tables?

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

  • Options
    Rob CRob 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.

    Software Engineer
    Redgate Software


Sign In or Register to comment.