Upgrade SQL Server 6.5 Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Upgrade SQL Server 6.5 Database

Author

Topic

helmysatria
Starting Member

2 Posts

Posted - 2006-11-29 : 03:35:05

Dear All,

I'v upgrade sql server 6.5 database to sql server 2000 database using "SQL SERVER Upgrade Wizard".
i get error message like this in "Export and Import via Named Piped" process:

Export Exit Code: -2147467259 - c:\progra~1\mi6841~1\mssql\upgrade\export.exe -CodePage 1252 -DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT -DatabaseName rsrw -DevicePath \\.\pipe\~cnvpipe0

An error occured while importing table. Please check the error file.
Time : 11-29-2006 15:27:19
An Error occured while exporting table MOBAT
Time : 11-29-2006 15:27:19
An Error occured while exporting database rsrw
Time : 11-29-2006 15:27:19
An error occured while importing table. Please check the error file.
Time : 11-29-2006 15:27:19

pSql65Server->DumpAllTables () failed. hr=-2147467259
Import Exit Code: -1 - ~cnvpipe0
Msg 1505, Level 16, State 1, Server SPAWN, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '008531'.

It was just upgrade Table,View and Store Procedured without data.
Something wrong with my data or anything else???

Any help will b appreciated.

Thx In advance,
Helmy

Kristen
Test

22859 Posts

Posted - 2006-11-29 : 09:21:55

"I'v upgrade sql server 6.5 database to sql server 2000 database using "SQL SERVER Upgrade Wizard""

I thought 6.5 could only be upgraded to version 7 (and then from Version 7 to 2000 or perhaps 2005)

Kristen

helmysatria
Starting Member

2 Posts

Posted - 2006-11-29 : 21:03:31

Upgrade from 6.5 to 2000 information from here:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx#EQFAC

For the other database it's work (small size database ex: 200Mb).But for database with 7 Giga size it doesn't work.
I really don't know where is the problem. :(

Kristen
Test

22859 Posts

Posted - 2006-11-30 : 01:59:35

Interesting. As far as I can remember we upgraded all our 6.5 database to 7 by just installing 7 onto the 6.5 server. Is that an option for you to try?

(And then we just installed 2000 over the top of 7, but you can also backup and restore from 7 to 2000, so you could completely clean the machine before moving to 2000 if you needed to)

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources