November 24, 2008 at 12:31 am
I want to compare two database by generating the script.
Using generate script I generate script for two database to compare in source safe. But when I open the script I can view that the script generated are in different order.This was not the case in 2000 but in 2005 I always get this type of problem how can I generate the script so that the generated script objects will be in the same order in both the file?Is there any other way to compare the script of two databases?
November 24, 2008 at 3:42 am
Hello,
I use RedGate’s SQL Compare to check for differences between two DBs. It isn’t free, but it does also include a nice synchronisation function for the price.
Regards,
John Marsh
PS: Alternatively you might be able to use XSQL’s free “Lite” Bundle to do the same job.
www.sql.lu
SQL Server Luxembourg User Group
November 24, 2008 at 6:01 am
Yeah, I was going to recommend SQL Compare from Red Gate too. There's also Apex SQL, they have a nice compare utility. Visual Studio Team System Database Edition comes with a compare utility as well. It's not as good as the other two.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 24, 2008 at 8:16 am
I recommend SQL Compare from Red Gate too
but there are some free good ones as well
http://www.xsqlsoftware.com/Product/Sql_Schema_Compare.aspx
What is included? The free lite edition of the xSQL Bundle includes the complete suite of xSQL Software products:
*
xSQL Object for schema comparison and synchronization
*
xSQL Data Compare for data comparison and synchronization
*
xSQL Object Command Line utility for unattended schema comparisons and synchronizations
*
xSQL Data Compare Command Line utility for unattended data comparison and synchronization
*
xSQL SDK for integrating comparison and synchronization functionality in your application
November 24, 2008 at 9:57 pm
I did it in a different way. First I generated the script for sql2000 then in
Sql server 2000 I created a database executed the generated script.
From 2000 I once again generated the script and saved the script in source safe.The same thing I did for second database and compared both the database. By this way I was able to compare two database.
I do not know why the 2005 does not generate the script in order like 2000?
November 25, 2008 at 5:35 am
Just to give a different option: I did an "in-house" approach. I needed to compare our Dev SQL server to our production SQL Server, document any changes, and possibly reapply changes in Dev after restoring a database from production. I did this by writing a web service that accesses SMO (SQL Management Objects), and then using SQL CLR to access the web service. This gave me two scalar functions for getting the creation and drop script of an object. Not as clean and neat as a third party solution, but I like being able to tweak the process.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply