January 29, 2013 at 11:12 am
First off I have no idea where this should go, I figured id get more forgiveness for putting it in the newb forum 😀
I am using the RedGate Data Compare tool and set up all my tables with the settings I want to use. This took about 4 hours. I want to be able to use these settings for different DBs but when I select a different databases it regenerates my tables and deletes all my saved settings..
The database structure is identical to the original database I set up.
I have tried to edit the .SDC file to manually change DB's but this does not work either.
Any suggestions?
January 29, 2013 at 1:25 pm
so you are using the tool to output a query so you can add your standards to the DB?
btw, i love RG, I use it all the time and have for 5 years, glad to help.
MCSE SQL Server 2012\2014\2016
January 29, 2013 at 1:26 pm
No I am using it strictly for the compare. We use it when upgrading our clients to view what has changed in the database on an upgrade.
January 29, 2013 at 1:33 pm
The compare generates a script at the end, if you sync it, it is possible that it will over write your DB. Check your settings, don't sync the DB's, and look at the script, run it seperately.
I used it to compare DB's in prep for upgrades as well, it works wonders and saves ALLOT of time.
lk
MCSE SQL Server 2012\2014\2016
January 31, 2013 at 5:57 am
You can use the command line utility with SQL Data Compare to programmatically have it do that type of work for you. Here's the documentation on how that works. You can call this from a DOS prompt, or I use it all the time from PowerShell.
"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
January 31, 2013 at 9:02 am
I finally contacted RedGate and they determined it was a bug in their system.
February 1, 2013 at 1:29 pm
this one doesn't have the problem (in case you're stuck and need a solution right now)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply