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 2008 Forums
 SQL Server Administration (2008)
 Import from MS SQL 6.5

Author  Topic 

tmccar
Starting Member

27 Posts

Posted - 2011-08-27 : 14:51:19
I have a database from MS SQL 6.5 that I would like to read in 2008 and ideally, to convert to Excel or XML format. What is the best way to achieve this?

Tom Mc Carrick

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-08-27 : 17:43:06
You cannot upgrade from 6.5 to 2008 directly. You could upgrade a 6.5 instance to SQL 2000, and from there either upgrade the 2000 instance to 2008, or make a backup from 2000 that can be restored to a 2008 instance. If you have a backup of the 6.5 database you could restore that to a 2000 instance, and follow the same procedure to go to 2008.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-09-05 : 02:30:49
Done. You can download the zipped text files from ftp now.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -