transactional-replication
Can SQL Transactional Replication work between SQL 2005 Standard (Publisher) and SQL 2008 R2 Web (Subscriber)?
I\'ve been trying, googling and hitting my head against the wall but can\'t figure our what the problem is or how to solve it.[详细]
2023-04-11 04:10 分类:问答Was this subscription initialized?
Running SQL 2008... Where can I find in the SQL dB or how can I determine if a transac开发者_JAVA百科tional subscription was initialized when it was created??[详细]
2023-04-01 14:22 分类:问答Transactional Replication on a table carrying incompatible data type
I am trying to implement a transactional replication in 2008. Both the publisher and subscriber are in 2008 version.So far so good.[详细]
2023-03-27 18:22 分类:问答Change Database Structure on Table being Replicated
I need to make structure changes to a database that is part of a subscription that is using Transactional Replication.[详细]
2023-03-14 14:48 分类:问答Replication and CDC SQL 2008r2 what causes some replicated tables to drop CDC?
Transactional replication from SQL 2005 into SQL 2008r2.CDC established on SQL 2008r2 side.Each day, from 2 to 4 of these tables lose their CDC settings (ie. is_tracked_by_cdc in sys.tables moves from[详细]
2023-03-09 21:00 分类:问答Validation stored procedure for Replication
Does anyone know of the correct stored procedure that validates the actual code in transactional replication?I have a view that basically is a select * from table1.I changed that view to select * from[详细]
2023-03-05 00:36 分类:问答Problems with Entity Framework Model when Transactional Replication active
I have a situation where I use SQL server transactional replication from my main database 开发者_如何学Pythonto my failover database. I have a main site and my fail over website is using my failover d[详细]
2023-02-27 01:23 分类:问答Replicate SQL Server CLR Function
Is it possible to replicate a CLR Function using Transact开发者_JAVA百科ional (or Merge) Replication?Yes. See: Publishing Data and Database Objects[详细]
2023-02-09 07:02 分类:问答SQL Transactional Replications with triggers running concurrently
I have setup SQL Server transactional replication to run continuously for two tables (Parent and child records). At the subscriber end, I have insert and update triggers on both replicated tables.[详细]
2023-02-07 08:13 分类:问答Oracle-to-SQL Server replication: manipulate data during replication
I\'ve \"inherited\" a working Oracle (10g) to SQL Server 2005 data replication using standard SQL Server snapshot and transactional replication.[详细]
2023-02-06 21:56 分类:问答