transfer data from sql on WINNT to SQL on 2000

microsoft.public.sqlserver.programming

25 Nov 2005 6:19 AM

Pradeep

Please suggest links, docs as to how should I transfer data, user
information from SQL server on Winnt to SQL on Windows 2000 server.

Thanks Pradeep

25 Nov 2005 5:24 PM

marcmc

backup dbs
script database objects and save
script users and save
restore on new machine
run script users

Show quote

"Pradeep" wrote:

> Please suggest links, docs as to how should I transfer data, user
> information from SQL server on Winnt to SQL on Windows 2000 server.
>
>
> Thanks Pradeep
>
>