transactional-replication
Replication problem (distribution with subscriber) in SQL SERVER 2008 R2
We have transactional replication between two MS SQL Server 2008 R2. Our servers were rebooted because of failure of a hard drive.[详细]
2023-01-31 07:05 分类:问答Adding new article to transactional replication gives error at subscriber
I have an updatable transactional replication set with SQL Server 2008. Everything is working fine. I added a new table to the existing publication thru sp_addarticle followed by sp_addsubscription. A[详细]
2023-01-18 15:29 分类:问答Can you replicate data from MS SQL Server 2005 to MySQL 5.1 one-way?
I need to set up a one-way transactional replication from a SQL Server 2005 database to MySQL 5.1 Database.[详细]
2023-01-17 18:34 分类:问答New table not showing up in publication's article list in SQL Server 2008
I\'m very new to SQL Server. I just had someone transfer my entire database from Access to SQL Server and I\'m trying to get up to speed.[详细]
2023-01-12 12:40 分类:问答Replication related issue,
Replication related issue, I am explaining my architecture . I have created , its transactinal replication process[详细]
2023-01-05 09:21 分类:问答Adding to the schema of a subscribing database
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3). I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the p[详细]
2022-12-30 00:32 分类:问答Synchronizing in SQL Replication works when manually syncing, but not automatically
I\'m using SQL Server 2005 to create a replication copy of the main databases, so that the reports can point to the replication copy instead of locking out our main databases.[详细]
2022-12-29 17:44 分类:问答Can I add a delay to sql server transactional replication?
I\'ve got transactional replication configured from a database called DBProd to another database called DBWarehouse ; everything works fine, and transaction are usually replicated instantaneously to t[详细]
2022-12-28 22:24 分类:问答Consolidate data from many different databases into one with minimum latency
I have 12 databases totaling roughly 1.0TB, each on a different physical server running SQL 2005 Enterprise - all with the same exact schema. I need to offload this data into a separate single databas[详细]
2022-12-24 06:45 分类:问答wait for transactional replication in ADO.NET or TSQL
My web app uses ADO.NET against SQL Server 2008. Database writes happen against a primary (publisher) database, but reads are load balanced across the primary and a secondary (subscriber) database. We[详细]
2022-12-16 16:59 分类:问答