第ä¸æ¥ï¼ä»SQLSERVERä¸å¯¼åºæ°æ®
å¨SQLSERVERæ°æ®åºä¸ä½¿ç¨Import and Export Dataå·¥å
·
1.å¨choose a Data source页
éåï¼
source= Microsoft OLE DB Porvider for Sql Server
server=local
database=icd_db_bill
{use Sql Server authentication}
user=sa
éæ©ä¸ä¸æ¥
2.å¨choose destination 页ä¸
éådestination为Text File
file name ="d:\backup\tbilllog1.txt"
éæ©ä¸ä¸æ¥
3. éæ©use a query to specify the data to transfer
éæ©ä¸ä¸æ¥
注ï¼ç±äºSQLSERVER导åºæ¶ä¼å°table_idä½ä¸ºä¸ä¸ªå导åºï¼èoracle没æï¼oracle 为rowidï¼ï¼æ以å¿
é¡»éæ©æ¤é¡¹ä¸ºuse a query to specify the data to transferèä¸æ¯copy table(s) from source database
4.å¨Query Builderé项è¿å
¥
éåtbilllog1,æ·»å ç¶åå°table_idä»å表ä¸å»æ
ä¸ç´ç¡®è®¤ç´å°select Destination File Format页é¢
5.éæ©
file type =ansi ï¼ç¼ºçï¼
row={cr}{lf} ï¼ç¼ºçï¼
column=comma ï¼ç¼ºçï¼
text= double quote{"} ï¼ç¼ºçï¼
å¨comumnåtexté项ä¼å½±åå°oracleçcontrolfileç设置
第äºæ¥ï¼
oracleæ¹é¢ç设置
é¦å
å°tbilllog1.txt æ·è´å°log1.ctlçç®å½
æ示ï¼å¦æNTå¹³å°å¯ä»¥å
å缩åä¼ éå¯ä»¥èçæ¶é´ï¼å°ç®çç®å½å解å¼
controlfile example: log1.ctl
LOAD DATA
INITFILE 'tbilllog1.txt'
insert into table tbilllog1
fields terminated by ',' optionally enclosed by '"'
(
callid,
callidnum,
callerno,
calleeno,
waitbegin date "yyyy--mm-dd hh24:mi:ss",
waitend date "yyyy-mm-dd hh24:mi:ss",
ackbegin date "yyyy-mm-dd hh24:mi:ss",
ackend date "yyyy-mm-dd hh24:mi:ss",
...
)
*fields terminated by ','ææåç±,åå²ï¼å¯¹åºå°ä¸é¢ç¬¬5æ¥çcolumn=comma
*optionally enclose by '"'ææå符åæ°æ®æ" "æ¬èµ·æ¥ï¼å¯¹åºå°text=double quote{"}å¦æéæ©text=none ä¸å æ¤è¯å¥ã
温馨提示:答案为网友推荐,仅供参考