sql server - Is replication possible on two different domains ...
Use SQL Authentication for cross domain connections when setting up replication. My replication stairway articles give a step by step walkthrough of setting up SQL Server Replication and includes detailed information about the different security credentials used by the different processes. While the Stairway is not a step by step guide for ...
replication - SQL Server Express Edition Primary - Secondary …
2016年10月18日 · An answer to Replication from one SQL Server Express to another on Stack Overflow offers some suggestions: In summary (from the link): Write an application that transfers "articles" from your "publisher" db to your "subscriber" db(s). OR. Create a set of views to have a summation of data that you want to be published.
sql server - Is it possible to use replication between 2 different SQL ...
2022年3月29日 · Yes. See the Tutorial: Prepare SQL Server for replication (publisher, distributor, subscriber) on the Prerequisites section of the doc: Replication is not supported on SQL Server instances that are more than two versions apart. For more information, see Supported SQL Server Versions in Replication Topology. That other reference doc says:
What is the performance overhead of snapshot replication vs ...
2021年12月13日 · I want to setup a one-way replication for 4 tables from the database on this server into a database on another server for the purpose of reporting. The total number of rows currently in the tables is as follows- Table1: 403060, …
sql server - Primary key with "NOT FOR REPLICATION" option
NOT FOR REPLICATION indicates that when a record is replicated to this table, any value that is inserted into the identity column via the replication agent keeps it's original value from the source system, but any records added locally still increment the identity value. UPDATE: Old Link broken
replication - Sql Server : How to query list of subscriptions and ...
2018年11月14日 · In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication) (transactional replication) Yes, there are easier ways to query from Distributor but I need a query from Publisher side.
sql server - Two-step Replication between SQL 2008 and 2017
2018年3月6日 · I am currently using transactional replication from several SQL 2008 publishers to a central 2014 subscriber/distributor. I need to replicate this data to a 2017 server, which would require a 2017 distributor. Since 2008 -> 2017 transactional replication is not supported, I am trying to replicate in a second step from the 2014 server.
sql server - Add article to transactional publication without ...
Using SQL 2008 R2 transactional replication with pull subscribers, when we add an article, I'd like to avoid having to create an entire snapshot (the db is ~80 GB, so this takes hours). From this
sql server 2008 - Two way replication - Database Administrators …
The easiest solution would be to use SSIS or T-SQL to perform the sync. Simple and free. If you're not comfortable with writing the necessary T-SQL to do this, then I wouldn't recommend attempting the same thing using any form of replication, because this would be much more complex than writing the necessary insert, update, and delete commands to perform the sync.
sql server - TDE on replicated databases - Database Administrators ...
2020年7月4日 · Snapshot replication, as well as the initial distribution of data for transactional and merge replication, can store data in unencrypted intermediate files; for example, the bcp files. During transactional or merge replication, encryption can be enabled to protect the communication channel. Also, a suggested read here.