The simplest way to copy a database from one server to another via TSQL is
through sp_attach_db and sp_detach_db, or by using backup/restore.

HTH,

Darin Strait, MS SQL Server Development and Administration
http://home.earthlink.net/~dstrait/professional/resume.htm


----- Original Message -----
From: "Brad Carroll" <bradc@c...>
To: "sql language" <sql_language@p...>
Sent: Wednesday, April 18, 2001 12:02 AM
Subject: [sql_language] SQL DMO library


> In his book "Professional SQL Server Development with Access 2000", Rick
> Dobson mentions the SQL-DMO library in Appendix C on the topic of copying
> databases between servers (why Microsoft didn't build in the ability to
> copy or move databases between servers directly into the SQL Server
> Enterprise Manager I will never know!).
>
> Anyway, I tried to set up a reference to the SQL-DMO library from Access
> and guess what?! It doesn't exist!  Maybe it has another name (the "File
> Scripting" library did!) or something like that.
>
> Can anyone tell me where to find it or how to get it?
>
> Also is there a way to do this with ADO or TSQL?  I have made an attempt
> with ADO in the absence of SQL-DMO, but it is not really going to work
> because there seems to be quite a difference in syntax between these two.
>
>