May 1, 2019 at 2:42 pm
Looking to replicate data from SQL to Oracle. I was thinking with few option it would be either SQL Server replication to oracle or SSIS. I am sure based on the needs either works better right? However, replication would be more current when it compared to SSIS. Checking what other things i would take into consideration like number of tables and how often data needs to be current etc.
May 1, 2019 at 6:36 pm
One of the big considerations is that replication to non-SQL Server subscribers is deprecated. How much longer it will be available, who knows. But I'd keep that in mind. It's documented in a few places - here is one of them:
The SSIS and change data capture method is a pain really but it is doable. There are also third party products that support replication between different platforms that you may want to start researching as another alternative.
Sue
May 2, 2019 at 2:51 am
Thanks! Sue. I have to replicate whole database with approx 50 tables to oracle. I can't think of any better option other than SQL Server replication to oracle. If i use ETL it would be to much overhead right? Can you think of anything other than this?
May 2, 2019 at 6:16 pm
I don't know if it's necessarily more or less overhead using SSIS and CDC, some of that really depends on the workload, activity on the tables. It can be a bit of work to get it all working well. I'd be more concerned going with replication to a non-SQL subscriber on new development when the it's being deprecated. I'd look into some of the other third party products that support replication between different platforms. I haven't played with any of them recently to have a decent recommendation about those.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply