Discussion in 'General DBA Questions' started by TimE_DCT, Sep 21, 2009.
I am currently running SQL 7 and need to upgrade to SQL 2008. Is this possible?
Welcome to the forum
You can not upgrade from sql 7 to sql 2008
The minimum version to upgrade to sql server 2008 is SQL 2000 SP4
You can do one of the two methods:
- make upgrade to 2000 SP4 or to 2005 then sql2008 (the prefered method)
-generate schema /login script in sql 7 and execute them in sql 2008 , and use bcp to move the data ,
Welcome to the forums.
For you the ease of path is you can simply restore SQL 7 database to 2000 which is patched upto SP4 as per Moh's reference and then carry further.
Thanks to both. With needing to upgrade to 2000 first, will it require a license other than the one for 2008?
How big is the database?
How many users are using the SQL SErver 7 and for 2008?
Separate names with a comma.