MS SQL Server Tools - SqlSvrMgmtStudio and Sql 2000

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SqlSvrMgmtStudio and Sql 2000

Kyle Jedrusiak

2006-03-22, 11:30 am

What are the best practices to get the complete database schema into
VisualSourceSafe?

Or at least point me in the right direction.

Kyle Jedrusiak

Erland Sommarskog

2006-03-22, 8:33 pm

Kyle Jedrusiak (kjedrusiak@princeto
ninformation.com) writes:
> What are the best practices to get the complete database schema into
> VisualSourceSafe?
>
> Or at least point me in the right direction.

If you are on SQL 2000, EM is probably a better choice, since you can
script the database, and opt to get every object in a file of its own.
This feature is missin from Mgmt Studio.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Sponsored Links