Post reply

sync two DBs

  • December 28, 2016 at 6:33 am

    #401283

    Hi gurus

    I am new to this as you can tell by my postings but trying to get a hang, so go easy on me.

    I am looking for the best way to sync two DBs that are totally on two different domains.

    I need to sync the source with the target option, in which the target is the one being updated with the information from the source

    I need to sync the source and target where both DBs are keeping exactly the same information

    Thanks Gurus

  • December 28, 2016 at 6:46 am

    #1919850

    guaro5555 (12/28/2016)

    Hi gurus

    I am new to this as you can tell by my postings but trying to get a hang, so go easy on me.

    I am looking for the best way to sync two DBs that are totally on two different domains.

    I need to sync the source with the target option, in which the target is the one being updated with the information from the source

    I need to sync the source and target where both DBs are keeping exactly the same information

    Thanks Gurus

    How much of a time lag are you prepared to accept, between an update being made in the source and appearing in the destination?

    How big are the databases?

    Do you administer both of the databases, or are you limited in terms of the technology which you can implement to do this?

  • December 28, 2016 at 7:16 am

    #1919857

    Thanks a bunch for jumping in

    I was planning on sync every hour if this is a good practice?

    The Dbs are not that big at all, the biggest one is 4gb

    I might end up admin both databases across the two domain and that is why I need help with the tech I will need to accomplish this

  • December 28, 2016 at 8:34 am

    #1919876

    Are these both writeable? Meaning can data change on both sides? There isn't a good way to sync these if both can change. Merge replication works, but it's cumbersome - https://msdn.microsoft.com/en-us/library/ms152746(v=sql.120).aspx

    If only one changes, you have lots of options, but there isn't a simple way to move selected data. Backup/restore work. SSIS or some other ETL process works as well.

  • December 28, 2016 at 9:59 am

    #1919902

    guaro5555 (12/28/2016)

    Thanks a bunch for jumping in

    I was planning on sync every hour if this is a good practice?

    The Dbs are not that big at all, the biggest one is 4gb

    I might end up admin both databases across the two domain and that is why I need help with the tech I will need to accomplish this

    I think you need to ask the business people you work with how frequently their needs are for synching. They may need it updated every hour, even more frequently, or only once or twice a day.

    Is there a specific table or tables that you need to synch or the entire database?

  • January 4, 2017 at 5:45 am

    #1920582

    If the remote database can be read only log shipping would be your best solution

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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