Agreed, however I'm looking for a product that lists all tables in two databases and I just choose the from table to table from column to column and in the middle if it's not a one to one relationship do some kind of lookup.
So a simple user walk through would be. Select source db (oldDB) Select destination db (newDB) Select source table (People) Select destination table (Customers) Select source column (Phone Number Type) Select destination column (Phone Number Type ID) Mark as a lookup field Select lookup table (Phone Number Type Lookup) Source column is phone number type which is a string, destination is an ID from Phone number type lookup table. So in source db the field says "Home" for phone number type and in destination it must insert the ID of Home which it can lookup what it is in the lookup table. --Tigran On Fri, Jul 17, 2009 at 11:30 AM, Jeff Bunting<[email protected]> wrote: > 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/> ~
