Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle.
Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across.
This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today
The plan is also to add more data to the SQL Server table and show this new data back in Oracle.
To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases.
You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence.
Before we start we need to make some changes to the standard Easysoft config files.
Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer.
Easysoft supports all SQL data types from the version of SQL Server from version 7.
Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones.
If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up.
Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change.
As you can see, VarMaxAsLong says "Yes"
We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file.
Please note that HS_NLS_NCHAR must be set to UCS2
Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters.
So that's the link between DG4ODBC and the datasource setup correctly.
Next we need to set up the Listener entry
The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora
The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC.
The ENVS=LD_LIBRARY_PATH tells Oracle what library to load
Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier.
The Oracle Listener now needs to be restarted.
OK, that's now started the Listener up again.
So we have ensured that all the configuration files are set up correctly.
The Listener and tnsnames.ora both set up OK.
The final step is to create a link from the Oracle database to the "tnsnames.ora" entry.
CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr';
Right, that's all done.
Let's access the data in SQL Server now.
select * from [email protected];
Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name.
OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server.
Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle.
/usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv
insert into demo values (2,'Easysoft')
select * from demo
select * from [email protected];
And there is the new data.
Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com
Be sure to let us know if you have any comments or questions.
Until next time, thanks again and we'll see you again soon.
skinny blond cumshot black ashlyn gere tease peter north canyon african classic full movies sex an interracial nude beaches bukkake announcer busty wife next door quarrel husband out house naked part1 strip in fitgh lachelle marie gets slammed hard inthevip too big for hard core porn boy molested boy older brother incest gay video smoking mature nudist mum shows son junior idol 3some father and a dought cojiendo con panocha peluda brunette wife bigtits adultery housewive cheat turkish super mom romantic first veronica carso lesbian redbone deleted sex tape from facebook katrina kaif fake sex mi japanese mom son pale gandimasticom 3gp marathi celebrity school n ht femdom wife makes husband swallow forced bi bodystocking worship joi it4 japanese lesbi xhamster 3gp anal fuck compilation extra nasty kross two ripe cock arrimon en tren ava devine fucks sons friend cristina cristol philippines 1980s movies metro blonde buster 02 scene 4 uncensored japanese family orgy trample spit fanny gareau cuck under very young teenie swallows old handsome guy with sexy women goyang seksi tkw arab bastard forced german very indian secretary creampie super sexy brunette sucking cock and getting fucked hard das erste mal mit dildo first dildo sev beni seri 2 lesbian teacher stockings german double penetracion sofa
dad fuck daugther after boyfriend japanese yukino akari finger orgasm group slave drinks his own pee curly girl fucks dildo on coffee table moms dogs xxx 8883 terrazas ebony slut gets bent over and fucked 16years boy in women 35 years indian tamil indiana jayabharathi 102765 esperanza gomez creamed compilati mature daughter blow job in the car perverted french mom creampie young man handcuffed and forced by wife to suck cock mom en son creampie prostate miliing hardcore fuck my niece japanese mo son sex ed nice looking dirty wife used infrount of husband 2 busty natasha bangla xxx video in burdwan dist indian dayna mite indian women caught shitting on wwwyoutubecom wellhung handsome czech boys porn videos rompi el culo awek dikeroyok indonesia pelajar tayang dalam kelas 6gwy kj gay cheesy cock big black bikini dance rescue mission birmingham indian interacial ebony light skin lesbian setapes porn vera 2168 granny fucks young cock cock insest father wake straight video 1289474 shreya ghoshal xxx son tucker mom ebony oil fukc in vagima 2 guys cream pie septa cubka masha mom cam sophie moone golden showers first time alison part9 saney lein sex frends mom bdsm sheena ryder blowjob mum seduce son with short skirt amateur milf lesbian first time black hair homemade big tits yuki manaka in a threesome www.livepomo899.com dad goes in his daughters bedroom and shows them his 18 inch dick it makes him cry when he tells him he going to f him up the ass for the first time e rape by an entire crowd beena auntony nud boobs horny asian brunette spreads cum all over ameture cd dildo solo chinese rape yube indian gang rape telugu black girl fuck her dad indian waterfall fuck 27min sie schaut ihm beim onanieren zu dad forces son to have sex with him asian amateur white novia comiendo 43old japan homemade chubby big tit teenr webcam 3gpbangla b.bariear xvideos japanese 18 year girl open sex tight cameron video propio miren como se le sale la leche a mi esposa black nylon footjob under table from a teen girl footjob broken huge cock exposed shraddha kapoor sex leg affair demi delia cool black black 1993 black dirty debutantes 1 sasha dawn download red sex videos in africa allboy 19 examined boy celebrity jewel shepard nude tits and explicit sex barbie mae webcam cuckold bbw wife italian drunk son gets mom pregnant piledriver angle of teen roughly fucked by a cock that pounds her deep bisexual mmf gays get nasty ebony teens cum in mouth fat vs slim gfgirlfriend finger 3d mini series budak umoq 16 nakal gay scally lads orgy lesbian dildo fucking in kitchen demolition woman pt 1 yes touch me erotik expo budak asrama mandi indian foot fetish.. yummy feet lapdance bikini heyzo 0007 abella anderson longporn cewek ngangka shocked in chatroulette hanjob step sister mother kat denning daydream nature dungeon sm session indian actress dipaka xxx video www1619285sexy booby big nipples desi in mic red tits massage painfule forced nia d papa japanese old uncensored with english subs male prostate stimulation and fucking girl masturbates in tim hortons sleeping rape movies hot pussyjob mena li katt milf machure homemade harvore thresome said latinas from chicago download awek melayu tudung nenitas de quinse anios porno anal natalia di angelo chinese couple bbc grandfather big boobs kq uy wife and her female date facialized hubby holo man sex hollywood mother wrestle son the fucks him indian wife sex audio video diaper egg groom in law tribadism japan sister begs brother sex bbc gag gurl straight video 707556 japan model girl job hidden cam japanese av public nudity walking man on leash subtitled japaneses grand mother jerking solo 5 brazil fun clip quay len boy gaythu dam fist time bisexual guy.