SQL Compare (Red-Gate Software)

When dealing with multiple databases (or DB environments such as Dev, Test, Prod), one of the biggest headaches a DBA can come across is keeping all of the DBs/Environments in sync. With SQL Server 2005 there is the new Database Trigger that you can use to track all DDL changes, but this can become a very manual process to compare the DDL changes across multiple environments and then sync those differences up.

However, a tool from Red-Gate Software called SQL Compare can help solve this issue.

From the Red-Gate website:
Compares and synchronizes SQL Server database schemas
Version 5 (out now) fully engineered for SQL Server 2005

  • Automate database comparisons
  • Synchronize your databases
  • Save hours of tedious work and eliminate manual scripting errors
  • All new database objects in SQL Server 2005 supported

Some of the procedures SQL Compare will automate for you:

With a free 14 day trial, it’s worth it just to take for a “test drive” to see if this is the right tool for your DB needs…

About Rodibidably

Jeff Randall is a frequent volunteer for free-thought organizations, including the Center For Inquiry – DC. Having been blogging since January 2008, he decided that a community of bloggers would be an interesting new experience (or at the very least a fun way to annoy his friends into reading his posts more frequently). Since finding out about about the existence of, and then joining, the atheist/skeptic community in 2007 he has been committed to community activism, critical thinking in all aspects of life, science, reason, and a fostering a secular society.
This entry was posted in Review, SQL Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s