SQL Server replication

Posted on 2012-08-30
Last Modified: 2012-09-08
Is there a way for subscriber to start replication automaticly after publisher created distribution?
Question by:jem1662
    LVL 28

    Expert Comment

    by:Ryan McCauley
    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?

    Author Comment

    Thank You.  Let me try it.  By any chance, do you know of any third party tools that can do replication?
    LVL 28

    Accepted Solution

    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.

    Author Closing Comment

    Thank You

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now