數(shù)據(jù)庫操作中，我們有時(shí)候需要將數(shù)據(jù)從一個(gè)數(shù)據(jù)庫導(dǎo)入到另一個(gè)數(shù)據(jù)庫中。本文我們主要介紹一下SQL Server 2005導(dǎo)入Oracle 10g的C#源碼程序，希望能夠?qū)δ兴鶐椭?/p>

程序代碼的參考如下：

//--------------------------------------------------------------------  
//AllRightsReserved,Copyright(C)2011,HairihanTECH,Ltd.  
//--------------------------------------------------------------------  
usingSystem.Data;  
namespaceDotNet.Example  
{  
usingDotNet.BaseManager;  
usingDotNet.DbUtilities;  
publicclassImportExportData  
{  
///<summary> 
///導(dǎo)出數(shù)據(jù)庫到Oralce  
///</summary> 
publicvoidExport()  
{  
//this.ExportTable("Items_Area");  
//this.ExportTable("Items_AuditStatus");  
//this.ExportTable("Items_Degree");  
//this.ExportTable("Items_Duty");  
//this.ExportTable("Items_Education");  
//this.ExportTable("Items_Express");  
//this.ExportTable("Items_Links");  
//this.ExportTable("Items_MembershipLevels");  
//this.ExportTable("Items_Nationality");  
//this.ExportTable("Items_NewsCategory");  
//this.ExportTable("Items_OnSale");  
//this.ExportTable("Items_OrganizeCategory");  
//this.ExportTable("Items_Party");  
//this.ExportTable("Items_Pattern");  
//this.ExportTable("Items_PayCategory");  
//this.ExportTable("Items_PostCategory");  
//this.ExportTable("Items_RoleCategory");  
//this.ExportTable("Items_SalaryItemCategory");  
//this.ExportTable("Items_SendCategory");  
//this.ExportTable("Items_Sex");  
//this.ExportTable("Items_Title");  
//this.ExportTable("Items_Units");  
//this.ExportTable("Items_UserAuditStates");  
//this.ExportTable("Items_Wed");  
//this.ExportTable("Items_WorkCategory");  
//this.ExportTable("Items_WorkFlowCategories");  
//this.ExportTable("Items_WorkingProperty");  
//this.ExportTable("Base_Businesscard");  
//this.ExportTable("Base_Comment");  
//this.ExportTable("Base_Contact");  
//this.ExportTable("Base_ContactDetails");  
//this.ExportTable("Base_Exception");  
//this.ExportTable("Base_File");  
//this.ExportTable("Base_Folder");  
//this.ExportTable("Base_Items");  
//this.ExportTable("Base_Log");  
//this.ExportTable("Base_Message");  
//this.ExportTable("Base_News");  
 
//this.ExportTable("Base_Organize");  
//this.ExportTable("Base_Module","SELECT*FROMBASE_MODULEORDERBYPARENTID,ID");  
//this.ExportTable("Base_PermissionItem");  
//this.ExportTable("Base_Role");  
//this.ExportTable("Base_Staff");  
//this.ExportTable("Base_Parameter");  
//this.ExportTable("Base_Project");  
//this.ExportTable("Base_Permission");  
//this.ExportTable("Base_PermissionScope");  
this.ExportTable("Base_Sequence");  
//this.ExportTable("Base_StaffOrganize");  
//this.ExportTable("Base_TableColumns");  
//this.ExportTable("Base_User");  
//this.ExportTable("Base_UserAddress");  
//this.ExportTable("Base_UserOrganize");  
//this.ExportTable("Base_UserRole");  
//this.ExportTable("Base_StaffOrganize");  
//this.ExportTable("Base_WorkFlowActivity");  
//this.ExportTable("Base_WorkFlowCurrent");  
//this.ExportTable("Base_WorkFlowHistory");  
//this.ExportTable("Base_WorkFlowProcess");  
System.Console.ReadLine();  
}  
publicvoidExportTable(stringtableName)  
{  
ExportTable(tableName,tableName);  
}  
///<summary> 
///導(dǎo)出一個(gè)表  
///</summary> 
///<paramnameparamname="tableName">表名</param> 
///<paramnameparamname="table">里面的數(shù)據(jù)</param> 
publicvoidExportTable(stringtableName,stringtable)  
{  
//這里是獲取數(shù)據(jù)  
SqlHelpersqlHelper=newSqlHelper("DataSource=localhost;InitialCatalog=UserCenterV32;IntegratedSecurity=SSPI;");  
sqlHelper.Open();  
DataTabledataTable=newDataTable(tableName);  
if(tableName.Equals(table))  
{  
dataTable=sqlHelper.Fill("SELECT*FROM"+table);  
}  
else  
{  
dataTable=sqlHelper.Fill(table);  
}  
sqlHelper.Close();  
//這里是插入數(shù)據(jù)  
OracleHelperoracleHelper=newOracleHelper("DataSource=ORACLE11;user=DBO_USERCENTERV32;password=DBO_USERCENTERV32;");  
oracleHelper.Open();  
oracleHelper.BeginTransaction();  
SQLBuildersqlBuilder=newSQLBuilder(oracleHelper);  
try  
{  
//清除表數(shù)據(jù)  
oracleHelper.ExecuteNonQuery("TRUNCATETABLE"+tableName);  
//創(chuàng)建配套的序列  
//oracleHelper.ExecuteNonQuery("createsequenceSEQ_"+tableName+"minvalue1maxvalue999999999999999999999999startwith1incrementby1cache20");  
intr=0;  
for(r=0;r<dataTable.Rows.Count;r++)  
{  
sqlBuilder.BeginInsert(tableName);  
for(inti=0;i<dataTable.Columns.Count;i++)  
{  
sqlBuilder.SetValue(dataTable.Columns[i].ColumnName,dataTable.Rows[r][dataTable.Columns[i].ColumnName]);  
}  
sqlBuilder.EndInsert();  
System.Console.WriteLine("表"+tableName+"已插入第"+r.ToString()+"行");  
}  
System.Console.WriteLine("--表"+tableName+"共插入"+r.ToString()+"行");  
oracleHelper.CommitTransaction();  
}  
catch(System.Exceptionexception)  
{  
oracleHelper.RollbackTransaction();  
System.Console.WriteLine(tableName+"--"+exception.Message);  
}  
finally  
{  
oracleHelper.Close();  
}  
}  
} 

以上就是SQL Server 2005導(dǎo)入Oracle 10g的C#源碼程序的全部內(nèi)容，本文我們就介紹到這里了，希望本次的介紹能夠?qū)δ兴斋@！

【編輯推薦】

1. Oracle數(shù)據(jù)庫學(xué)習(xí)筆記之表的聯(lián)合查詢
2. Oracle數(shù)據(jù)庫RMAN不完全恢復(fù)之基于SCN恢復(fù)
3. Oracle數(shù)據(jù)庫RMAN不完全恢復(fù)之基于時(shí)間恢復(fù)
4. Oracle C#實(shí)現(xiàn)Oracle Text全文檢索的簡單例子
5. Oracle數(shù)據(jù)庫RMAN不完全恢復(fù)之基于日志序列號恢復(fù)