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

You cant do the restore. Ive done the script/ bcp method and was happy with
it. Others use the Upgrade Wizard for the whole sql server and are happy
with it.
"John Dillon" <jdillon@hermesofparis.com> wrote in message
news:O2ytw3MkCHA.2480@tkmsftngp12...
> 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

You cannot restore 6.5 directly to 2000.

SQL 7 (and I believe SQL Server 2000) shipped with an upgrade wizard that
would upgrade your [6.5] database to 7.0 (or 2000). You might want to look
for that tool/wizard within the program group. If it is not there you might
have to install that component.

Generating scripts and exporting/importing data would also work -- but it
would require much more involvement on your part!

--
Keith, SQL Server MVP


"John Dillon" <jdillon@hermesofparis.com> wrote in message
news:O2ytw3MkCHA.2480@tkmsftngp12...
> 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