Tag Info

New answers tagged

0

The MSDN Blog "SQL Server SSIS and Replication" has a post from a few years ago. http://blogs.msdn.com/b/mangeshd/archive/2009/05/20/replication-snapshot-folder-cleanup.aspx How these old snapshot folders are purged depends on the type of replication you are using: For snapshot and transactional replication: Distribution cleanup agent purges the ...


0

After some more R&D i have found out about multi sourcing replication which suites solution to my problem. With the help of multisourcing i make my client pcs where actual data from devices get captured as a Master and make my Central Server as a slave.Also device data only logged in few tables so i replicate only those tables at the slave using ...


0

Same problem here, this is how I solved it find running job NAME with this somewhere in command 'Replicate_ASG_Reference_Data' use this SQL: USE master GO SELECT job.job_id,name,command FROM msdb.dbo.sysjobs job INNER JOIN msdb.dbo.sysjobsteps steps ON job.job_id = steps.job_id WHERE job.enabled = 1 AND command LIKE '%ASG%' this SQL will show 1 or ...


5

You could also solve this with a trigger that populates the copy of the table on insert/update/delete. It wasn't clear in the question that these tables are actually on different servers, and that the subscriber was unreliable. In that case you could simply log ship to the subscriber - you can get pretty close to real time here, though you will have to kick ...


1

Transaction replication would be the solution I would choose for this. More info about transaction replication can be found here: http://msdn.microsoft.com/en-us/library/ms151176.aspx To only choose the columns needed, you need to use a column filter: http://msdn.microsoft.com/en-us/library/ms151775.aspx AlwaysOn availability groups would not work ...


0

I think linked server and MERGE would be the best way to do it. Set it to run at the appropriate interval and go for it. Take care with the merge statement so that it properly detects when to do an update or not. But since they are on the same subnet, it should perform adequately. But linked servers have their own share of risks as well, make sure you ...



Top 50 recent answers are included