SQL Server replication

Is there a way for subscriber to start replication automaticly after publisher created distribution?
Who is Participating?
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
Are you talking about third-party replication rather than native SQL replication? If so, we use a tool called Goldengate (recently purchased by Oracle) - it was originally designed to replicate between databases of different types (TandemNSK -> MSSQL, for example), but it can replicate MSSQL<->MSSQL, Oracle, or pretty much whatever else you want. It's a bit pricey, but there was no other tool we could use to replicate data out of our NSK, so the price was justified.

As for third party tools controlling native SQL replication, I've never used anything like that.
Ryan McCauleyData and Analytics ManagerCommented:
There's no way I'm aware of that you can have a subscriber "poll" for a new subscription and pick it up automatically once it's ready.

However, you could script the T-SQL to start replication and schedule it to run every few minutes on the subscriber (have it check to make sure replication isn't already started first). That way, the client can pick it up as soon as it's ready.

Would that work for your needs?
jem1662Author Commented:
Thank You.  Let me try it.  By any chance, do you know of any third party tools that can do replication?
jem1662Author Commented:
Thank You
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.