Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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 starts erases all my data again.

I have tried to edit the .SDC file to manually change DB's but this does not work either.

Any suggestions?

share|improve this question
I take it you're wanting to compare the same databases, but between different servers? For example, comparing test to prod, and dev to test? – DForck42 Jan 29 at 18:16
No i'm comparing 2 different databases with the same structure on the same server. BaseLineDB1 vs RegressionDB1 and then BaselineDB2 vs RegressionDB2. Basically the same thing for a different client. – Cole Mietzner Jan 29 at 19:50
have you tried the redgate support forum? red-gate.com/messageboard/viewforum.php?f=156 – DForck42 Jan 29 at 20:30
Also, out of curiousity, why'd it take 4 hours? If you have primary keys set up on your tables and the structure it exactly the same, it should auto-detect everything. – DForck42 Jan 29 at 20:32

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.