This is more of a database question but I'm sure the collective smarts in this email list will know the answer.
I'm looking for a product that will do 2 way sync of ms sql databases. I have data in X database that needs to move to Y database and then in reverse. However data is being updated in both databases all the time. So an application uses X that data should move to Y. Another application uses Y that data should move to X. To make things worse. The schema is not the same. The data is but the schema isn't so some kind of translation has to occur. An example could be X has customers table with phone number. That translates to Y customers table and phone numbers table. Anybody know of a product that can do this? Many thanks for the help. --Tigran ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
