All Questions
Tagged with database-replication sql-server-2012
33 questions
2
votes
1
answer
183
views
SQL Replication is_subscribed flag is set as 1
We have a Chain store environment using SQL replication. For upgrading the SQL Server we will remove the replication components from the stores and will do the SQL upgrade and then will add the stores ...
1
vote
0
answers
50
views
MSSQL Transactional Replication
I have an application that almost continuously works with inserting or updating data. Since multiple requests are handled asynchronous I wrote my queries like below. I used an example based on SO, but ...
- 14.2k
0
votes
1
answer
737
views
How to replicate huge data table in SQL Server 2012
I have the same database on two servers and I am using merge replication for around 35 tables, and it is working fine.
But whenever I add 2-3 more tables with around 1 million records, the ...
- 361
0
votes
0
answers
56
views
SQL Server 2012 Replication web synchronisation snapshot failing
We're trying to build a new enviroment which replicates our existing setup. We're using sql server 2012 sp3, old servers were windows server 2008 new ones are 2016. One server works fine, but the ...
- 479
10
votes
5
answers
2k
views
SQL Server : Replicate Schema changes to another database
I am working on a requirement in ASP.NET Web API which needs two identical databases.
I have created two identical databases on the same server. Let's say one is for the development and another for ...
- 737
0
votes
1
answer
530
views
Merge Replication could not drop object due to Foreign Key Constraint
Good Day Everyone.
I am slightly confused here. (it doesn't take a lot to confuse me though)
I have a merge replication and it started giving me this error:
Could not drop object 'TableName' ...
- 77
0
votes
1
answer
781
views
sp_dboption in SQL server 2012 for Published property
Currently working on migrating SQL server from 2008 to 2012 project. We aware that sp_dboption is deprecated and it will not work in SQL server 2012. In 2008, had code to set the value for Published ...
- 538
0
votes
1
answer
903
views
Transaction replication not replicating one column value
One column of type varbinary(200) is not getting replicated to destination table from source table. I have tried updating the column value in main table again but still it is not getting replicated to ...
- 811
0
votes
0
answers
213
views
How to stop replication in SQL Server 2012 using code
I want to add column in a table but this message appears:
'Students' table
- Unable to modify table. The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands ...
- 135
0
votes
0
answers
643
views
create a pull subscription to transactional publication that uses FTP snapshot delivery in SQLServer Management Studio
I've created a publisher that uses FTP snapshot delivery method using SSMS.
However, when I tried to configure Subscriber, I couldn't find option to use FTP credentials.
I read "To create a pull ...
- 1,466
0
votes
1
answer
56
views
Table schema affect on transactional replication performance
We've implemented transactional replication (push model) over a WAN and are sometimes seeing slow-downs during bulk updates of a specific table (ie. we are seeing a high number of 'commands not ...
- 629
0
votes
0
answers
233
views
Snapshot Replication or Backup/Restore
A SQL Server that serves as a DW for reporting purposes (OLAP) is also used directly by users to perform direct ad-hoc queries. User queries add a lot of extra load on this server because of number ...
- 1,025
0
votes
1
answer
81
views
Sociable SQL Server instance replication - Best practice
I would like to know what are best practices for using SQL Server replication on a SQL Server instance that may have other application databases that may also use replication. That is, our product ...
- 1,858
0
votes
1
answer
95
views
How can I Snapshot a database without losing undeleted data?
We have a shop floor database OPERATION that replicates selected data to a database BUSINESS that is used for reporting. The data in OPERATION is deleted daily by the third-party shop floor ...
- 427
0
votes
1
answer
88
views
Can a subscriber database pull from the publisher in a replication scenario
With SQL Server 2012 or later, is it possible to set up replication in such a way that a subscriber can pull data from the publisher, instead of the publisher pushing data out to it?
- 8,939