Copy SQL 2000 Database

[Ryan]

I am creating an ASP.NET application using C# Visual
Studio .NET 2003, and have set up the project using a
local instance of MSDE (SQL Server 2000 Desktop Edition).
This database has multiple tables as well as Stored
Procedures and Database Designs (relationships, etc). How,
when I create a setup project, can I create this database
on a valid SQL 2000 server? Can I run a batch of SQL
statements (similar to a DUMP function in mySQL) or do I
simply include the database and "attach" it to the
installation server? Any insight or links would be
appreciated!

thnx

 

[Kevin Spencer]

You can import the database using SQL Server quite easily.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Guest]

How about using an "install" package. I'm making this app
to be redistributed and I'll also need to redistribute the
database.

 

[Kevin Spencer]

You can create a DTS package on the SQL Server which you can install.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Guest]

Could you explain that further or post a link?

-----Original Message-----
You can create a DTS package on the SQL Server which you can install.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.




.

 

[Kevin Spencer]

Not much to explain. DTS (Data Transformation Services) is a part of SQL
Server, and is used for conducting various types of scripted operations on
the local SQL Server, and for interacting with other databases and database
servers. A DTS package is simply a script which you can create with SQL
Enterprise Manager. If you need to know more, I would recommend going to the
SQL Server site on the microsoft.com domain:

http://www.microsoft.com/sql/default.asp

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.