RE: Script Objects 1

[allyne]

Hi Everyone,

I need to compare all objects in one database to all object in another database. Both databases have the same tables but one is a newer version than the other. The newer version has Field Names that have been added,deleted and field Name changes. The newer database is in SQL2005 and the older one is in SQL2000. We need to do this because we are bringing both the new and old version in house. The new version does not have data in it yet and we are hoping to do a "data dump" into the new version but need to find out the differences.

What I would like to do is script the objects from both databases and do a comparison. Is there a way to script all objects for each database? It looks like I can only script one object at a time.

Thanks for all your help!

 

[mrdenny]

Take a look at

http://www.quest.com/Comparison-Suite-for-SQL-Server/

from Quest software. Best of all there is a freeware download.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[allyne]

WOW!!!! THANKS!!!!

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog