SQL Server migration from 6.5 to 7.0


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: SQL Server migration from 6.5 to 7.0

  1. #1
    Shantha Gowda Guest

    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
    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,




  2. #2
    Michael Levy Guest

    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
    http://www.microsoft.com/sql/techinfo/Upgrade.htm

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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center