The SQL enterprise manager has a DTS package creator in it. You can create procedures to move the data back and forth and then call them from an application or set triggers in the DB to run them IIRC.
Jeff On Fri, Jul 17, 2009 at 1:15 PM, Tigran K <[email protected]> wrote: > 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/> ~ > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
