Post reply

copy table data between 2 sql servers in sql server 2008

  • September 8, 2014 at 4:47 am

    #397313

    hi ALl,

    can you please provide the possible ways to do this task.

  • September 8, 2014 at 4:59 am

    #1743817

    kbhanu15 (9/8/2014)

    hi ALl,

    can you please provide the possible ways to do this task.

    Easiest would be to use Import Wizard of sql server, fetch the data from the source

    create a staging(new) table and dump the data in that table.

  • September 8, 2014 at 5:00 am

    #1743818

    thank you

  • September 8, 2014 at 5:12 am

    #1743822

    you are welcome.

  • September 8, 2014 at 6:39 am

    #1743839

    Other choices include using SQL Server Integration Services (SSIS), bulk insert, linked servers and regular t-sql, or just use a programming or scripting language to connect to both servers. You could do the last thing through PowerShell.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • September 9, 2014 at 6:32 pm

    #1744283

    1.

    SELECT *FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=192.168.1.78;User ID=sa;Password=123' ).Northwind.dbo.Categories

    2. add linkServer

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply