SQL Server Performance

How can we copy the Database from Existed Data base in the SQL server 7.0?

Discussion in 'T-SQL Performance Tuning for Developers' started by mallik143_swa, Aug 30, 2007.

  1. mallik143_swa New Member

    How can we copy the Database from Existed Data base in the SQL server 7.0 or T-SQL?
    Please give me solution ...
    Thank you
    Malli
    mallik143_swa, Aug 30, 2007
    #2

  2. Luis Martin Moderator

    Backup and restore?
    Luis Martin, Aug 30, 2007
    #3

  3. Adriaan New Member

    It isn't really clear what you're asking ...
    You have an existing database that you want to copy, and you talk about SQL 7.0.
    Do you have an instance of SQL Server 7.0 with a database, and you want to copy the database to an instance of SQL Server 2000 or 2005?
    Or do you have a backup (or just the MDF and LDF files) of a SQL 7.0 database, and you want to load this on an instance of SQL Server 2000 or 2005?
    Please elaborate!
    Adriaan, Aug 30, 2007
    #4

  4. satya Moderator

    True, in this case you have to very clear about what you want.
    Also Luis gave the hint there to get you more information.
    satya, Aug 31, 2007
    #5

  5. Jack Vamvas Member

    Depending on what servers these dbs are running, you could generate the T-sql for all the objects from your sql 7 , and rerun the scripts in your sql 2000/2005 setup.
    Jack Vamvas, Sep 4, 2007
    #6

Share This Page