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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-03 : 07:51:34
|
| David Orr writes "I have a raw (not backup) datafile from 6.5. Unfortunately, I only have SQL server 7.0 installed. Is there a way to attach/import the 6.5 datafile into 7.0?Thank you in advanceDavid" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-03 : 16:12:51
|
| I think you are SOL.You'll need to be running SQL 6.5 in order to import it into SQL 7 or SQL 2K. I am not aware of any other method to do this. I had a similar situation last year and we had a heck of a time finding 6.5 media in order to bring the database online.btw, Microsoft no longer supports SQL 6.5 at all. You can't even call them to get the 6.5 media any more.-ec |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-03-03 : 16:52:44
|
quote:
Originally posted by eyechart
I think you are SOL.You'll need to be running SQL 6.5 in order to import it into SQL 7 or SQL 2K. I am not aware of any other method to do this. I had a similar situation last year and we had a heck of a time finding 6.5 media in order to bring the database online.btw, Microsoft no longer supports SQL 6.5 at all. You can't even call them to get the 6.5 media any more.-ec
Not entirely true. They offer best effort support. If they know the answer, or can figure it out, they will help you, but they aren't going to be doing any code fixes.-Chadhttp://www.phxpoker.comPhoenix's largest online poker community |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-03 : 17:15:01
|
quote:
Originally posted by chadmatNot entirely true. They offer best effort support. If they know the answer, or can figure it out, they will help you, but they aren't going to be doing any code fixes.
Actually, they won't support you at all on the phone.from http://support.microsoft.com/gp/lifesrvrquote:
Extended support ended 31-Jan-2002. Since that time, Microsoft has been providing "commercially viable efforts" to address customer issues, but not providing hotfixes. After 31-Mar-2004, this product will be obsolete and assisted support will no longer be available from Microsoft. Online self-help support will continue to be available until at least 30-Jun-2004.
-ec |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-03-03 : 17:32:20
|
| I stand corrected. This is a new policy since I worked there. We never used to end "Best Effort" support, in fact we still supported SQL 4.2 on a best effort basis when I was there, luckily I never received a 4.2 case.I can't believe people are still using 6.5.-Chadhttp://www.phxpoker.comPhoenix's largest online poker community |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-03 : 19:31:56
|
I am not sure that there is even an easy way to bring a raw 6.5 datafile into 6.5, let alone 7.0. The data files in 6.5 were actually just containers for the databases segments for data, logs, or data and log, and could have lots of different databases in them. The segments for a database could be distributed over many differnet files.Maybe the SQL Server 6.5 tech gurus might know a way to do this, but I wouldn't count on it. I know that I have have never seen any info on how to do it.The only way I know to get a SQL 6.5 database back is from a database backup, and even there you had to create the database segments for the DB you are restoring into exactly the same as the database that was backed up. It sounds like don't have the info on the DB segment sizes if all you have is a raw data file.quote:
Originally posted by AskSQLTeam
David Orr writes "I have a raw (not backup) datafile from 6.5. Unfortunately, I only have SQL server 7.0 installed. Is there a way to attach/import the 6.5 datafile into 7.0?Thank you in advanceDavid"
CODO ERGO SUM |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-03 : 19:41:36
|
| Assuming you can't upgrade an existing 6.5 server to 7.0, your only other recourse is to get an instance of 6.5 running and use bcp to export the data into files. You'd have to then manually create the tables in a 7.0 database and then import the files using bcp or BULK INSERT. You still need a running instance of SQL 6.5 to do the export though.You CAN still get 6.5 from MSDN Subscriptions, at least under a Universal sub. Also, check around for any OLD copies of Visual Studio 6.0, there was a developer or trial version with the original shipping versions (1998) |
|
|
|
|
|
|
|
|
Upgrading from SQL Server 6.5 to 7.0