Hi,
We have a system based on SQLServer 7.
We want to migrate this to SQLServer 2008.
Is this possible or do we need to pass through an intermediate
version?
Is there a recommended procedure for performing the upgrade?
thanks
Bob

Bob,

According to Microsoft, SQL Server 7.0 to 2008 is not a supported upgrade
path. (Note: This also means that you cannot restore a SQL Server 7.0
backup to SQL Server 2008.)
http://msdn.microsoft.com/en-us/library/ms143393.aspx

The Books Online has this guidance on copying a database from a SQL Server
7.0 server to a SQL Server 2008 server. Either by doing an intermediate
upgrade to 2000 SP4 or to 2005, or by using Import Export wizards or bcp to
move the data.
http://msdn.microsoft.com/en-us/library/ms177398.aspx

I strongly recommend doing the intermediate upgrade over using the wizards
and/or bcp scripts.

RLF


"bob" <startatbob_clegg (AT) cutthis (DOT) adriley.co.nz> wrote

Hi Russel,
Thank you.
regards
Bob
On Thu, 20 Aug 2009 14:36:38 -0400, "Russell Fields"
<russellfields (AT) nomail (DOT) com> wrote: