Migrating 6.5 Data to 2000 
Author Message
 Migrating 6.5 Data to 2000

Hi:
I have one machine running SQL Server 6.5 and another running 2000.
I want to migrate the data from 6.5 to 2000.
As per Microsoft documentation I can use the Upgrade Wizard to do this.
However, the upgrade files
were not installed during my install of the 2000 server.

I noticed an "Upgrade" directory in the CD. I tried running the upgrade.exe
file and it seemed to bring up
the wizard but then I get the error "The import server must be running SQL
2000" even when the import
server was running the new SQL 2000.

How can I upgrade from 6.5 to 2000 when they are both installed on seperate
machines?
Do I have to install 2000 on the same machine as 6.5

Thanks for the help


AJ



Sat, 01 Jan 2005 10:03:43 GMT
 Migrating 6.5 Data to 2000

Yes you can definatley convert data from one 6.5 system to another 2000
system. SQL 2000 Books Online goes into great detail on the vaious
configurations you may have. Have you read through this?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk
for your use. ? 2001 Microsoft Corporation. All rights reserved.

Quote:
> Hi:
> I have one machine running SQL Server 6.5 and another running 2000.
> I want to migrate the data from 6.5 to 2000.
> As per Microsoft documentation I can use the Upgrade Wizard to do this.
> However, the upgrade files
> were not installed during my install of the 2000 server.

> I noticed an "Upgrade" directory in the CD. I tried running the
upgrade.exe
> file and it seemed to bring up
> the wizard but then I get the error "The import server must be running SQL
> 2000" even when the import
> server was running the new SQL 2000.

> How can I upgrade from 6.5 to 2000 when they are both installed on
seperate
> machines?
> Do I have to install 2000 on the same machine as 6.5

> Thanks for the help


> AJ



Sat, 01 Jan 2005 10:20:43 GMT
 Migrating 6.5 Data to 2000
Hi:
Thanks for the response.
I've read through it many times. But I am not finding any information on how
to
get the upgrade executables installed on the machine where I installed 2000.
Seems like the upgrade executables will be installed only when I upgard from
a pervious version of SQL Server.
Since I am doing a new install of SQL Server 2000 the upgrade executable do
not
get installed.
Thanks for any suggestions

AJ



Quote:
> Yes you can definatley convert data from one 6.5 system to another 2000
> system. SQL 2000 Books Online goes into great detail on the vaious
> configurations you may have. Have you read through this?

> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk
> for your use. ? 2001 Microsoft Corporation. All rights reserved.


> > Hi:
> > I have one machine running SQL Server 6.5 and another running 2000.
> > I want to migrate the data from 6.5 to 2000.
> > As per Microsoft documentation I can use the Upgrade Wizard to do this.
> > However, the upgrade files
> > were not installed during my install of the 2000 server.

> > I noticed an "Upgrade" directory in the CD. I tried running the
> upgrade.exe
> > file and it seemed to bring up
> > the wizard but then I get the error "The import server must be running
SQL
> > 2000" even when the import
> > server was running the new SQL 2000.

> > How can I upgrade from 6.5 to 2000 when they are both installed on
> seperate
> > machines?
> > Do I have to install 2000 on the same machine as 6.5

> > Thanks for the help


> > AJ



Sat, 01 Jan 2005 11:02:12 GMT
 Migrating 6.5 Data to 2000
Okay, lets start from the beginning.  First, the upgrade
tools can be installed on your SQL Server 2000 box by
going through setup, choosing to maintain the install,
then selecting the Upgrade Tools (this is in the right
window of the select components dialog, the left window
should be set to SQL Server, I think).  

Okay, once the tools are added to your SQL Server 2000
installation (must be a default instance) you can run the
upgrade wizard.  Make sure to do this on the SQL Server
2000 machine.  When you get the import/export server
screen of the upgrade wizard, set the export server name
to that of your 6.5 server.  You can then go through the
rest of the dialogs.

Thanks.
Curt

This posting is provided "AS IS" with no warranties, and
confers no rights.

Quote:
>-----Original Message-----
>Yes you can definatley convert data from one 6.5 system
to another 2000
>system. SQL 2000 Books Online goes into great detail on
the vaious
>configurations you may have. Have you read through this?

>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk
>for your use. ? 2001 Microsoft Corporation. All rights
reserved.


>> Hi:
>> I have one machine running SQL Server 6.5 and another
running 2000.
>> I want to migrate the data from 6.5 to 2000.
>> As per Microsoft documentation I can use the Upgrade
Wizard to do this.
>> However, the upgrade files
>> were not installed during my install of the 2000 server.

>> I noticed an "Upgrade" directory in the CD. I tried
running the
>upgrade.exe
>> file and it seemed to bring up
>> the wizard but then I get the error "The import server
must be running SQL
>> 2000" even when the import
>> server was running the new SQL 2000.

>> How can I upgrade from 6.5 to 2000 when they are both
installed on
>seperate
>> machines?
>> Do I have to install 2000 on the same machine as 6.5

>> Thanks for the help


>> AJ

>.



Sun, 02 Jan 2005 04:39:54 GMT
 Migrating 6.5 Data to 2000
Hi:
When I installed my  my SQL Server 2000 I set it up as a new instance (not
the default).
Now when I try to to maintain my install and add new options I do not see
the Upgrade Tools
option in the left hand window in the install wizard.
I guess I have to do a default install to see the upgrade wizard.
AJ



Okay, lets start from the beginning.  First, the upgrade
tools can be installed on your SQL Server 2000 box by
going through setup, choosing to maintain the install,
then selecting the Upgrade Tools (this is in the right
window of the select components dialog, the left window
should be set to SQL Server, I think).

Okay, once the tools are added to your SQL Server 2000
installation (must be a default instance) you can run the
upgrade wizard.  Make sure to do this on the SQL Server
2000 machine.  When you get the import/export server
screen of the upgrade wizard, set the export server name
to that of your 6.5 server.  You can then go through the
rest of the dialogs.

Thanks.
Curt

This posting is provided "AS IS" with no warranties, and
confers no rights.

Quote:
>-----Original Message-----
>Yes you can definatley convert data from one 6.5 system
to another 2000
>system. SQL 2000 Books Online goes into great detail on
the vaious
>configurations you may have. Have you read through this?

>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk
>for your use. ? 2001 Microsoft Corporation. All rights
reserved.


>> Hi:
>> I have one machine running SQL Server 6.5 and another
running 2000.
>> I want to migrate the data from 6.5 to 2000.
>> As per Microsoft documentation I can use the Upgrade
Wizard to do this.
>> However, the upgrade files
>> were not installed during my install of the 2000 server.

>> I noticed an "Upgrade" directory in the CD. I tried
running the
>upgrade.exe
>> file and it seemed to bring up
>> the wizard but then I get the error "The import server
must be running SQL
>> 2000" even when the import
>> server was running the new SQL 2000.

>> How can I upgrade from 6.5 to 2000 when they are both
installed on
>seperate
>> machines?
>> Do I have to install 2000 on the same machine as 6.5

>> Thanks for the help


>> AJ

>.



Mon, 03 Jan 2005 03:03:34 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Difficulty in Migrating Japanese Data from SQL Server 6.5 to 2000

2. Migrating replication SQL 6.5 to SQL 2000

3. Move/Migrate SQL 6.5 to SQL 2000

4. Migrated from SQL 6.5 to SQL 2000 on NT4.0

5. migrating 6.5 databases to 2000 via Upgrade wiz

6. Move/Migrate SQL 6.5 to SQL 2000

7. Migrating from Windows NT 4.0 to Windows 2000 with sql server 6.5

8. Why migrate from 6.5 to 2000

9. Migrating from SQL 6.5 to SQL 2000

10. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

11. Distributing from 6.5 to 2000 or 2000 to 6.5

12. Migrating only SQL 7 data to SQL 2000


 
Powered by phpBB® Forum Software