February 26, 2018 at 12:08 am
Comments posted to this topic are about the item Transaction Replication: Multiple Publishers, Single Subscriber
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
February 26, 2018 at 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?
February 26, 2018 at 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?
412-977-3526 call/text
February 28, 2018 at 9:45 pm
robert.sterbal 56890 - Monday, February 26, 2018 7:58 AMWhy 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 18 yrs exp.
February 28, 2018 at 9:58 pm
alen teplitsky - Monday, February 26, 2018 7:36 AMHow 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 18 yrs exp.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply