kerek2 10 Junior Poster

Hi alls,
I'm using console application to pull data between 2 different database and column name (from Oracle to Sql 2008). The connection already done..but i'm having problem to select and insert from oracle to sql...

The details as below :-

Oracle DB
Table :- Event
Column : ID , NAME , TIME , DATE

SQL 2008
Table :- EVENT_RECORD
Column :- STAFF_ID,STAFF_NAME,ER_TIME,ER_DATE

HOw to do my friends?...i'm also need to display and do count while the console pooling the data....anyone plz help me....:(

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.