| Author |
Restoring 6.5 Database in SQL 2000
|
|
| John Dillon 2002-11-20, 2:23 pm |
| 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
| |
|
| 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
>
>
>
| |
| Keith Kratochvil 2002-11-20, 2:23 pm |
| 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
>
>
>
|
|
|
|