August 30, 2017 at 11:49 pm
Hi All
I am comparing databases( the structure) between test server and production soI will have more confident when it comes to production
I just found a tool called DB Comparer and it only tells methe difference but what if I want to see the difference and apply thedifference from production into test server so I don’t need to alter manually
Please kindly advice
Thank you
August 31, 2017 at 1:38 am
WhiteLotus - Wednesday, August 30, 2017 11:49 PMHi All
I am comparing databases( the structure) between test server and production soI will have more confident when it comes to production
I just found a tool called DB Comparer and it only tells methe difference but what if I want to see the difference and apply thedifference from production into test server so I don’t need to alter manually
Please kindly advice
Thank you
Please have a look at SQL Idera . It has a trial version too.
August 31, 2017 at 3:20 am
WhiteLotus - Wednesday, August 30, 2017 11:49 PMHi All
I am comparing databases( the structure) between test server and production soI will have more confident when it comes to production
I just found a tool called DB Comparer and it only tells methe difference but what if I want to see the difference and apply thedifference from production into test server so I don’t need to alter manually
Please kindly advice
Thank you
You could do worse than check out Redgate's SQL Compare - http://www.red-gate.com/products/sql-development/sql-compare/
It'll either generate a script for you to deploy later, or run the deployment then & there. They have a similar product for data comparisons.
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 31, 2017 at 3:34 am
The latest versions of visual studio have a schema compare tool with the option to deploy the differences.
August 31, 2017 at 6:47 am
WhiteLotus - Wednesday, August 30, 2017 11:49 PMHi All
I am comparing databases( the structure) between test server and production soI will have more confident when it comes to production
I just found a tool called DB Comparer and it only tells methe difference but what if I want to see the difference and apply thedifference from production into test server so I don’t need to alter manually
Please kindly advice
Thank you
Another vote for Redgate SQL Compare. It also supports comparison to backups, files, source control, and real soon now DACPAC and BACPAC files.
It's also a lot faster and provides radically more functionality than the VS tools.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 31, 2017 at 8:54 am
WhiteLotus - Wednesday, August 30, 2017 11:49 PMHi All
I am comparing databases( the structure) between test server and production soI will have more confident when it comes to production
I just found a tool called DB Comparer and it only tells methe difference but what if I want to see the difference and apply thedifference from production into test server so I don’t need to alter manually
Please kindly advice
Thank you
Handsdown SQL Compare. Worth every penny, i have used other products ( Visual Studio and Idera) nothing comes close to SQL Compare.
August 31, 2017 at 9:58 am
RedGate SQL compare is very good. but you can use Visual Studio as well, Schema comparison is good.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply