SQL Server 2005导入Oracle 10g的C#源码

复制//--------------------------------------------------------------------   //AllRightsReserved,导的Copyright(C)2011,HairihanTECH,Ltd.   //--------------------------------------------------------------------   usingSystem.Data;   namespaceDotNet.Example   {   usingDotNet.BaseManager;   usingDotNet.DbUtilities;   publicclassImportExportData   {   ///<summary> ///导出数据库到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> ///导出一个表   ///</summary> ///<paramnameparamname="tableName">表名</param> ///<paramnameparamname="table">里面的数据</param> publicvoidExportTable(stringtableName,stringtable)   {   //这里是b2b供应网获取数据   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<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();   }   }   }  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.105.106.107.108.109.110.111.112.113.114.115.116.117.118.119.120.121.122.123.124.125.126.127.128.129.130.131.132.133.134.135.136.137.