Tag Info

New answers tagged

0

You do not mention whether you are using SQL Server 2012 or 2014, however the documentation on CDC and Change Tracking do not show much difference. Both make the following statement: "CDC configuration is always performed on the current or intended primary replica." http://msdn.microsoft.com/en-us/library/hh403414(v=sql.120).aspx#CDC The above link is ...


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

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