SQL Server 2005导入Oracle 10g的C#源码
数据库操作中，我们有时候需要将数据从一个数据库导入到另一个数据库中。本文我们主要介绍一下SQL Server 2005导入Oracle 10g的C#源码程序，希望能够对您有所帮助。程序代码的参考如下：
//--------------------------------------------------------------------//AllRightsReserved,Copyright(C)2011,HairihanTECH,Ltd.//--------------------------------------------------------------------usingSystem.Data;namespaceDotNet.Example{usingDotNet.BaseManager;usingDotNet.DbUtilities;publicclassImportExportData{/// ///导出数据库到Oralce/// 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);}/// ///导出一个表/// ///表名 ///里面的数据 publicvoidExportTable(stringtableName,stringtable){//这里是获取数据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();//这里是插入数据OracleHelperoracleHelper=newOracleHelper("DataSource=ORACLE11;user=DBO_USERCENTERV32;password=DBO_USERCENTERV32;");oracleHelper.Open();oracleHelper.BeginTransaction();SQLBuildersqlBuilder=newSQLBuilder(oracleHelper);try{//清除表数据oracleHelper.ExecuteNonQuery("TRUNCATETABLE"+tableName);//创建配套的序列//oracleHelper.ExecuteNonQuery("createsequenceSEQ_"+tableName+"minvalue1maxvalue999999999999999999999999startwith1incrementby1cache20");intr=0;for(r=0;r
页:
[1]