SQL Server Performance Forum – Threads Archive
Move SQL Table to Oracle Table Instance?
Is it possible via SQL Server Enterprise Manager to export SQL Tables from SQL Server directly into Oracle Tables in an Oracle Database Instance, as I believe Enterprise Manager may include some functionality to facilitate this? ThanksConor.
Duplicate post, I’ve deleted other one. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
You can accomplsh the task using DTS tool and refer to books online for complete information.
Ensure ORacle client tools are installed alongwith OLE DB provider for Oracle version, which is used. http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid571416_tax294863,00.html for more information, though this represents the scenario reverse way and thought this would give specified idea. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>