RedGate Data Compare Multiple DB's

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » RedGate Data Compare Multiple DB's

RedGate Data Compare Multiple DB's

Rate Topic

Display Mode

Topic Options

Author

Message

Cole.Mietzner

Posted Tuesday, January 29, 2013 11:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 9:55 AM
Points: 7, Visits: 22

First off I have no idea where this should go, I figured id get more forgiveness for putting it in the newb forum BigGrin

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?

Post #1413205

It's the Database!!!

Posted Tuesday, January 29, 2013 1:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:39 AM
Points: 136, Visits: 307

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.

Post #1413309

Cole.Mietzner

Posted Tuesday, January 29, 2013 1:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 9:55 AM
Points: 7, Visits: 22

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.

Post #1413311

It's the Database!!!

Posted Tuesday, January 29, 2013 1:33 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:39 AM
Points: 136, Visits: 307

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

Post #1413315

Grant Fritchey

Posted Thursday, January 31, 2013 5:57 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 13,381, Visits: 25,172

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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1414046