October 18, 2014 at 5:36 am
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
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
Thank you Eirikur.
Kind regards,
Tommy.
October 19, 2014 at 7:42 am
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