Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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.