Posted by rc on 10/18/06 14:00

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

• Next in forum: Re: sql statement to select customers contributing top 60% of sales
• Prev in forum: Re: sql statement to select customers contributing top 60% of sales
• Thread view: Migration from SQL 2000 to 2005

[Reply to this message]