SQL Server migration from 6.5 to 7.0

[Shantha Gowda]

I am having tough time in transferring objects from SQL Server 6.5
to SQL Server 7.0 for my migration work.

Can any one give me how should I proceed do this task.

Using DTS package, I can transfer tables and data from 6.5 to 7.0 without
any problem.

I want to transfer other objects like Stored Procedures, Views, rules, ...
on to SQL Server 7.0 box.

I tried using generating script on 6.5 server and run it on 7.0
lists some errors.I don't want to remove these production server errors,
I want to keep it as it is on to new server.
(It is not a clean up job, migration work)

Is there is any way, so that instead of using above scripting method, I can
blindly transfer objects from 6.5 server to 7.0.

Kind Regards,

[Michael Levy]

SQL Server 7.0 has an upgrading wizard designed for this purpose. MS has a
whitepaper that would probably be helpful. Check out
http://www.microsoft.com/sql/techinfo/Upgrade.htm

-Mike
--
Michael Levy MCDBA, MCSD, MCT
michaell@gasullivan.com