ODBC連接Oracle數(shù)據(jù)庫,并將SqlServer 2008R2表數(shù)據(jù)導(dǎo)入到Oracle 11g
測試環(huán)境(WinServer2008R2+SQLServer 2008R2+Oracle 11g):
1、先安裝好WinServer 2008R2+SQLServer 2008R2+Oracle 11g
![407d0244eff55053320beda24b9063b8.png 407d0244eff55053320beda24b9063b8.png](/images/ueditor/20240203/6384256948240924031588124.png)
2、到Oracle官網(wǎng)下載:instantclient-basic-windows.x64-11.2.0.4.0.zip,instantclient-odbc-windows.x64-11.2.0.4.0.zip
instantclient-basic-windows.x64-11.2.0.4.0.zip:oracle官網(wǎng)下載
instantclient-odbc-windows.x64-11.2.0.4.0.zip:oracle官網(wǎng)下載
3、將這兩個(gè)zip文件解壓到同一目錄:C:\Oracle11gTools\OracleWindowsClient
![ff7e59a52c12d7209527ab8f0eeb7fad.png ff7e59a52c12d7209527ab8f0eeb7fad.png](/images/ueditor/20240203/6384256963711242868458553.png)
4、打開Windows環(huán)境變量設(shè)置(設(shè)定環(huán)境變量后,需重啟電腦)
a、將路徑【C:\Oracle11gTools\OracleWindowsClient】放在path變量的最前面。
b、增加環(huán)境變量:TNS_ADMIN= C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
c、增加環(huán)境變量:ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_1
設(shè)置path變量的搜索路徑以后,選擇.net framework data provider for odbc 驅(qū)動(dòng)后,會(huì)自動(dòng)搜索該路徑下Oracle ODBC驅(qū)動(dòng)程序。
5、創(chuàng)建一個(gè)新的Oracle 用戶
![0ead67c3be75b2eb5cdc8cea24060d80.png 0ead67c3be75b2eb5cdc8cea24060d80.png](/images/ueditor/20240203/6384256967050299652191548.png)
6、打開ODBC數(shù)據(jù)源設(shè)定。
![54584385b992761f6103459ab09730aa.png 54584385b992761f6103459ab09730aa.png](/images/ueditor/20240203/6384256995797187617233522.png)
![106103da01d2a6caf6b962e256892e23.png 106103da01d2a6caf6b962e256892e23.png](/images/ueditor/20240203/6384256998061296369317369.png)
![ace4d589e66d31ba971ae96d23b4f3dc.png ace4d589e66d31ba971ae96d23b4f3dc.png](/images/ueditor/20240203/6384257000465941467171142.png)
![b88248f9fc0dd00b41a003c3d91cf325.png b88248f9fc0dd00b41a003c3d91cf325.png](/images/ueditor/20240203/6384257001714373996789743.png)
![f4133adb828984b7604a4729d13e86fd.png f4133adb828984b7604a4729d13e86fd.png](/images/ueditor/20240203/6384257003544064465133506.png)
7、Oracle ODBC連接成功。
![98714cc81b976f58a6f2ff0c72d7f191.png 98714cc81b976f58a6f2ff0c72d7f191.png](/images/ueditor/20240203/6384257004155000599599705.png)
8、打開ssms.exe的【SQL Server導(dǎo)入和導(dǎo)出(64位)】功能,將SqlServer的表數(shù)據(jù)導(dǎo)入到Oracel 11g
![385b4330ca54a3f7c17adfefef1802dd.png 385b4330ca54a3f7c17adfefef1802dd.png](/images/ueditor/20240203/6384257017720634906457328.png)
這一步是關(guān)鍵:ConnectionString=【Dsn=orcl_pos;uid=pos;pwd=****】
![a527ccce7102ccc10b317e8d337e534e.png a527ccce7102ccc10b317e8d337e534e.png](/images/ueditor/20240203/6384257019362818408873915.png)
![74ed18dcacc03f90a4102d3af1bf377b.png 74ed18dcacc03f90a4102d3af1bf377b.png](/images/ueditor/20240203/6384257024795635502776138.png)
End.