How to manage such database requirement
I am having typical requirement for my organization.
1. Synchronizing two databases similar in structure & Schemas connected through VPN (Virtual Private Network )
2. Neither tables/objects can be divided between two locations as
normaly we do in creating Distrubuted Database.
3. Parallel server is already discarded due to some commercial problems.
4. No site is master site - snapshot site as such at both places transactions would be done shud reflect at other location.
Is there any way to come out of this ?