Results 1 to 2 of 2

Thread: Migration Task

  1. #1
    Join Date
    Feb 2003
    Posts
    4

    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?

    Cheers,

    Fabiano

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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