Do you have to be read only in transactional replication?
By default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. However, transactional replication does offer options that allow updates at the Subscriber.
Who is the subscriber in transactional replication?
The Publisher or Subscriber is a non- SQL Server database, such as Oracle. By default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. However, transactional replication does offer options that allow updates at the Subscriber.
Is the snapshot agent used in transactional replication?
The procedures by which the Snapshot Agent implements the initial snapshot in transactional replication are the same procedures used in snapshot replication (except as outlined above with regard to concurrent snapshot processing).
How is ETL orchestrated in Azure Data Factory?
Currently we orchestrate a nightly ETL (ELT really) process with azure data factory. The nightly process syncs reference tables on the data warehouse with the OLAP app database and calls heavy stored procedures to rebuild all the denormalized tables required for reporting and modeling. The nightly process takes a long time.
Can you make a specific table in database read only?
You can make a specific table in database read only by using one of the below techniques. For these examples, we will use database MyDB and table tblEvents for all of the examples. To setup the examples, execute the below script to create the sample database and table. Please note that I have used an INSTEAD OF trigger.
How are merge subscribers handled in SQL Server?
For merge subscribers, a replication administrator must manually reconfigure the subscriber, by recreating the subscription. SQL Server replication supports the automatic failover of the publisher and the automatic failover of transactional subscribers.