Copy SQL 2000 Database

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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
 
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.
 
How about using an "install" package. I'm making this app
to be redistributed and I'll also need to redistribute the
database.
 
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.
 
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.




.
Click to expand...
 
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.
 
Back
Top