copy databases

Hi, how can i copy databases from one server in one domain to another
server. Since the servers isnt in the same domain its not possible to do
with the copy in enterprise manager (even with same username and password on
Administrator). Is there som 3de party program to use for this? the customer
has nearly 100 databases and to manualy detach, copy and attach then is a
hell of a job.
/Per W.See if this helps: http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Per W." <fungererikke@.ikkegyldig.no.invalid> wrote in message
news:e6udnk$95i$1@.troll.powertech.no...
Hi, how can i copy databases from one server in one domain to another
server. Since the servers isnt in the same domain its not possible to do
with the copy in enterprise manager (even with same username and password on
Administrator). Is there som 3de party program to use for this? the customer
has nearly 100 databases and to manualy detach, copy and attach then is a
hell of a job.
/Per W.|||"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> skrev i melding
news:uRVRAIVkGHA.5036@.TK2MSFTNGP04.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/moving_sql_server.htm
>
No, sorry. I have 2 SBS servers, one 2000 that i will move the database over
to the new 2003, and since both servers are up and running i cant do this,
and i need something to copy all databases since the databases are on
different folders on the harddisk then ther is a lot of job copying the
files manualy. I cant understand why MS have made restrictions on the copy
options in the enterprise manager since this is a situation where it will be
realy good to use.
/Per W.