SQL Server Performance

Export a database from SQL 6.5 to SQL 2000

Discussion in 'General DBA Questions' started by rajoo, Feb 5, 2003.

  1. rajoo New Member

    Hi

    I have databases in SQL 6.5 that I have to import into a SQL 2000 instance. I tried to find out in the books online but most of the time it refers to upgrading of 6.5 to 2000. Is there any method I can backup/export by 6.5 databases and then re-import into a SQL 2000 instance.

    Thanks
  2. satya Moderator

    If you want to export the whole 6.5 database to 7 or 2K then you should choose UPGRADE which is reliable and legendary. Also you can use DTS but not all the objects will be transferred.

    Follow the BOL for information provided.

    Satya SKJ
  3. rajoo New Member

    Thanks Satya, I found some notes and FAQs in the books online and it seems that I have to use the Upgrade wizard.

    But now I have another problem. The notes say:

    quote:
    On the Start menu, point to Programs/Microsoft SQL Server-Switch, click SQL Server Upgrade Wizard, and then click Next.

    Now I can't find the "Upgrade wizard" in my menu. Is there an executable that I can launch directly?

    Thanks again for your help.
  4. joachim.verhagen New Member

    You have to install the upgrade wizard when you install SQLServer 2000.

    If SQLServer 6.5 and 2000 are on different machines, I would create a script of the 6.5 database and run that on the 2000 database for the definitions.

    Next you can use DTS to transfer the data.

    This works fine for me.
  5. rajoo New Member

    Thanks everyone.
  6. satya Moderator

    On top of 6.5 installation when you install SQL 2K it will install this Upgrade option under the programs group.

    How the SQL 2K instance is it Named or Default?

    Satya SKJ
  7. rajoo New Member

    The SQL 6.5 is the default and the SQL 2000 is a named instance. However, the upgrade option is nowhere to be found. Is there anyway I can re-install just the upgrade wizard? Would I then have to re-apply the service pack 3?

    Thanks
  8. satya Moderator

    Install SQL 2K as default instance.

    Satya SKJ
  9. rajoo New Member

    Thanks Satya. [xx(] Unfortunately the SQL 6.5 must remain the default. I have the impression I'll have to take the bcp route to transfer my 6.5 databases. Any suggestions?
  10. satya Moderator

    If the 6.5 system must be used, then you can use DTS for the data transfer. By any chance to get optimum performance for SQL 2K then upgrade wizard is best suitable.

    Ofcourse BCP would be ideal for the data transfer too, but it should run table by table.

    HTH

    Satya SKJ

Share This Page