Sql Server Database Comparison
I haven't found anything online, so I wanted to ask here. I have two SQL Server databases running on our server. One is the production database, and another is my development database that I use when I'm working on the program. I add tables and columns and stuff to my development database, and was wondering if anyone knew of an easy way to from within Management Studio or something to compare the two databases to make sure that they are the same and show me any differences.
Try dbForge Data Compare for SQL Server.It can compare and sync any databases, even very large ones. Quick, easy, always delivers a correct result. Try it on your database.
I generally add tables or columns to both databases at the same time, but I worry that one time I might forget, so I would like to be able to run some sort of compare / check to make sure before releases. Thanks everyone for your help. I greatly appreciate it. If you have Visual Studio 2010 this has built in functionality that you are able to do data compares, schema compares and it will generate the differences for you in a script if you need to recitfy the variances. I hope this helps.
Sql Server Database Download
Warwick Rudd MCT MCITP SQL Server 2008 Admin ------------------------------------------------------- Please mark as Answered if I have answered your question Please vote if this was useful ------------------------------------------------------- Movember is here. Show your support for Mens Health by making a donation here. Install zawgyi font on mac. If you have Visual Studio 2010 this has built in functionality that you are able to do data compares, schema compares and it will generate the differences for you in a script if you need to recitfy the variances. 
I hope this helps.