August 19, 2020 at 8:05 pm
Hi ,
Source : SQL Server Table ; Destination : Oracle Table
What is the best way to schedule the data transfer when new record inserted in source(sql server table).
Thank you for your suggestions.
Thanks.
August 20, 2020 at 3:03 pm
SSIS, SQL Server Integrated Services.
MCSE SQL Server 2012\2014\2016
August 20, 2020 at 4:44 pm
Is this needed in real time? As in a replication type scenario?
August 20, 2020 at 5:49 pm
you could also set up a linked server see mssqltips.com articles on this,
If this is a real time transfer I think replication might be an option as Steve Jones had questioned earlier in the post. I have seen some posts on it, it's worth a google to find the article you are looking for. There is even one in the google search from a previous post on sql server central.
https://www.sqlservercentral.com/forums/topic/sql-to-oracle-replication
MCSE SQL Server 2012\2014\2016
August 20, 2020 at 5:59 pm
yes , it is required in real time.
when a source table has any insertions that should be transfer and update at target table.
August 20, 2020 at 7:05 pm
Replication to other platforms is not supported after SQL 2016
there are third part products to do this, but they cost money.
You can use a linked server and a trigger, but I would highly recommend against this. Any issue with the linked server and then your transactions will not complete on the SQL Server, which is often a problem.
Instead, I would track the changes with a column or use a trigger to write the data you want to move to another table. Then have a job, SSIS, linked server, etc. that runs every minute and moves the rows across.
August 21, 2020 at 1:57 am
Thank you for valuable suggestions.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply