So anybody know of a product that does this? If not do you think there's need for it. Cause I'm just going to develop one for my needs.
--Tigran On Fri, Jul 17, 2009 at 11:50 AM, Tigran K<[email protected]> wrote: > 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/> ~ > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
