Red Gate forums :: View topic - SDC to compare principal and mirror DBs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

SDC to compare principal and mirror DBs

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
kinano



Joined: 28 Jul 2011
Posts: 3

PostPosted: Thu Jul 28, 2011 1:56 am    Post subject: SDC to compare principal and mirror DBs Reply with quote

We have a mirrored DB server and we were thinking of ways to verify the principal and mirror are in sync and create reports for our peace of mind and audit purposes.

Do you think SDC will work to compare the data between the principal and the mirror even though the mirror DB is apparently in recovery mode all the time?
The two boxes are SQL Server 2005 Standard and sit on the same LAN.

One more thing, would there be any performance overhead that should be considered on either box if we were to use SDC?

Thanks a ton,
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu Jul 28, 2011 1:54 pm    Post subject: Reply with quote

Thanks for your post.

If the database is marked as in recovery, then I don't think you'll be able to connect to it from Data Compare, so that's possibly your first problem.
Assuming you /can/ connect, Data Compare works by comparing all the rows in the tables based on a unique comparison key (either a PK on the table, a unique index, or one you define manually) and then reports back differences. These can be exported out to a csv file. You can also sync up the changes if you so wish.

This comparison obviously involves a lot of queries so there may be a potential performance impact while the process runs - it depends on how busy the server is and what you'd constitute as a performance hit of course! The pro version allows you to run a commandline version, so you could schedule the comparison to take place out - of - hours (if you have such a time window) to reduce impact.

Hope that helps.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group