Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrading SQL 6.5 to 2000 or higher


Upgrading SQL 6.5 to 2000 or higher

Author
Message
alex_briseno22
alex_briseno22
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 13
Hi , I´d like to know the right procedure to migrate an old version sql 6.5 to Sql 2000 and the right Sql 2000 Collation or equivalent that I need to install in the new Sql 2000 before migrate.
This is the 6.5 collation .

Sort Order Description ------------------------------------------------------------------
Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. Sort Order = 52, nocase Case-insensitive dictionary sort order for use with several We stern-European languages including English, French, and German . Uses the ISO 8859-1 character set. Characters, in Order ------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ ·

I was wondering if I could use the DTS to transfer data when the sql2000 is already on.
I think that I need to migrate to 2000 before migrate to 2005 or higher , I'm right ??


Thks a lot.

Alex.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36146 Visits: 18750
If you upgrade to SQL 7, you can move to 2005.

http://msdn.microsoft.com/en-US/library/ms143393%28v=SQL.90%29.aspx

However, DTS was better in SQL 2000. You ought to be able to restore the database from v6.5 backup to 2000 directly, and that would set your collation. In newer versions of SQL, you don't need the server collation to match, so you can have separate collations for the database.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
alex_briseno22
alex_briseno22
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 13
Hi...thks for your quick response

I tried to restore the database directly in sql 2005 but I got this error.

Msg 3241, Level 16, State 0, Line 1
The media family on device 'D:\Database.dat' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

The 6.5 Backup it's fine, because I restored the same backup on the 6.5 server and there is no problem.
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6208 Visits: 5314
I don't remember being able to do restores from 6.5 to 7 or 2000. The file structure is ENTIRELY different, first big difference V4-6.5 used 2K pages, 7-Present use 8K pages.. And thats only the start.. I think you need to use the wizard and migrate the database from 6.5 to 2000 and then you should be able to attach or backup/restore it to any same or higher version..

CEWII
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36146 Visits: 18750
I thought that SQL 7/2000 could restore up from v6.5, but maybe not. This mentions the upgrade wizard, which might just be a DTS transfer

http://msdn.microsoft.com/en-us/library/aa176562(v=SQL.80).aspx

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6208 Visits: 5314
I used the upgrade wizard to go from 6.5 to 2000 in ~2002, it worked pretty good. That wizard didn't do anything with DTS since it didn't exist in 6.5. It might have handled it for 7 to 2000...

CEWII
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36146 Visits: 18750
Isn't the upgrade wizard part of 2000 though, not v6.5? So it might be doing a script objects/ bcp data, which is all that the DTS xfer database does.

In any case, I think that to move you might need to do that to get to 2000, then upgrade those dbs to 2005.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
alex_briseno22
alex_briseno22
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 13
Ok...I'll try to do it using the upgrade wizard, and I'll let you know if works or not..

Thks a lot for your comments, I hope...everyting goes well
Meet George Jetson
Meet George Jetson
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2637 Visits: 1393
Sorry I am a little late to the party but Elliott is correct. Using the Wizard is the most efficient and less stressful way to upgrade a 6.5 database. The one annoying part of upgrading to 7 was having to step through the service packs.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Elliott Whitlow
Elliott Whitlow
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6208 Visits: 5314
I don't think you have to go through 7, I seem to remember going directly from 6.5 to 2000, this was in like 2002 so it was a while ago but I'm pretty sure we didn't go through 7..

CEWII
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search