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 Development (2000)
 Comparing Databases and Generating DDL

Author  Topic 

Shawn
Starting Member

9 Posts

Posted - 2002-05-30 : 12:41:38
Is there an easy way to compare two databases and generate the DDL representing the difference between the two?

I have not come across any tools within SQLServer so likely it is a third party tool. I have tried using ERWin 3.5.2 but I seem to get a mishmash of scary looking stuff with table renames and the like. Not to mention completely ignoring dependency ordering.

Thanks.


robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-30 : 12:42:58
Take a look here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16296

Go to Top of Page
   

- Advertisement -