Solved

SQL Server Database Comparison?

Posted on 2014-11-21
4
198 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Copy Database Wizard 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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 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