Converting from SQL Server 2000 to 2005 for ASP.NET web App

tags:

sql-server-2005

views:

31

answers:

3

+2 Q:

Converting from SQL Server 2000 to 2005 for ASP.NET web App

Hi there, I'm moving my ASP.NET website to a new provider. Only problem is, old host support my SQL Server 2000 db. New host only supports SQL Server 2005. How should I go about the conversion ? Can I simply produce a backup of the 2000 (.bak) file at the old host, and restore that file into SQL Server 2005 at the new host ? Or is there more to it ??

Note that I don't own a copy of SQL Server 2005 at home... and I'm trying to avoid having to do so.

Thanks, Bazza

+1 A:

Generate Deployment scripts using "Database Publishing Wizard" for your Sql200 database and select target dataabse type as "sql2005". It should work flawlessly as we have experienced the same in past.

this. __curious_geek 2010-04-14 05:50:16

Hi thanks for quick response..Is the "Database Publishing Wizard" part of the SQL Server Enterprise Manager for 2000 ? I couldn't see that wizard anywhere ??Thanks

Bazza Formez 2010-04-14 05:57:53

Sorry.. just saw the link... i've downloaded the publisher. thanks again.

Bazza Formez 2010-04-14 06:07:18

Just tried that.. it seems to have worked really well. thanks again!

Bazza Formez 2010-04-14 06:11:55

you can mark the answer as acdepted if it's worked for you.

this. __curious_geek 2010-04-14 06:43:01

I don't seem to get a vote ?? Too new as a user on this site perhaps ?

Bazza Formez 2010-04-14 07:19:57

you will find a check-mark option below the vote-count of my answer. You shall click on it to mark my answer as accepted answer by you. This will help others to easily find the right workable solution for the query he might have similar to your question - and of course it will gain me some reputation on SO.

this. __curious_geek 2010-04-14 08:07:25

+2 A:

Simple restoring of backup is enough. It workes fine for me.

x2 2010-04-14 05:54:38

I've never had a problem restoring 2000 backups onto 2005 either.

kristian 2010-04-14 05:56:31

A:

Do you use Data Transformation Services (DTS)? This SQL Server 2000 feature can't be migrated right away into SQL Server 2005. You'll have to migrate your DTS-packages to SQL Server Integration Services.

Running the SQL Server 2005 Upgrade Advisor helps identifying this issue.

Gerard Peter 2010-04-14 08:57:16

Not strictly true. The "backward compatibility" components can be installed to allow SQL 2005 to run DTS packages.

Ed Harper 2010-04-14 11:06:47

Ah, ok, thanks.

Gerard Peter 2010-04-14 11:41:46

ansaurus

tags:

views:

answers:

Converting from SQL Server 2000 to 2005 for ASP.NET web App

related questions