Post reply

Replicating one table. May I use a linked server?

  • October 18, 2014 at 5:36 am

    #294222

    Hi,

    I have to regularly pull data from a table on another instance

    (only INSERTs into this table) into a local table.

    The first idea was to use transactional replication.

    Then I thought that for maintenance ease I will use a linked server.

    I know that linked servers have performance issues in some cases,

    but I don't think we will have them here since we have a simple SELECT

    according to the ever increasing PK.

    Do you think it will be correct to use a linked server in this case?

    Thanks,

    Tommy.

  • October 18, 2014 at 5:58 am

    #1753308

    Linked server should be fine, even an SSIS packet on a schedule would probably do fine, all depends on the frequency required, transactional replication is probably an overkill in this case.

    😎

  • October 18, 2014 at 6:05 am

    #1753309

    Thank you Eirikur.

    Kind regards,

    Tommy.

  • October 19, 2014 at 7:42 am

    #1753357

    LInked servers are not particularly efficient at transfering data. They can be ok for small data sets or whenever performance is not an issue.

    With big data sets, a better approach would be a small SSIS package invoked by a job.

    -- Gianluca Sartori

Viewing 4 posts - 1 through 3 (of 3 total)

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