You can not restore a SQL Server 6.5 database on SQL
Server 2000. I will suggest that you create scripts for
all the objects on SQL Server 6.5 and then create these
objects on the SQL Sever 2000 server using those scripts.
Once you have created the objects you can transfer the
data using DTS.

HTH

>-----Original Message-----
>In production we are still on a SQL server 6.5 Database
and I want to test
>how the system will function when the database is in
2000. Is there a way
>to restore the database or will I have to generate
scripts for each table
>then extract the data and load that way?
>
>Thanks
>
>
>
>.
>

Report this post to a moderator