Posted by Oscar Santiesteban on 11/18/06 21:51

I would "Detach" the database from the old server and "attach" the databases
on the new server. But as BD explained, you still have to address the users
of the database (ie security).

Oscar...

"RONIN" <ronin_1010@yahoo.com> wrote in message
news:ejl3er$274$1@ss408.t-com.hr...
> Can you tell me what is the best practice for SQL database migration from
> one DB server, to another one, new DB server. The old DB server will be
> removed.
>
> 1. Backup from old and restore all databases on the new server
> 2. Export data and copy/import on a new server
> 3. Something else...
>
> Thanks in advance for any good advice...
>
> Regards
>
>
>

[Back to original message]