All Questions
Tagged with database-replication sql-server
282 questions
0
votes
1
answer
68
views
Create named instance in SQL Server Express
I'd like to pull some data into SQL Server Express, from a high-current electrical test machine running SQL Server.
The first problem I'm experiencing is that I can't get replication setup, because ...
- 2,667
1
vote
0
answers
54
views
Suppress DBCC messages for sp_addarticle
Anyone know how to turn off this unwanted output? I have several stored procedures that are used to tear down and rebuild replication for hundreds of databases.
These stored procedures output lots of ...
- 35
0
votes
2
answers
46
views
SQL Server read only failover database CLR enabled
We have enabled CLR on the primary database with a read only synchronized readonly failover database and it works perfectly using the following instruction.
IF EXISTS (SELECT * FROM sys....
- 1,043
0
votes
1
answer
149
views
How to create notifications for Azure Data Sync errors or different way to schedule replication of Azure SQL data to on prem SQL Server?
We have a database in Azure SQL Server that we want to replicate continually to an On-Prem 2019 SQL Server. We are using Azure Data Sync but it fails every once in a while and we can't find out how to ...
0
votes
0
answers
143
views
DMS Source Data and Latency spike nightly
I'm using a SQL Server on-prem source for a DMS to replicate to a SQL Server RDS. Every night, at about midnight, I'm seeing a spike of ~1.6M CDC incoming changes on my DMS task, but nothing is making ...
0
votes
0
answers
78
views
Error while adding subscriber in SQL Server replication process
I get this error while adding subscriber database in SQL Server:
Property Password cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)
Some ...
0
votes
0
answers
219
views
What does the value 30 indicate in the type column in the MSrepl_commands table?
Result Set of MSrepl_commands
I want to infer that whether its a insert/update/delete command . We need to check at day end the amount of data replicated per article by the transactional replication. ...
0
votes
0
answers
91
views
Access error when running alter table on the table that is being replicated
I have the replication set up on the SQL Server from ServerName to ServerName2
The replication folder is shared as \\ServerName\repldata and
Replication snapshot-agent runs under the windows account ...
- 470
0
votes
0
answers
48
views
SQL Server Replication if the Tables aren't exactly the same
I have 2 servers for Production data and Development data for an Application I maintain. Every year I need to make modification to the application based on business needs. Of course, the original ...
- 835
0
votes
0
answers
708
views
Get a list of (local) publications in SQL Server
When in SQL Server Management Studio, there is a "Replication" folder with the list of local publications:
I am looking for a way to get that list programmatically. Something like a SQL ...
- 470
0
votes
1
answer
1k
views
Disable Replication, Keep Replicated Tables?
I have transactional replication set up between Database1 and Database2 using SQL Server 2017. About 20 tables are being replicated to Database2, a few of them are pretty large. I would like to ...
- 11
0
votes
1
answer
134
views
Automate the sync between Publisher (SQL Server 2019) and Subscriber (SQL Server 2019 Express)
I already created the Publication and Subscription on SQL Server 2019 Standard (OS 2019) and SQL Server 2019 Express edition (Windows 10). How can I automatically do the auto sync if there are changes ...
- 3
0
votes
0
answers
393
views
Goldengate for SQL Server - exact from tables with CLOB/BLOB columns very slow
We are running GG for SQL Server on a OCI VM. This is connecting to an on-premisis SQL Server instance. Initial sync and continuous replication works perfectly with most tables. We are running into ...
- 25
0
votes
1
answer
505
views
sync data from remote SQL Server to local server
I have read only access to 2 SQL Server databases used by our company's primary application. For reporting and testing purposes, I would like to sync the databases to 2 databases i have on prem at ...
0
votes
1
answer
243
views
SQL Server replication/redirection for heavy jobs
Need some sanity check.
Imagine having 1 SQL Server instance, a beefy system (i.e 48GB of RAM and tons of storage). Obviously there comes a point where it gets hammered in a situation where there are ...
- 5,822