gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertDeze browser wordt niet meer ondersteund.
Upgrade naar Microsoft Edge om te profiteren van de nieuwste functies, beveiligingsupdates en technische ondersteuning.
Applies to:
SQL Server
Replication supports on demand script execution for Subscribers to transactional and merge publications. This functionality copies the script to the replication working directory and then uses sqlcmd to apply the script at the Subscriber. By default, if there is a failure when applying the script for a subscription to a transactional publication, the Distribution Agent will stop. You can specify a Transact-SQL script to execute programmatically using replication stored procedures.
Compose and test the Transact-SQL script that will be executed on demand.
Save the script file to a location where it can be accessed by the Snapshot Agent for the publication.
At the Publisher on the publication database, execute sp_addscriptexec (Transact-SQL). Specify @publication
, the name of the script file with full UNC path created in step 2 for @scriptfile
, and one of the following values for @skiperror
:
0 - the agent will stop executing the script if an error is encountered.
1 - the agent will log errors and continue executing the script when errors are encountered.
The specified script will be executed at each Subscriber when the agent next runs to synchronize the subscription.
gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertTraining
Documentatie
Synchronize a Push Subscription - SQL Server
Learn how to synchronize a push subscription in SQL Server by using SQL Server Management Studio, replication agents, or Replication Management Objects.
Synchronize a Pull Subscription - SQL Server
Synchronize a Pull Subscription
Subscribe to Publications - SQL Server
Learn about the types of subscriptions in SQL Server replication, how to choose the type you need, and how to create a subscription.