Deploy to database without preserving data

rikoriko Posts: 9
edited September 19, 2013 6:14AM in SQL Compare Previous Versions
I am trying to deploy changes to tables from one database to another as part of development. SQL Compare insists on creating temporary tables in the target database, putting the data in them, and then trying to insert the data back into the new tables (which now have different types/names for columns).

I cannot find an option to turn off the preservation of existing data.

I want to deploy my schema changes while discarding any existing data if present. (It is called SCHEMA compare after all!) I don't understand why there isn't an option to ignore data currently in target tables and just drop them.


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    SQL Compare is designed to preserve data in tables when tables are rebuilt.

    We do not delete/ignore the existing data but preserve it and unfortunately there is no setting to turn it off. But we appreciate your requirement, please feel free to add your vote or if there is one already kindly vote for it here.

    And then the project manager can directly decide what category this requirement comes under?

    Hope this helps.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.