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.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk