Results 1 to 2 of 2

Thread: Migration Task

  1. #1
    Join Date
    Feb 2003

    Unhappy Unanswered: Migration Task

    Hi guys.

    I have a hard task to solve. I need to migrate 3 databases from an old SQL 6.0 (yes, it still exists!) to a new SQL 2000. These 3 dbs contain only tables and stores procedures. The sizes are:

    DB_INews : 6.0GB
    DB_Balanco : 600MB
    DB_Invest : 100MB

    I think I will have problems with DB_INEWS, because it contains tables with 2 million lines.

    What is the best option to do this migration?



  2. #2
    Join Date
    Aug 2002
    IF the databases are in SQL 6.0 version the only way is to upgrade it to 6.5 version and then choose UPGRADE WIZARD from 6.5 to SQL 2000. There is no other go to migrate data directly.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts