In Enterprise Manager have your database selected, then go to Tools Menu,
choose Generate SQL Scripts. This lets you generated scripts for all
objects in the database . You can send this script along with the
application that you are going to send out.
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
| Subject: Re: Best way to copy database...
| Date: Mon, 3 Jun 2002 10:37:38 -0400
| Lines: 48
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: pool-138-89-175-194.mad.east.verizon.net 220.127.116.11
| Path: cpmsftngxa08!cpmsftngxa10!tkmsftngp01!tkmsftngp02
| Xref: cpmsftngxa08 microsoft.public.sqlserver.programming:263164
| X-Tomcat-NG: microsoft.public.sqlserver.programming
| The product we are selling is a "boxed" intranet type application for use
| client servers within their own network..
| By the way, do you have any reference sites for SQL syntax when creating
| database.. (datatype, Defaults, keys, etc.)
| (ASP.NET application)
| > You can create the scripts for your database and make them
| > execute in the taget machine. 50 tables with defaults will not
| > take too much time unless you are dumping tons of data into them.
| > Coming to your requirements, are you planning to create this
| > database on the client machines? (I could be wrong, but if it is
| > a web application why do you need to ship your database?).
| > - Anith
| > > I would like to make a copy of a database for a product we wish to
| > > (web application)
| > >
| > > What is the best way to copy the master SQLSERVER database to a cd or
| > > another machine?
| > >
| > > Is it better to write a function that creates the database from
| > > That will take a long time since the DB has over 50 tables with many
| > default
| > > values, etc.
| > >
| > > Thanks for any help,
| > > -Hunter
| > >
| > >