Merge statement and proxy tables

[Former Member]

I have been asked by a customer to populate data in another database (SQL Server or Oracle).  I was thinking of using a merge statement to take data from the table in my SQL Anywhere database and insert it into the proxy table.

Are there are any concerns with using the merge statement for something like this?

Thanks

[JasonHinsperger]

I can't think of any real concerns, aside from performance.  Since merge does branching first (groups rows together which apply to each branch), there could be significant data movement between the local and remote server, which would cause performance to suffer.

--Jason