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 sikhivahans over 9 years ago

@patrick No problem :-). Understood, still you can give a thought over 'Query DB' node with having a native SQL query in it. Even we do have this 'comparison and insertion' kind of implementation over hundreds of thousands of records and we can see it being done in few minutes. So, in your case, I don't think it should be an issue, as it's just thousands of records.

Out of interest, may I know how many columns should be actually updated? And how many tables should be updated?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@patrick No problem :-). Understood, still you can give a thought over 'Query DB' node with having a native SQL query in it. Even we do have this 'comparison and insertion' kind of implementation over hundreds of thousands of records and we can see it being done in few minutes. So, in your case, I don't think it should be an issue, as it's just thousands of records.

Out of interest, may I know how many columns should be actually updated? And how many tables should be updated?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data