0 Replies Latest reply on Feb 15, 2019 10:24 PM by 8753ae36-544b-48a7-a3fe-3f1518b3b29a

    ODT 18.3 Schema Compare Update - ALTER Table instead of DROP & CREATE

    8753ae36-544b-48a7-a3fe-3f1518b3b29a

      Hello,

       

      I am trying to track changes and versions of a database using ODT's Schema Compare with Visual Studio 2017, but I am coming across a problem with generating update scripts for versioning. When I try to generate the update script from the Schema Compare result interface, instead of just simply altering the table (in the instance of a column addition), the script that is generated is dropping and creating a new table with the additional column. I was wondering if there was any way to get the tool to generate with the alter command instead? The dropping is undesirable because, in most cases for versioning/upgrading of databases, we would want to keep the existing data.

       

      It looks like this may have been previously available from the documentation described here (Using the Schema Compare Tool > Viewing Schema Differences and Generating Diff Scripts > Steps 6&7). If the alter was intentionally removed in lieu of drop/create, is there any reasoning behind that?

       

      Thanks,

      Nathan