Posted by Erland Sommarskog on 12/19/06 16:32

Eric J. Holtman (ejh@ericholtman.com) writes:
> Am I missing something obvious in the 2005 Visual Studio
> portion of SQL Server?

There isn't any Visual Studio portion of SQL Server. Well, there is
the Business Intelligence Development Studio, but that for developing
reports and packages for Reporting Services and Integration Services.

> I have a database design, with a bunch of tables, views,
> stored procedures, etc, etc. I want to store each object
> in a separate file, so I can keep them in Source Safe.
>
> Is there a command that will "rebuild" the database,
> issuing the CREATE TABLE, VIEW and PROCEDURE statements
> in the "right" order, such that foreign keys, and procedures
> that call procedures get built in the right order?
>
> I know that for tables/views, I could put every in a
> CREATE SCHEMA, but then everything's in one file.

Are you using the new member in the Team System family for database
professionals, commonly known as DataDude? It seems to be that stuff you are
looking for.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]