Hello Sir, Does this work for Azure SQL to Azure SQL database, when I used Upsert then it add a new row, can you please make a video on "Azure SQL on Premise to Azure SQL Incremental load, Insert update and Delete if we need to sync data between two databases table. Please request you make video on this, thanks.
Hi Sir , Could you please let us know how to do dynamic parameters while using upsert ? I have multiple files for loading data into tables and do upsert .
Thanks, great video. Does UPSERT also deletes records that does not exists in source?
Thanks, no it does not delete the records.
Hello Sir, Does this work for Azure SQL to Azure SQL database, when I used Upsert then it add a new row, can you please make a video on "Azure SQL on Premise to Azure SQL Incremental load, Insert update and Delete if we need to sync data between two databases table.
Please request you make video on this, thanks.
Hi Sir , Could you please let us know how to do dynamic parameters while using upsert ?
I have multiple files for loading data into tables and do upsert .
Key column option is not available when I m using copy data is there something I need to enable to those option are avalialble
did you check under the Advance as part of the column mapping?