MS SQL data transfer

Discussion in 'Databases' started by bincem, Aug 30, 2010.

0
  1. #1
    Hello,

    I need to transfer one small MS SQL 2000 database to a MS SQL 2005 database.
    Both servers have limited access privileges.

    The solution for this is to create a SQL script containing the metadata (table definitions, procedures aso.), and use the Import/Export Wizard to fill the data in.

    Please let me know somebody can do this job. Need to do immediately.
     
    bincem, Aug 30, 2010 IP
  2. ohmohm

    ohmohm Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You should consider Data Transformation Services ( DTS ) and BCP tools.
    Find articles about migration from SQL 2000 to SQL 7 for guidelines because it is not possible to restore backup of SQL 2000 file to SQL Server 7.
     
    ohmohm, Sep 10, 2010 IP
  3. Rajeev123

    Rajeev123 Peon

    Messages:
    100
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    U have to firstly connect both server with sp_addlinkedserver then u can do data transfer from script
    like.. select * into table1 from [192.168.1.25].testdb.dbo.table1


    Thanks,
    Manoj Kumar
     
    Rajeev123, Sep 26, 2010 IP
  4. normanmagallanes

    normanmagallanes Banned

    Messages:
    701
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    45
    #4
    its a very simple thing to do, there is a stored procedure that can transfer all your data to your new server, just search for it. :)

    cheers
     
    normanmagallanes, Sep 28, 2010 IP