title: Best way to sync data from one database to another
body: <p>Let's say I have my web shop and database have multiple tables like Products, Product prices and similar. I'm selling my software solution to my affiliate partner. He gets its database, it window application for entering data and I want all he's products are available on my website also. So, I have my products and sell them on my website. Partner has his website and his products, but I also want that all his products are also available in my database. My initial idea was to build some kind of app that periodically connects to Partner's database and insert/update data to my tables. But recently I think about some service buses. Is service bus way to go ? So situation would be like this. Partner inserts product (bus sends message that products was inserted, partner updates prices then bus sends message that some row in prices row was changed. I would then have some console app running on server that listens to message and updates to my database. What do you think would be scalable solution? Example is fictional and in real life I have lot of tables.</p>