Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Compare Schema In Sql Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-04 : 08:08:22
Constantinos writes "I Want to Know How can i compare two schema in different or not SQL Server (One of them may be connect with dial up) and if exist any way to generate a script to fix all these differents
thanks"

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-12-04 : 08:27:10
Please have a look at SQL COMPARE by Red-Gate software.
http://www.red-gate.com/sql_tools.htm
HTH

Franco
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-04 : 12:21:08
I recommend SQL Compare as well. It is an awesome tool. The new version is much quicker than the older one. This tool saves me quite a bit of time. It also generates the scripts for you to make the databases equal. I modify the code a bit, but it sure helps to have most of it written already.

Tara
Go to Top of Page
   

- Advertisement -