transfer database

[midwesthills]

How can I transfer the schema of a database from one SQL Server app to
another? I've used MySQL in the past and all I had to do is create a
..sql file with the DDL statements for the database, then import that
file in the other db. Can I do the same kind of thing with SQL Server
2000? If so, how?

Also, is there a way to transfer the schema and data?

Thanks in advance for the help!!!

[Simon Hayes]

"midwesthills" <mi**********@hotmail.com> wrote in message
news:1f**************************@posting.google.c om...

How can I transfer the schema of a database from one SQL Server app to
another? I've used MySQL in the past and all I had to do is create a
.sql file with the DDL statements for the database, then import that
file in the other db. Can I do the same kind of thing with SQL Server
2000? If so, how?

Also, is there a way to transfer the schema and data?

Thanks in advance for the help!!!

It's not clear what you mean by transfer the database from one 'app' to
another - do you need to create a second copy of an existing database? If
so, the quickest and easiest way would probably be to back up the database,
copy the backup file to the other server (if necessary), then restore it.

Alternatively, there is a Copy Database Wizard in Enterprise Manager, or you
can script the database (right-click in EM, All Tasks), then use BCP or DTS
to copy the data.

Simon