Post reply

Synchronize 1 table between SQL servers in different countries

  • March 22, 2019 at 12:27 am

    #377785

    Good day.

    I am looking for help on how to synchronize data between SQL server in 2 different countries. I work for a company named Afriflora, we grow roses in Ethiopia and have our headquarters in the Netherlands. I am building financial reports in SQL in Ethiopia and want to have a consolidated financial report in the Netherlands. The idea  would be to have  a automated solution to send the data  from the Ethiopian SQL server to the SQL server in the Netherlands.
    So maybe if you have experience with this issue I would very much like to hear how I can set this up.
    Grtz Olivier

  • March 22, 2019 at 3:33 am

    #2025186

    Hi,
    take a look at transactional replication. There you are able to replicate a single table from a big database to a foreign location.
    Kind regards,
    Andreas

  • March 22, 2019 at 3:35 am

    #2025187

    andreas.kreuzberg - Friday, March 22, 2019 3:33 AM

    Hi,
    take a look at transactional replication. There you are able to replicate a single table from a big database to a foreign location.
    Kind regards,
    Andreas

    Hi Adreas.
    Thank you, I will look into it.
    Grtz Olivier

Viewing 3 posts - 1 through 2 (of 2 total)

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