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....:(