We have two SQL Server installations which are in different location (ie., 100 KM apart). Records are continuously being added and delete into the tables and we have good internet connectivity between them.
Now my question is that how will we make them replicate to each other and what are the best options available to us in such a scenario. Is SQL Server okay or we must move to Oracle in this case. We just want that the records affected at one end be visible at the other.
And what replication is suitable Merge, snapshot or transactional
Note : Replication may take place 2 or 3 times in a day and not continuously.
Now my question is that how will we make them replicate to each other and what are the best options available to us in such a scenario. Is SQL Server okay or we must move to Oracle in this case. We just want that the records affected at one end be visible at the other.
And what replication is suitable Merge, snapshot or transactional
Note : Replication may take place 2 or 3 times in a day and not continuously.
