September 11, 2013 at 6:01 am
Hi,
We have dev,test and prod environments. The developers make the DDL and data changes on dev and the we will have to move this to test and after the successful testing changes has to be moved onto prod.
Right now I am using redgate sql campare and sql data compare to achieve this.
Is there any better way of doing this? Sometime a table data in one environment has to be updated with the data from the other as part of the database sync. For this I use import/export or BCP to move data to destination server db and then run the update command.
I am wondering is there is any better ways of doing this?
Thanks.
September 11, 2013 at 6:05 am
Does Redgate SQL Data Compare not give you the option to sync?
Another option to quickly generate insert statements for a table is to right-click on the database, select tasks and generate scripts.
Select the table and in the next step, go to the advanced tab and select schema and data or data only.
This generates a single insert statement for each row of data. I wouldn't recommend it for large tables.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 11, 2013 at 6:55 am
Can I rollback the changes in case if something goes wrong with the sync?I am not sure if this option is there in sql compare and data compare.
September 11, 2013 at 11:24 am
sql_novice_2007 (9/11/2013)
Can I rollback the changes in case if something goes wrong with the sync?I am not sure if this option is there in sql compare and data compare.
No idea, you ought to ask Redgate support that question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 11, 2013 at 2:34 pm
Koen Verbeeck (9/11/2013)
sql_novice_2007 (9/11/2013)
Can I rollback the changes in case if something goes wrong with the sync?I am not sure if this option is there in sql compare and data compare.No idea, you ought to ask Redgate support that question.
Look under deployement behavior in the options tab, you have an option for :
Do not use transactions in the deployement script
Make sure you leave that option unchecked. If something goes wrong, everything is rolled back
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply