Posted by Kart on 10/18/06 16:54

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

[Back to original message]