I am moving data from oracle to SQL server. I am required to move data only for 110 oracle tables out of 500 tables. I habe to keep running this job everyday to capture the deltas as well. I can read a context file which will contain the list of all the tables to read data from oracle and through dynamic schema start doing an upsert into sql server. I.am not sure if this is an efficient way to solution this business ask. Would love to hear from the experts if there is a better way to this.
Thanks
Ravi