Red Gate forums :: View topic - Deploy to database without preserving data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Deploy to database without preserving data

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
riko



Joined: 11 Sep 2013
Posts: 7

PostPosted: Mon Sep 16, 2013 5:16 pm    Post subject: Deploy to database without preserving data Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Thu Sep 19, 2013 11:14 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group