Solved

SQL Server Database Comparison?

Posted on 2014-11-21
4
193 Views
Last Modified: 2014-11-21
Does SQL Server 2008 have any kind of tool that will compare 2 Databases with each other. I basically have a "Development" version and a "Test" version that I need to compare for any differences.

Thanks!
0
Comment
Question by:BlakeMcKenna
  • 2
  • 2
4 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40457928
Afaik no, but SQL Server (2012) Data Tools has SQL menu > Schema Compare > New Schema Comparison, which enables you to point to a source and target database, and identify any object that are in one and not the other / in both but different.

Invaluable when migrating all changes from one database (say DEV) to another (TEST).
0
 

Author Closing Comment

by:BlakeMcKenna
ID: 40457950
Thanks Jim...we're actually getting ready to do that migration to 2012...
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40457964
Very Damn Handy functionality.  Thanks for the accept, good luck with your project.  -Jim
0
 

Author Comment

by:BlakeMcKenna
ID: 40458200
Thank you!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now