Transaction Replication: Multiple Publishers, Single Subscriber

  • S_Kumar_S

    SSCrazy Eights

    Points: 8975

    Comments posted to this topic are about the item Transaction Replication: Multiple Publishers, Single Subscriber

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 16 yrs exp.

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

    How often does this break and you have to reinitialize? And how hard is it? With regular transnational we would just do it in the middle of the day and in a few minutes the publication would be back.

    And why not simply replicate the data into separate tables and use SQL to join the data?

  • Robert Sterbal

    SSChampion

    Points: 10953

    Why did the need to have real time data? How much benefit would real time data have provided over once a day data and an alert system?

    412-977-3526 call/text

  • S_Kumar_S

    SSCrazy Eights

    Points: 8975

    robert.sterbal 56890 - Monday, February 26, 2018 7:58 AM

    Why did the need to have real time data? How much benefit would real time data have provided over once a day data and an alert system?

    Hi Robert
    It would depend on your requirement. In my case the client wanted the real time data, so the toplology was built accordingly. But if you needed data just once a day, then may be an incremental SSIS package will do a good job.
    Any other better solution coming to your mind?

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 16 yrs exp.

  • S_Kumar_S

    SSCrazy Eights

    Points: 8975

    alen teplitsky - Monday, February 26, 2018 7:36 AM

    How often does this break and you have to reinitialize? And how hard is it? With regular transnational we would just do it in the middle of the day and in a few minutes the publication would be back.

    And why not simply replicate the data into separate tables and use SQL to join the data?

    If your connectivity across servers is good, then it should not break very often. To reinitialize, let's say it stopped working for 2 stores out of 50 stores. And let's say it stay broken for 2 hours. So now e.g. you have data upto 28thFeb, 9 AM and you fixed it at 11 AM. You miss 2 hrs data. This 2 hours data will need to be inserted using query manually. And to reinitialize,you may remove tables of those 2 stores from replication and add back with same settings. So if you add them at 11 AM, then data will start flowing from 11 AM onwards. The data older than 9 AM was all there. 9AM to 11 AM data you will need to insert with query.
    If you don't want all data in single table, then you may replicate the databases individually, and then use joins to get data. Although it will be a big query if you have 100 databases. In my case, all data was always needed, so client asked for all data in single tables.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 16 yrs exp.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply