Methods for transfer of data from sql server 2000 to sql server 7

[mgole]

Hi

We are planning to upgrade from sql server 7 to sql server 2000.The sql server 2000 will be installed on another server.
If we have to move back from sql server 2000 to sql server 7 (if there are any problems on sql server 2000).is there a way to do it?
Is there a way to restore the changes made on sql server 2000 to 7?

Thanks

Madhukar

[MAK]

backup sql server database on 7.0 and restore it in sql server 2000, it will automatically upgrade that database.

You cannot go back from 2000 to 7.0.

Best bet is to do a pilot phase where people can use both environment parallely. then once the pilot phase is OK then upgrade and cut over.

[mgole]

Thx for the reply..
How do we implement a pilot phase where we can send out transactions to both the servers?

Also we are planning to use backup-restore
for copying databases from 7 to 2000.Do we need to backup-restore the system databases also or do we need to just restore our production database?If we need to copy the sytem databases, then is backup-restore the best technique?

What abt the copy database wizard?

Which one is a better option for upgrade?(backup-restore or copy wiz)

Madhukar

[rmiao]

You can transfer data from sql2k to sql7 with dts or bcp. You can't restore sql7 system dbs onto sql2k, but you can copy sql logins and jobs with dts.