External SQL server

[rohini21]

Hi There,

I have a job of bringing in the database from an external SQL server. The owner of the server says I should be using DTS. Now I tried creating an OLE DB connection string to connect to the external server but did not succeed.

Can someone please guide me how to achieve my job.

Thanks

 

[nigelrivett]

You mean you are trying to copy the database?
Try copying a backup file and restoring it instead.

You can also transfer the objects using dmo

http://www.nigelrivett.net/SQL-DMOTransfer.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.