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? Thanks
Duplicate post, I’ve deleted other one. Luis Martin
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.