Deploy to database without preserving data

Forum for users of SQL Compare schema synchronization utility

Deploy to database without preserving data

Postby riko » Mon Sep 16, 2013 4:16 pm

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.
Posts: 7
Joined: Wed Sep 11, 2013 5:20 pm

Postby Anu Deshpande » Thu Sep 19, 2013 10:14 am

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.
Anu Deshpande
Posts: 838
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests