April 28, 2021 at 3:41 pm
Hi all
I am looking for an Powershell or C# script that starts an replication which is already configured.
I am using snapshot and push subscription (via distributor).
Normally the replication runs x times per day. The idea is to push this replication in between this pre-configured time manually, if its necessary.
Is this possible via Powershell or C# - and if so - can you help to find the right commands?
Thanks.
Regards
April 29, 2021 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 29, 2021 at 4:26 pm
all information is on the manuals at https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication?view=sql-server-ver15
more specifically you wish to look at the supplied stored procs which will allow you to do all work. full list here https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/replication-stored-procedures-transact-sql?view=sql-server-ver15
with the above you can use any language/scripting/jobs to kick off the SP's.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply