You are here: Re: Options to upgrade an SQL 6.5 DB to 2000 « MsSQL Server « IT news, forums, messages
Re: Options to upgrade an SQL 6.5 DB to 2000

Posted by Bernard Peek on 11/16/05 13:16

In message <Xns97101041BF43Yazorman@127.0.0.1>, Erland Sommarskog
<esquel@sommarskog.se> writes
>Laphan (info@SpamMeNot.co.uk) writes:
>> I know that if SQL 6.5 was on a server and you then install SQL 2000 on
>> it you get the wizard option to upgrade an SQL 6.5 DB to 2000, but I
>> don't have the luxury of this.
>>
>> I have an SQL 6.5 DB, which I want to convert, but only SQL 2000 on my
>> server.
>>
>> Do you know what options I have available to me to perform this upgrade
>> with what I have? Are there any free external tools that can do this
>> conversion for me other than the switch wizard?
>
>There is exactly one tool in this world that can read a 6.5 database,
>and that's SQL Server 6.5.
>
>If you have access to MSDN Subscriber Downloads, SQL 6.5 is available
>there.

I recall upgrading a database from SQL Server 7 to 2000. All I did was
to copy the database file and attach it. I don't know whether the same
process would convert a version 6.5 file.

Make a copy of the database file(s) and try it.


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация