Thanks John. I thought I had read where it needed to be done through SQL 7.
I was being a bit lazy posting here but, I'm a bit busy and figured this
would provide me with a quick answer.
Say, John I have a off topic question for you. By any chance did you grow up
in central NY?
I had a childhood friend by the same name and figured I ask.
JD
"John Bell" <jb************@hotmail.com> wrote in message
news:41***********************@news.easynet.co.uk. ..
Hi
You can upgrade directly to SQL 2000 through the wizard (BOL topic:
Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)) , but depending
on how complex you application is you may have to do extra work on the
compatibility issues (See BOL: Backward compatibility). If you have
multiple installations or require a repeatable upgrade then you may want to look at
doing a staged conversion process using BCP or possibly DTS.
John
"JD" <jo*****@yahoo.com> wrote in message
news:41********@news.qgraph.com...
With SQL 6.5, don't you have to upgrade to 7.0 first, and then to 2000?
"John Bell" <jb************@hotmail.com> wrote in message
news:41***********************@news.easynet.co.uk. .. Hi
They are two different architectures and therefore you can't. You will
have to load the backup onto a 6.5 installation. Upgrading from 6.5 to 2000
is not always a simple issue and you should look at the section on
compatibility in Books online.
John
"AHartman" <Ho*******@Kconline.com> wrote in message
news:85********************@kconline.com...
>
>
> Can you restore a SQL6.5 backup to a Sql2000sp3 ?
>
>
>