Re: upgrade wizard 6.5 to 2000
From: Dan Quickert (dequickert_at_x_x_omsoft.com)
Date: 11/19/04
- Next message: Rand Boyd [MSFT]: "RE: SQL Server install"
- Previous message: Sunny: "Re: Setting up exact rights from different server"
- In reply to: Dan Quickert: "upgrade wizard 6.5 to 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 10:07:58 -0800
I finally figured out a way to accomplish the upgrade... it's amazing
what taking a break can do... and how stupid I can get without it!
I had SQLserver 6.5 generate scripts to create all the objects, etc that
I needed to xfer. Then after some script tweaking, got the objects made
on SQL2000.
Data xfer was accomplished via MS Access. Created "linked tables" to all
data tables on each SQLserver; then manually copied the records from
6.5's tables to 2000's. It's a simple 'select all', copy, paste.
That's it.
This was practical only because I have a limited number of tables, and
the datasets aren't huge. Not sure what Access's limitations might be
with a bigger database.
Now my question is, why the heck couldn't the darn Wizard figure out
somethins as simp;e to do as that? There obviously is no connectivity
obstacle.
I hope this helps someone down the line!
DQ
Dan Quickert <dequickert@x_x_omsoft.com> wrote in
news:Xns95A51F1C39504danq@207.46.248.16:
> I've had a week of gotcha's and catch-22's here...
>
> Trying to get my SQL 6.5 data moved to a new SQL2000 install.
> I've tried it with both on the same server, and on separate machines
> (source SQL6.5 on NT4, target SQL2000 on XP pro)
>
> Finding the upgrade wizard was the first step - it wasn't installed -
> then getting it to run at all. Finally was able to get things
> straightened out to at least begin the process...
>
> but the farthest I've been able to get is partway into the upgrade
> wizard, after the 'logon' screen, when I get the error message
> window: "Warning! Object directory could not be created"
> followed by:
> "the import server must be running sql server 2000"
> followed by:
> "the import server MUST be switched to sql server 2000"
>
> But my import server IS sql server 2000!
>
> can anyone help? or is there any other way to get my data moved over?
>
> Thanks much!
>
- Next message: Rand Boyd [MSFT]: "RE: SQL Server install"
- Previous message: Sunny: "Re: Setting up exact rights from different server"
- In reply to: Dan Quickert: "upgrade wizard 6.5 to 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
