SQL Server migration from 6.5 to 7.0
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
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.
Re: SQL Server migration from 6.5 to 7.0
SQL Server 7.0 has an upgrading wizard designed for this purpose. MS has a
whitepaper that would probably be helpful. Check out
Michael Levy MCDBA, MCSD, MCT
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL