Comparing database schemas and generating delta scripts

You can compare two database schemas and generate a delta script that can update one schema to be exact copy of the other schema.

This feature is available using the Tools > Compare Schemas menu.
Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Bill Lowry

    This feature does not work correctly if using multiple schemas in a particular database.

    If you compare databases having the following tables

    PROD_DB

       SALES.CUSTOMERS
      
    TEST_DB

       MYTEST.CUSTOMERS
       SALES.CUSTOMERS
      
    when you run the compare databases utility it compares table
    TEST_DB.MYTEST.CUSTOMERS  to  PROD_DB.SALES.CUSTOMERS
    and considers TEST_DB.SALES.CUSTOMERS to be --missing-- .

    But the intent is to compare TEST_DB.SALES.CUSTOMERS to PROD_DB.SALES.CUSTOMERS.

    I cannot find a way to force the compare utility to recognize distinct schema names.

     

     

     

Please sign in to leave a comment.
Powered by Zendesk