Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
SolvedPrivate

update Oracle Database via SQL 2008

Posted on 2013-01-28
3
Medium Priority
?
50 Views
Last Modified: 2016-02-10
Hi,
I have application on SQL2008 R2.
I have a form in that application where data has to be transferred  to Oracle Database once the form is completed.

How can I achieve this and can I use SSIS to transfer data ? and how can I trigger the data transfer

Thanks
0
Comment
Question by:expoit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Expert Comment

by:liija
ID: 38827469
You can do it with SSIS but its better with batch type of jobs. If the data is not needed instantly in Oracle, you could easily schedule SSIS package to be run once a hour. Or SSIS can also be run from command line, with required parameters, with dtexec utility.
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

For up-to-date integrations MS BizTalk is better product. SSIS is not initially designed to be used like that.
0
 

Author Comment

by:expoit
ID: 38827603
Do you have any guide where i can create the SSIS package from SQL to Oracle.
and is there a way where I could trigger the data transfer of change of a field.
0
 
LVL 6

Accepted Solution

by:
liija earned 1500 total points
ID: 38827668
Creating package for oracle is not different from creating one for SQL Server. You only define the connection to be Oracle for the output.

You could use the dtsx.exe to trigger the package. Read through the msdn ducumentation.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question