Product Reviews

SQL Compare

Anyone who does database development has had to deal with common nightmares. One of these is keeping the production server and the development server in synch. It seems like every time I've been involved in a big database project, people are sneaking in "we'll just make this change on the production server and duplicate it on the dev server later" or vice versa.

Anyhow, comparing SQL Server databases by hand is not precisely my idea of fun. That's where Red Gate Software's SQL Compare comes in.

It's a simple utility to use. Select two databases, tell it which objects you want to compare, and let it rip. SQL Compare generates SQL Scripts for all objects of interest, and then looks for differences. You can tell which objects are different in the two databases, as well as which ones are in one but not the other. It's easy to drill in and look at the differences in the SQL as well.

You can also tell SQL Compare what to count as a difference. For example, if you're not worried about column order in tables, you can tell it not to consider different column orders as a difference. This sort of thing makes it superior to generating your own scripts and running them through a diff tool -- and SQL Compare is easier to use anyhow.

You can download a 2-week trial for free from the company's Web site.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • Surface and ARM: Why Microsoft Shouldn't Follow Apple's Lead and Dump Intel

    Microsoft's current Surface flagship, the Surface Pro X, already runs on ARM. But as the ill-fated Surface RT showed, going all-in on ARM never did Microsoft many favors.

  • IT Security Isn't Supposed To Be Easy

    Joey explains why it's worth it to endure a little inconvenience for the long-term benefits of a password manager and multifactor authentication.

  • Microsoft Makes It Easier To Self-Provision PCs via Windows Autopilot When VPNs Are Used

    Microsoft announced this week that the Windows Autopilot service used with Microsoft Intune now supports enrolling devices, even in cases where virtual private networks (VPNs) might get in the way.

  • Most Microsoft Retail Locations To Shut Down

    Microsoft is pivoting its retail operations to focus more on online sales, a plan that would mean the closing of most physical Microsoft Store locations.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.