September 10, 2003 at 5:50 pm
Hi all,
Please, shoot me now if I am the "Bad Question Asker". I did a brief search already and my time is VERY limitted - by something important - Family, NOT a computer for a change.
I have a SQL 6.5 server and a couple of databases I want to upgrade to SQL2k. Using upgrades is failing (haven't seen the exact reason yet - wizard doesn't seem to like one particular table)
I know I can work round this with a succession of table dumps and loads. For the purposes of keeping management happy, we'd like to go the "supported" route.
My question is simply this - is there anyway of taking a 6.5 backup (dump) and restoring it on SQL 2000?
There you go! Prepared for a simple answer that says "No!"
Thanks for anyones reply.
bb
September 10, 2003 at 6:08 pm
Don't believe you can do that. However, if the upgrade is failing and time is somewhat important (and it is for me) I would burn a call to Microsoft. The cost is not that bad and when you factor in all the time that it will take you to troubleshoot the problem I guarantee you will end up cheaper if you make the call and pay the bill.
Just my thoughts.....
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 11, 2003 at 1:25 am
Thanks for your thoughts David.
However, my experience of Microsoft support has been very negative. I think we'll do the manual approach....
Thanks,
bb
September 11, 2003 at 1:57 am
On occasions when I didn't want to go the "upgrade" route I would:
1. create the db under sql2000
2. script all objects under 6.5
3. execute the script on sql2000
4. use dts to transfer data (remember to uncheck the views) from 6.5 to 2000
5. manually fix up any missing bits (users/logins possibly)
Cheers,
- Mark
Cheers,
- Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply