up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

2 Answers

up vote 3 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.

link|improve this answer
+1 yeah, a LITTLE too old for direct upgrade. – TomTom May 12 '10 at 18:14
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard