How to load data into oracel prodution

Question

Hi,
I am new to this sql world and there is a task which is assigned me to upload data into your UAT produtcion system
using sql scripts so can any one help me wit steps which i shld flow are any document u ppl can provide me thanks

Very urgent !!
Thanks in advance

Answer 1

You can use tools like SQL DTS import/export wizard to accomplish this.

If you have installed SQL server and tools in your local machine, go to run and type dtswizard.exe and this tool will help you to move data from SQL to Oracle and bunch of other components.

---

Thanks, Leks

Answer 2

Hey Lekss thanks for you response!!!
At my place they are scripting all ETL process so I need some basic information how to write script for loading data into oracel???

Thanks in Advance!!!

Answer 3

Have you considered posting your questions related to Oracle at the Oracle forums?  They have a very good set of forums here:

http://forums.oracle.com/forums/main.jspa?categoryID=84

Answer 4

SQL Server Instegration Services will help you on it.

---

Please Vote & "Mark As Answer" if this post is helpful to you. Cheers Prakash Nandwana Bangalore , India

Answer 5

Hi srik16,
If you want to use SQL script, you may create a linked server to Orace in SQL Server or use OPENQUERY for loading data into Oracle. For more information, please refer to:
OPENQUERY (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms188427.aspx
Linked Server to Oracle
http://ursmeier.blogspot.com/2006/12/linked-server-to-oracle.html

If SQL script is not necessary, I strongly recommend that you use SQL Server Integration Services for ETL. This is an efficient and graceful solution.
Integration Services
http://www.microsoft.com/sqlserver/2008/en/us/integration.aspx

SQL Server Integration Services
http://msdn.microsoft.com/en-us/library/ms141026.aspx
Hands On Training for SSIS (SQL Server Integration Services)
http://www.microsoft.com/downloads/details.aspx?familyid=b1145e7a-a4e3-4d14-b1e7-d1d823b6a447&displaylang=en

Best regards,
Charles Wang

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help