Hello,

Ques 1.

Just backup the SQL 2000 database using RESTORE DAtabase and copy the Backup
file to SQL 2005 server and Restore using Restore Database command in SQL
2005 server

Ques 2

1. First backup the database in SQL 2000
2. Copy the backup to SQL 2005 server
3. Restore the database in SQL 2005 with a new name
4. Use INSERT commands to append the data.

Thanks
Hari


[quoted text, click to view]

I have two sql servers - mssql2000 & mssql2005-

question.. how do I copy sql2000 database to sql2005? they are both in the
same subnet.

also, how do I copy whole database from sql2000 to append into a sql2005
data file with same tables, structure, etc?

thanks,
raul Rego