The problem is we need to copy data routinely ie set up automation to copy data from a sql server database to an oracle.
What would you recommend?
I looked into doing it with an SSIS package but we have server 2012 and needs to interact with the oracle client to work. Is there a way of firing the data strait into the oracle database without client software etc necessary on oracle server? Thanks
If you want to transfer data between the 2 databases, but dont want to change servers configuration by installing any new type of software, I believe your best alternative would be an ETL Tool, like the
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.