Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have several pretty large databases located in a SQL Server 7 box. Whats the best way to get them into SQL Server 2008? As far as I know, there were changes to the underlying file structures so I am not sure that a simple detach/attach would work.

When I tried attaching from 2008 it complained strongly. "Version no longer supported" etc etc. What options do I have? Are there any tools on the market that can connect to both 7 and 2008 and then move the schema and data?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

You'll need to attach them to a SQL 2000 or SQL 2005 instance first, then attach them to a SQL 2008 instance. There's no direct upgrade path from SQL 7 to SQL 2008.

share|improve this answer
    
+1 yeah, a LITTLE too old for direct upgrade. –  TomTom May 12 '10 at 18:14

Couldn't you do this with a backup, script your DB creations, and then apply those in the new server?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.