Last post Aug 19, 2015 01:59 AM by wmec
Aug 18, 2015 04:13 PM|santoshyadu|LINK
I have five tables in oracle and need to insert ,update and delete records in sql database. Please send me the approach so that i can manage every records very well and trace if not inserted/updated/deleted in table so what i can trace that the reason.
It was done earlier with sql replication and i have to migrate with SSIS.
Aug 18, 2015 04:22 PM|AZMatt|LINK
This forum is intended for SQL Server as it relates to ASP.Net. For SSIS questions, I recommend you use a SQL Server forum like this one...
Aug 19, 2015 01:59 AM|wmec|LINK
1) create linked DB server on Oracle to point to SQL server
2) schedule task to insert records to Oracle DB table, by copying records from SQL server table
3) create triggers on table of 2), to do delete/insert/update, per relevant conditions