March 19, 2010 at 9:14 am
what is the best way to select data from oracle database to update sql server tables. i prefer jdbc solutions.
Anyone with sample script?
March 19, 2010 at 12:29 pm
lollybanty (3/19/2010)
what is the best way to select data from oracle database to update sql server tables. i prefer jdbc solutions.Anyone with sample script?
If you prefer JDBC it means you don't know data access so you don't know JDBC is a driver for Java only development. So if you are doing Java development use JDBC, if you are doing .NET development you can use Oracle's ODP.NET or Microsoft ADO.NET or Enterprise library. If you are doing ETL you need to either use the new Microsoft SSIS connector or use Oracle OLE DB provider. In development Oracle client is required, in Windows 2008, Vista and Windows 7 the Oracle 11g client is about 1.7 gig.
Kind regards,
Gift Peddie
April 7, 2010 at 7:48 am
i dont get your point. what i want to do is create a java service that will select data from oracle database and update sql server.
April 7, 2010 at 7:57 am
lollybanty (4/7/2010)
i dont get your point. what i want to do is create a java service that will select data from oracle database and update sql server.
That was not in the post I answered, so you need Microsoft or Oracle JDBC with the relevant Oracle version client.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply