Questions tagged [transactional-replication]
The automated distribution of transactional changes from a publishing database to one or more subscriber databases.
0
votes
0answers
19 views
SQL Server availability groups and traditonal replication [on hold]
Could you tell if it's generally a good idea to combine AG and traditional replication?
What kind of problems a traditional replication could create for AG?
0
votes
0answers
8 views
Transactional Replication - Source/Dest table with different structure
I need to perform Int/BigInt migration on one of our large tables.
The Identity column needs to be changed from int to BigInt.
It's a very large table, hence I wanted to copy over all the data and ...
1
vote
1answer
45 views
How to read/write from replicated slave in case master went down in SQL Server?
I've created a transactional publication in SQL Server, now my requirement is to write on master and read from subscriber and in case of master going down for some reason, the subscriber should act as ...
1
vote
1answer
33 views
Where is located sp_msreplcheck_publish stored procedure?
sp_msreplcheck_publish is a sp that checks if you have sufficient rights to run a statement to alter a published table (transactional replication).
Trying to alter a published table without elevated ...
1
vote
1answer
64 views
Only SQL Server Enterprise Edition supports compression - how to work around that?
I have a script that needs to create a temp table and in that temp table I create an index.
I noticed in some of my servers, the script would go on forever, and when checking from a different session ...
0
votes
1answer
39 views
Snapshot replication vs. Transactional replication
I have come across the following scenario in a practice test:
Data from DB1 is accessed periodically by an external application.
Data from DB1 will be sent to another DB, DB2, as soon as changes ...
1
vote
1answer
42 views
Replicaton - The current transaction cannot be committed and cannot be rolled back to a savepoint
After creating a replication publication, I go ahead and create a subscription using the script below:
-----------------BEGIN: Script to be run at Publisher 'MY_PUBLISHER_SERVER'--------------
use [...
0
votes
1answer
13 views
Are Snapshot files created during MS SQL replication one time use only?
I added a new article in an existing publication.
I saw that it generated a new snapshot folder (E:\Database\Snapshots\unc\S749TCAPDB01_NFS_XXXX_XXXX_PUBLICATION\20190417114556).
But this folder ...
0
votes
0answers
23 views
Synchronizing for reporting, SSIS job vs Transactional replication or other options?
We're faced with a fun challenge. A server has 60+ databases to segment data due to privacy and security. We have 7 tables in each of these databases that need to be merged into a master dataset for ...
0
votes
1answer
39 views
Will a Transactional Replication break the LSN chain in my backups
I need to create a fairly up to date read only copy of parts of a production database for reporting purposes.
I did look at log shipping to keep the copy up to date but this will break the LSN and ...
0
votes
0answers
60 views
Transactional replication from Oracle PL/SQL to MS SQL Server broke from the data in a Date column but previous records with same date are ok?
I have a heterogenous transactional replication subscription setup between PL/SQL (12C 12.1.0.1.0) and SQL Server (2008 R2), where the Oracle PL/SQL server is the publisher and the MS SQL server is ...
4
votes
1answer
113 views
how to prevent replication to stop if there is no activity for some time?
On one of my transaction replication publications, when there is no any activity, after some time, the replication stops.
Where can I see these replication settings?
what to put in place to prevent ...
0
votes
0answers
31 views
Can MSSQL CDC be used to capture old committed transactions?
I can successfully capture change data from mssql CDC by issuing the query
cdc.fn_cdc_get_all_changes_capture_instance ( from_lsn , to_lsn ,
'<row_filter_option>' )
Here, from_lsn is the ...
0
votes
0answers
52 views
Automate Replication Scripts
In SSMS, one can "Generate Scripts..." to Create or Drop Publications and Subscriptions and Distributor configurations. Is there any way to do this automatically?
We have several people on the DBA ...
2
votes
0answers
53 views
Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?…and if PostgreSQL is the publisher?
Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle?
What if the publisher database is in PostgreSQL?
If ...
0
votes
1answer
37 views
Can an AlwaysOn Availability Group be used to mitigate downtime when there's replication syncing issues on the primary server?
Once in a while I'll run into syncing issues with my subscriber server in a transactional replication setup.
Taking a new snapshot of the publisher causes significant downtime on my subscriber server.
...
0
votes
2answers
63 views
Can Transactional Replication and triggers be used for near-realtime ETL [closed]
We want to have a data warehouse synced with our production OLTP database in near realtime. Is it possible to do this with Transactional Replication and triggers?
How we currently ETL
We use sql ...
0
votes
1answer
27 views
SQL Server Transactional Replication from 2005 to 2017
As per the msdn, Subscriber version depends on the type of publication: A Subscriber to a transactional publication can be any version within two versions (n-2) of the Publisher version. For example: ...
0
votes
1answer
29 views
Replication SQL Server 2016
Good afternoon,
I am trying to perform a transactional replication in sql server 2016, and I have the following problem.
The scenario is as follows:
A publisher server and a subscriber server, the ...
1
vote
1answer
92 views
Set up new publication on SQL Server 2014 database which is part of an availability group
I like to setup a publication (transactional replication) on a SQL Server 2014 database which is part of an availability group. We have a primary and one secondary (non-readable) replica.
On the ...
2
votes
1answer
45 views
SQL Server 2014 AOAG + Replication?
I have an existing SQL Server (2014) setup using Always On Availability Groups. All the documentation says I should not try to install replication (aka distributor role) on any of the servers ...
0
votes
1answer
51 views
How to check when a record is replicated in SQL Server
I have configured a database installed On-Premise to replicate certain tables on a Cloud SQL Server database hosted on Azure.
The replication task is scheduled to run at specific time everyday and I ...
0
votes
0answers
19 views
SQL Server replication model snapshot, transactional and merge - which method can be used
I am trying to implement sql server database replication between 2 branch servers to a Head Office Server.
My application is a distributed one, the main application is hosted on head office which is ...
0
votes
1answer
29 views
Transaction Replication on Azure MI servers
I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
0
votes
2answers
81 views
How to pause the subscriber end of transactional replication
How do I go about pausing transactional replication on the subscriber end.
We have a publisher on Server A, a distributor on Server B and a subscriber on Server C. All are in the same network.
Some ...
0
votes
1answer
59 views
Upgrade SQL Server 2008 R2 to SQL Server 2012 and then set up data replication to SQL Server 2016
Currently I have a Windows 2008 server with SQL Server 2008 R2 and I want set up a data replication to a Windows 2016 Server with SQL Server 2016.
I am aware that the aforementioned is not possible ...
0
votes
0answers
47 views
SQL Server Replication Error - The process could not connect to Subscriber
I have setup transactional replication by following link. Everything I did as per document. But when I verify synchronization status, as per mentioned link, I receive an error
The process could ...
0
votes
1answer
31 views
How to handle set up real time DML and DDL statements sync between two DB servers SQL Servers
We are looking to offload the data from a Production enviroment to a reporting environment. I currently have an SSIS package setup to extract and load data between the two servers.
However, now ...
0
votes
1answer
33 views
Replication stalling on one subscriber
I currently have transactional replication set up for three databases from the same Publisher to the same three Subscribers in SQL Server 2005. Publisher and Distributor are on the same server.
One ...
0
votes
1answer
65 views
is this time to remove the databases from the availability group? which ones?
While patching one of my servers that is part of an availability group,
as a secondary, I had some problems - the real problem was that the host machine of one of the virtual servers in the ...
1
vote
0answers
95 views
What are the requirements for SQL Replication on Azure SQL DB Managed Instance?
We are seeing if it is feasible to setup Azure SQL DB Managed Instance (SQL MI) and an Azure VM with SSMS installed for this replication scenario:
We have a vendor who needs access to our SQL Server ...
1
vote
0answers
80 views
Resynchronize transactional replication in SQL Server 2012 without doing a complete reinitialization after disk filled
We have a DB that is doing a transactional replication to one other server. There are three tables it is replicating in the DB. Yesterday the subscriber ran out of disk space. This caused the ...
1
vote
0answers
23 views
Heterogenous Database Replication
How can we establish a real time synchronization from SQL server to PostgreSQL Database? We have tried to automate the jobs in BI but that does not serve the purpose as we need real time data from ...
1
vote
1answer
63 views
How to mark a table as pre-populated with postgresql logical replication
I accidentally loaded data into a table before setting up a logical replication subscription for it and now I'm getting errors when I try to sync it (duplicate key already exists).
I can't delete ...
1
vote
0answers
62 views
Configure Always On for publisher
We have a pull transaction replication.Publisher runs MSSQL 2016.
Distributer runs on separate server with MSSQL 2016.
Is it possible to define Always On over publisher and another new server, so ...
1
vote
1answer
29 views
Enable Replication/CDC from High Availability Group
I am a newbie to this Replication concept and I am trying to build some scripts to automate our Build Process where we will be disabling/re-enabling Replication on a regular basis.
Background:
We ...
2
votes
2answers
709 views
Sql Server : How to query list of subscriptions and Articles (for a given publication) from Publisher
In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication)
Yes, there are easier ways to query from Distributor ...
1
vote
0answers
36 views
Transactional Replication from Copy Only Backup
Is it possible to use a copy only backup when initializing a subscriber from a backup?
I've been trying it but getting all kinds of issues with:
Trying to update records that don't exist
Inserting ...
1
vote
1answer
285 views
how azure sql geo replication works internally?
My company moved to azure and started to use azure Sql database and geo replication.
For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup ...
2
votes
1answer
481 views
Efficiently bulk upsert unrelated rows
As part of a manual replication process between databases with different but related schemas, for each table, we identify new and modified records in the source database and feed them via a table ...
6
votes
1answer
207 views
Database Compatibility Requirement for Transactional Replication
Does the subscriber "within two version requirement" for transactional replication from this MSDN article apply to the SQL Server Instance, Database Compatibility Level, or Both?
For example, would ...
2
votes
0answers
46 views
Foreign Key Error with Transactional Replication from Backup
I'm getting a missing foreign key error when I begin transactional replication.
Steps taken:
Created a pull publication (live server)
Created a copy only full backup
Restored backup on reporting ...
0
votes
0answers
261 views
Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) two times
Whenever I have to drop a publication I follow the steps below,
ending by a call to sp_droppublication when I get the error below two times.
The publications seems to have been dropped successfully ...
1
vote
1answer
34 views
I want to Create a brand new slave for my MySql Percona server 5.7
I have a Master Master Replication setup using mysql Percona Server 5.7, but for some unknown reasons, seems like my passive server is broken "thats not the issue", the replication is bad and the data ...
0
votes
2answers
31 views
Transactional replication failure handling
Web Application is High school record management system (HSRMS). Users of the application are
High school management (Normal Users)
Data verifying users (Admin)
User group 2 will allow the User ...
4
votes
1answer
341 views
Can I use only 1 user for SQL Server replication?
I want to setup transactional replication on sql server. By following the instructions of the ms replication preparation tutorial and the ms replication configuration tutorial, everything works fine.
...
1
vote
1answer
116 views
Transactional Replication Synchronization taking too long to respond
I successfully generated the snapshot, but subscription is not working correctly. Either the synchronization takes too long to respond or it simply displays the text shown in below attached screenshot....
1
vote
1answer
120 views
Cleaning up MSrepl_errors, SQL Server Replication
Our MSrepl_errors table is around 15GB and got records from the beginning of time.
What is the correct way of cleaning up this table. Do we simply delete from it?
Edit
The distribution agent clean ...
0
votes
1answer
37 views
what is a safe way to stop the logreader?
Applying cumulative updates and service packs on sql server 2016 -
The server is involved in transactional replication, being a publisher,
The server is also a virtual machine.
I need to stop the ...
1
vote
1answer
58 views
is there a way to improve this query by not re calculating functions? cross apply?
when I set up replication I like to take a count of each table in the publisher, then I go to the subscriber I do the same thing in order to compare both pictures.
this is the picture from the ...
