Upgrading from Sql Server 7 to Sql Server 2008

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Upgrading from Sql Server 7 to Sql Server 2008

Author

Topic

sirajulmuneerks
Starting Member

1 Post

Posted - 2010-03-24 : 04:34:10

Hi everbody,
One of our clients is having SQL Server 7 db installed on SBS 4.5. They are now upgrading to SQL Server 2008 on SBS 2008. I want to know the actual upgrade process for the SQL Server 7 to SQL Server 2008. Also will a restore of SQL Server 7 backup file on SQL Server 2008 will do the job.

Thanks in advance

Sirajul Muneer K.S

Kristen
Test

22859 Posts

Posted - 2010-03-24 : 04:47:50

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 for details of migration process

There is a link on that post to specifics related to SQL2000 to SQL2005 - in case there was anything that was part of that process which is not also reported in the SQL2008 process.

I expected there is a SQL7 to SQL2000 thread here somewhere!

You cannot restore a SQL7 backup to SQL2008 - so you will have to restore to either SQL2000, or SQL2005 (either can restore SQl7 backup file), and re-backup to then restore on SQL2008

Kristen
Test

22859 Posts

Posted - 2010-03-24 : 04:51:41

See also:
http://www.sqlteam.com/article/upgrading-from-sql-7-to-sql-2000-part-1
http://www.sqlteam.com/article/upgrading-from-sql-server-7-to-2000-part-2

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-25 : 03:40:52

Also beware of the behavioural changes that can happen after the migration
http://msdn.microsoft.com/en-us/library/ms143359(SQL.90).aspx

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2010-03-25 : 04:43:55

Forum has cut off your URL Madhi (and the core URL takes me to SQL2008)

http://msdn.microsoft.com/en-us/library/ms143359(SQL.90).aspx

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-25 : 04:58:31

quote:
Originally posted by Kristen

Forum has cut off your URL Madhi (and the core URL takes me to SQL2008)

http://msdn.microsoft.com/en-us/library/ms143359(SQL.90).aspx

This forum stops links as soon as it detects (

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2010-03-25 : 05:09:03

Yeah, and you can't stick it in a [URL] either -

[URL="xxx"]yyy[/URL]

sees the HTTP in the "yyy" bit, and treats that as a URL - so you wind up with one stopped at the "(" again

You can do

[URL="http://www.example.com"]SomeText[/URL]

as the "SomeText" text bit doesn't contain HTTP ... but what a palaver eh?!!

If you want the URL in the visible bit you have to do:

[URL="http://www.example.com"]http[black]:[/black]//www[black].[/black]example.com[/URL]

to prevent the inner URL being parsed. Palaver ** 2

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-25 : 05:12:24

quote:
Originally posted by Kristen

Yeah, and you can't stick it in a [URL] either -

[URL="xxx"]yyy[/URL]

sees the HTTP in the "yyy" bit, and treats that as a URL - so you wind up with one stopped at the "(" again

You can do

[URL="http://www.example.com"]SomeText[/URL]

as the "SomeText" text bit doesn't contain HTTP ... but what a palaver eh?!!

If you want the URL in the visible bit you have to do:

[URL="http://www.example.com"]http[black]:[/black]//www[black].[/black]example.com[/URL]

to prevent the inner URL being parsed. Palaver ** 2

Thanks. Thats why TESTing is needed

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources