Migration from SQL 2000 to 2005

[rc]

Hi

We are going to upgrade from SQL 2002 to 2005. We have approx. 100m
rows of data on the main table and hand of stored procs and views.

What we had in mind was that we would dts the data out, script the
stored procs and view out and import the it back into SQL 2005.

Is there smarter way of doing this?
The key thing is that the data must be clean

Thanks

[Kart]

Hi,

Why can't you just backup and restore the database in 2005? You can
change the compatibility level there to 90

I have done this before on dev databases and things seemed fine.

Kart

rc@!die!.spammer.bhfshops.org.uk wrote:

Hi

We are going to upgrade from SQL 2002 to 2005. We have approx. 100m
rows of data on the main table and hand of stored procs and views.

What we had in mind was that we would dts the data out, script the
stored procs and view out and import the it back into SQL 2005.

Is there smarter way of doing this?
The key thing is that the data must be clean

Thanks

[Oscar Santiesteban]

I have "detached" the database on SQL 2000 and "re-attached" on SQL 2005
with no problems. You have to create the user logins and do the
sp_change_users_login.

<rc@!die!.spammer.bhfshops.org.ukwrote in message
news:5r********************************@4ax.com...

Hi

We are going to upgrade from SQL 2002 to 2005. We have approx. 100m
rows of data on the main table and hand of stored procs and views.

What we had in mind was that we would dts the data out, script the
stored procs and view out and import the it back into SQL 2005.

Is there smarter way of doing this?
The key thing is that the data must be clean

Thanks