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
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 6:20 pm
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.
- 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