Replicating one table. May I use a linked server?

  • 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.

  • 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.

    😎

  • Thank you Eirikur.

    Kind regards,

    Tommy.

  • 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