Post reply

copy table with data from one server to other

  • November 24, 2014 at 6:31 am

    #313395

    Hi all,

    I am having SP which gives dynamic resultset. i.e.number of columns varies from min 5 to max 10.

    I am able to create a table with this SP in server A.

    Now I want to move this created table from server A to server B

    for next execution i want to drop this table from server B and again create dynamic table in server A and move it to B

    How could i do this? please help.

    Regards

    Abhas.

  • November 24, 2014 at 7:29 am

    #1760513

    abhas (11/24/2014)

    Hi all,

    I am having SP which gives dynamic resultset. i.e.number of columns varies from min 5 to max 10.

    I am able to create a table with this SP in server A.

    Now I want to move this created table from server A to server B

    for next execution i want to drop this table from server B and again create dynamic table in server A and move it to B

    How could i do this? please help.

    Regards

    Abhas.

    Easiest: add a link from server A to server B, then you can refer to the tables in server B while running on server A using 4-part object names (server.database.schema.object)

    Slightly harder (if you cannot do a linked server), use SSIS to do it for you.

    Gerald Britton, Pluralsight courses

Viewing 2 posts - 1 through 1 (of 1 total)

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