What's the best and optimized way to copy the whole content of View_Legacy F

patrickp over 9 years ago

What's the best and optimized way to copy the whole content of View_Legacy From DB_Legacy to Table_Appian in DB_AppianBusiness and/or Is there a component that is able to compare 2 table structures and give as output only the differences?
- Both DataSource are mapped in Appian and available through the use of DataStore.
- View_Legacy belongs to a Legacy System.
Periodically the source View_Legacy is updated by an External System; that's why we need to compare the content of the two structures and update Table_Appian according to the current values of View_Legacy.
Thanks in advance!

Discussion posts and replies are publicly visible

Parents

0 patrickp over 9 years ago

Sure! In our case we have two tables and the bigger one has 50 columns. At least 30 columns could be updated
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 patrickp over 9 years ago

Sure! In our case we have two tables and the bigger one has 50 columns. At least 30 columns could be updated
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data