Deploy to database without preserving data

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Deploy to database without preserving data

Postby riko » Mon Sep 16, 2013 5: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.
riko
 
Posts: 7
Joined: Wed Sep 11, 2013 6:20 pm

Postby Anu Deshpande » Thu Sep 19, 2013 11: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.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests