Devart Forums

I have an application that requires updating one table from another.
Problem is that the tables are under different user accounts (schemas) on Oracle.
Oracle has a Merge utility but apparently it only works for tables within the same user/schema.
What is the simplest/most efficient way to do this with Unidac?
In essence I'm taking trying to take some columns from one table (third party vendor's table in their schema) and adding/updating them within a second table (in my schema) that has additional columns.
I need 'my table' because I have to expand on the functionality (by adding additional columns) of the vendors data for my own application.
I realise that I could make a client detail relationship with the additional columns in a second table but just wondering if some form of 'merge' would work across schemas.

Thanks.

Hello,

For data synchronization you can use our CRBatchMove component, that allows transfer data from one DataSet to another automatically. Moreover, in this component, you can choose behaviour modes on finding identical records -

TCRBatchMove.Mode = (bmAppend, bmUpdate, bmAppendUpdate, bmDelete)

You can find more detailed information about this component in the UniDAC documentation: https://www.devart.com/unidac/docs/#dev ... chmove.htm .

Thanks Alex.
I thought there was something I was missing - and that was to look under the data access tab and not the Unidac ones.
Bit of a 'duh' moment as I was sure Devart had thought of this and I'd read it somewhere.

Cheers,
Tony

If you have any further questions, feel free to contact us.