SQL Server Performance

exporting data from 7 to 2000

Discussion in 'SQL Server DTS-Related Questions' started by zedan, Aug 13, 2005.

  1. zedan New Member

    Hallo

    how can i upload data(only tables) from SQL 7 to ONLINE SQL 2000???

    thanks
  2. Luis Martin Moderator

    You can use DTS or EM, database, tables, right click, export.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. dineshasanka Moderator

    DTS is the best and easiest to do this. What about database upgrade wizard. have any body used it.
  4. Luis Martin Moderator

    I used a couple of times, sometimes good sometimes complete desaster.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  5. dineshasanka Moderator

    Luis,
    Can you share the disaster situations for our knowledge please
  6. satya Moderator

  7. Luis Martin Moderator

    Dinesha:

    OS: NT4 SP6a.
    SQL: 7.0 SP4

    The idea was to install SQL 2000 and convert 1 customer database. The database size: 15GB.

    In the middle of installation SQL 2000 fail (no messages).

    After reboot we have nothing, no 7 nor 2000.
    After severals tests, we have to remove all SQL 7, install SQL 2000 and restore databases.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  8. Adriaan New Member

    To avoid that type of disaster, why not run a full back-up of the db, and restore that under SQL 2000. The only stuff you would need to take care of would be logins and the old server being referenced from other servers.
  9. FrankKalis Moderator

  10. Luis Martin Moderator

    Of course that was my suggestion, but the IT manager choose this way.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  11. satya Moderator

    DTS is not a disaster recovery tool it only extends the feature of data import/export from other heterogenous data sources, if one is relying totally on DTS then it is nothing but risking the database itself. As suggested you can insist your customer to choose a better way than an easy way.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page