省錢大作戰從MS-SQL跳槽到MySQL：第五步透過 MsSQL 備份 MySQL 資料庫

 MySQLDUMP 是官方推薦的資料庫備份工具，只是遇到中文就有一堆問題，乾脆自己寫一個備份程式。

◎  安裝   MS-SQL   Express：

下載並執行 SQLEXPRADV_x64_CHT.exe 安裝 MS-SQL Express，目前使用的是 2014 版。

◎  建立資料庫：

執行 SQL Server 2014 Management Studio --> 連上資料庫 --> Create DataBase KT; --> Use KT; --> 在 Query 視窗輸入： CREATE TABLE ADJ ( ADJ_ID NVarChar(12) NOT NULL, D_TRAN NVarChar(10) NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, STR_ID NVarChar(4) NULL, AM NVarChar(1) NULL, P_TRAN NUMERIC(16, 2) NULL, Q_ONHAND NUMERIC(16, 2) NULL, Q_TRAN NUMERIC(16, 2) NULL, EMP_ID NVarChar(10) NULL, REMARK NVarChar(40) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(6) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(ADJ_ID)); CREATE TABLE ADL ( PART_NO NVarChar(10) NOT NULL, PART_SP NVarChar(10) NOT NULL, DLR_VND NVarChar(10) NOT NULL, P_ORD NUMERIC(16, 2) NULL, Q_ORD NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO, PART_SP, DLR_VND)); CREATE TABLE APM ( DLR_VND NVarChar(10) NOT NULL, YY SMALLINT NOT NULL, MM SMALLINT NOT NULL, MC NVarChar(1) NOT NULL, NAME NVarChar(40) NULL, EMP_ID NVarChar(10) NULL, RCM_CNT SMALLINT NULL, A_RCV NUMERIC(16, 2) NULL, A_RTV NUMERIC(16, 2) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, A_BEG NUMERIC(16, 2) NULL, D_AP NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(DLR_VND, YY, MM, MC)); CREATE TABLE ARM ( DLR_VND NVarChar(10) NOT NULL, YY SMALLINT NOT NULL, MM SMALLINT NOT NULL, NAME NVarChar(40) NULL, EMP_ID NVarChar(10) NULL, DOC_NO NVarChar(10) NULL, SHM_CNT SMALLINT NULL, A_SHIP NUMERIC(16, 2) NULL, A_RFD NUMERIC(16, 2) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, A_BEG NUMERIC(16, 2) NULL, REMARK NVarChar(40) NULL, D_AR NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(DLR_VND, YY, MM)); CREATE TABLE AVL ( PART_NO NVarChar(10) NOT NULL, PART_SP NVarChar(10) NOT NULL, DLR_VND NVarChar(10) NOT NULL, P_ORD NUMERIC(16, 2) NULL, Q_ORD NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO, PART_SP, DLR_VND)); CREATE TABLE BNK ( BNK_ID NVarChar(12) NOT NULL, TYPE NVarChar(1) NULL, NAME NVarChar(40) NULL, ACCT_NO NVarChar(16) NULL, CURR NVarChar(4) NULL, REMARK NVarChar(40) NULL, P_RATE NUMERIC(16, 2) NULL, A_SAVE NUMERIC(16, 2) NULL, A_INT NUMERIC(16, 2) NULL, A_TAX NUMERIC(16, 2) NULL, A_LOAN NUMERIC(16, 2) NULL, A_USED NUMERIC(16, 2) NULL, A_BAL NUMERIC(16, 2) NULL, D_BEG NVarChar(10) NULL, D_END NVarChar(10) NULL, D_CLOSE NVarChar(10) NULL, D_EXPIRED NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(BNK_ID)); CREATE TABLE CND ( CNM_ID NVarChar(12) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, Q_ONHAND NUMERIC(16, 2) NULL, Q_CNT NUMERIC(16, 2) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(6) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(CNM_ID, ITEM)); CREATE TABLE CNM ( CNM_ID NVarChar(12) NOT NULL, STR_ID NVarChar(4) NULL, D_TRAN NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(CNM_ID)); CREATE TABLE COR ( COR_ID VARCHAR(10) NOT NULL, ID VARCHAR(10) NULL, NAME VARCHAR(50) NULL, NAME_E VARCHAR(50) NULL, PRN VARCHAR(10) NULL, SERIES VARCHAR(10) NULL, D_ADD nVarChar(20) NULL, D_CHG nVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(COR_ID)); CREATE TABLE CPD ( CPD_ID NVarChar(10) NOT NULL, RCM_ID NVarChar(12) NULL, DLR_VND NVarChar(10) NULL, YY SMALLINT NULL, MM SMALLINT NULL, MC NVarChar(1) NULL, NAME NVarChar(40) NULL, EMP_ID NVarChar(10) NULL, DOC_NO NVarChar(16) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, STATUS NVarChar(1) NULL, POST NVarChar(1) NULL, FLAG NVarChar(1) NULL, REMARK NVarChar(40) NULL, D_PAY NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(CPD_ID)); CREATE TABLE CRD ( CRD_ID NVarChar(10) NOT NULL, SHM_ID NVarChar(12) NULL, DLR_VND NVarChar(10) NULL, YY SMALLINT NULL, MM SMALLINT NULL, MC NVarChar(1) NULL, DVM_SEQ INT NULL, NAME NVarChar(40) NULL, EMP_ID NVarChar(10) NULL, DOC_NO NVarChar(16) NULL, PRINT_CNT SMALLINT NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, STATUS NVarChar(1) NULL, POST NVarChar(1) NULL, FLAG NVarChar(1) NULL, REMARK NVarChar(40) NULL, D_RCV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(CRD_ID)); CREATE TABLE DEP ( DEP_ID NVarChar(10) NOT NULL, NAME NVarChar(20) NULL, REMARK NVarChar(40) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(DEP_ID)); CREATE TABLE DVM ( DLR_VND NVarChar(10) NOT NULL, DVM_SEQ INT NULL, ID_CODE NVarChar(8) NULL, ID_2 NVarChar(8) NULL, NAME NVarChar(40) NULL, NAME_TITLE NVarChar(40) NULL, EMP_ID NVarChar(10) NULL, TYPE NVarChar(1) NULL, TAX NVarChar(6) NULL, HOLD NVarChar(1) NULL, CASH NVarChar(1) NULL, RANK NVarChar(1) NULL, ACCT_1 NVarChar(10) NULL, ACCT_2 NVarChar(10) NULL, ADDR_S NVarChar(60) NULL, ADDR_I NVarChar(60) NULL, TEL_1 NVarChar(50) NULL, TEL_2 NVarChar(50) NULL, FAX NVarChar(50) NULL, TPM_ID NVarChar(18) NULL, PRESIDENT NVarChar(20) NULL, CONTECT NVarChar(20) NULL, POSITION NVarChar(20) NULL, TER_ID NVarChar(4) NULL, CLASS NVarChar(10) NULL, OLD_DLR_VND NVarChar(10) NULL, ZIP NVarChar(6) NULL, ZIP_2 NVarChar(6) NULL, CURR NVarChar(4) NULL, FIX_PCT NUMERIC(16, 2) NULL, REMARK NVarChar(60) NULL, A_QUOT NUMERIC(16, 2) NULL, A_ORD NUMERIC(16, 2) NULL, D_QUOT NVarChar(10) NULL, D_ORD NVarChar(10) NULL, D_EXPIRE NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(DLR_VND)); CREATE TABLE EMP ( EMP_ID NVarChar(10) NOT NULL, NAME NVarChar(10) NULL, ID_CODE NVarChar(10) NULL, SEX NVarChar(1) NULL, QUIT NVarChar(1) NULL, REPORT NVarChar(1) NULL, DEP_ID NVarChar(4) NULL, TEL_1 NVarChar(18) NULL, TEL_2 NVarChar(18) NULL, TITLE NVarChar(20) NULL, ADDR NVarChar(60) NULL, ADDR_I NVarChar(60) NULL, EDUCATION NVarChar(40) NULL, A_BASE INT NULL, D_BIRTH NVarChar(10) NULL, D_HIRE NVarChar(10) NULL, D_QUIT NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(EMP_ID)); CREATE TABLE ICM ( PART_NO NVarChar(10) NOT NULL, DESC_C NVarChar(40) NULL, UM NVarChar(6) NULL, ICM_SP INT NULL, REMARK NVarChar(40) NULL, OLD_PART_NO NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO)); CREATE TABLE ITH ( PART_NO NVarChar(10) NOT NULL, PART_SP NVarChar(10) NOT NULL, D_TRAN NVarChar(10) NOT NULL, P_STD NUMERIC(16, 2) NULL, P_CUR NUMERIC(16, 2) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO, PART_SP, D_TRAN)); CREATE TABLE ITM ( PART_NO NVarChar(10) NOT NULL, PART_SP NVarChar(10) NOT NULL, SEQ INT NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, BRAND NVarChar(20) NULL, UM NVarChar(6) NULL, HOLD NVarChar(1) NULL, ONSALE NVarChar(1) NULL, TYPE NVarChar(1) NULL, STATUS NVarChar(1) NULL, ICM_SP INT NULL, IVS_PART NVarChar(20) NULL, OLD_PART_NO NVarChar(10) NULL, OLD_PART_SP INT NULL, CURR NVarChar(4) NULL, REMARK NVarChar(20) NULL, P_CUR NUMERIC(16, 2) NULL, P_NEW NUMERIC(16, 2) NULL, P_STD NUMERIC(16, 2) NULL, P_A NUMERIC(16, 2) NULL, P_B NUMERIC(16, 2) NULL, P_C NUMERIC(16, 2) NULL, P_D NUMERIC(16, 2) NULL, P_E NUMERIC(16, 2) NULL, P_AVG NUMERIC(16, 2) NULL, P_RCV NUMERIC(16, 2) NULL, P_FOB NUMERIC(16, 2) NULL, P_PROM NUMERIC(16, 2) NULL, P_ONSALE NUMERIC(16, 2) NULL, Q_SAFETY INT NULL, D_EFF NVarChar(10) NULL, D_HOLD NVarChar(10) NULL, D_BEG NVarChar(10) NULL, D_END NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO, PART_SP)); CREATE TABLE NCM ( NCM_ID NVarChar(1) NOT NULL, CAPITAL NVarChar(2) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(NCM_ID)); CREATE TABLE NPD ( NPD_ID NVarChar(12) NOT NULL, D_CHECK NVarChar(10) NULL, A_CHECK NUMERIC(16, 2) NULL, BNK_ID NVarChar(12) NULL, ACCT_NO NVarChar(16) NULL, CPD_ID NVarChar(10) NULL, VND_ID NVarChar(10) NULL, YY INT NULL, MM INT NULL, NAME NVarChar(40) NULL, DLR_FROM NVarChar(10) NULL, SERIAL_NO NVarChar(10) NULL, DOC_NO NVarChar(10) NULL, MC NVarChar(1) NULL, SC NVarChar(1) NULL, STATUS NVarChar(1) NULL, POST NVarChar(1) NULL, RCM_ID NVarChar(12) NULL, D_OPEN NVarChar(10) NULL, D_PAY NVarChar(10) NULL, D_CASH NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(NPD_ID)); CREATE TABLE NRD ( NRD_ID NVarChar(12) NOT NULL, D_CHECK NVarChar(10) NULL, A_CHECK NUMERIC(16, 2) NULL, CHECK_BANK NVarChar(20) NULL, BANK_NAME NVarChar(20) NULL, CHECK_ACCT NVarChar(16) NULL, DLR_ID NVarChar(10) NULL, YY INT NULL, MM INT NULL, CRD_ID NVarChar(10) NULL, NAME NVarChar(40) NULL, BNK_ID NVarChar(12) NULL, SEQ INT NULL, VND_TO NVarChar(10) NULL, SERIAL_NO NVarChar(10) NULL, DEPOSIT_NO NVarChar(10) NULL, DOC_NO NVarChar(10) NULL, TO_NAME NVarChar(40) NULL, MC NVarChar(1) NULL, SC NVarChar(1) NULL, STATUS NVarChar(1) NULL, TERR NVarChar(1) NULL, SHM_ID NVarChar(12) NULL, D_OPEN NVarChar(10) NULL, D_RCV NVarChar(10) NULL, D_DEPOSIT NVarChar(10) NULL, D_SAVE NVarChar(10) NULL, D_CASH NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(NRD_ID)); CREATE TABLE PGM ( PGM_ID NVarChar(6) NOT NULL, NAME NVarChar(40) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, PRIMARY KEY(PGM_ID)); CREATE TABLE POD ( POM_ID NVarChar(16) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(4) NULL, PRN NVarChar(1) NULL, STR_ID NVarChar(4) NULL, REMARK NVarChar(20) NULL, P_ORD NUMERIC(16, 2) NULL, P_NEW NUMERIC(16, 2) NULL, Q_ORD NUMERIC(16, 2) NULL, Q_RCV NUMERIC(16, 2) NULL, A_ORD NUMERIC(16, 2) NULL, A_NT NUMERIC(16, 2) NULL, D_DLV NVarChar(10) NULL, D_RCV NVarChar(10) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(POM_ID, ITEM)); CREATE TABLE POM ( POM_ID NVarChar(16) NOT NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, NAME NVarChar(40) NULL, REMARK NVarChar(60) NULL, MC NVarChar(1) NULL, POST NVarChar(1) NULL, FLAG NVarChar(1) NULL, TAX NVarChar(6) NULL, STR_ID NVarChar(4) NULL, CURR NVarChar(4) NULL, PRINT_CNT SMALLINT NULL, R_EXCH NUMERIC(16, 2) NULL, A_ORD NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_DLV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(POM_ID)); CREATE TABLE QID ( QIM_ID NVarChar(10) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, P_QUOT NUMERIC(16, 2) NULL, Q_QUOT NUMERIC(16, 2) NULL, A_QUOT NUMERIC(16, 2) NULL, UM NVarChar(4) NULL, D_DLV NVarChar(10) NULL, REMARK NVarChar(10) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(QIM_ID, ITEM)); CREATE TABLE QIM ( QIM_ID NVarChar(10) NOT NULL, DLR_VND NVarChar(10) NULL, NAME NVarChar(40) NULL, EMP_ID NVarChar(10) NULL, TAX NVarChar(6) NULL, CURR NVarChar(4) NULL, A_QUOT NUMERIC(16, 2) NULL, A_COST NUMERIC(16, 2) NULL, D_QUOT NVarChar(10) NULL, D_EXPIRED NVarChar(10) NULL, TERMS NVarChar(40) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(QIM_ID)); CREATE TABLE QOD ( QOM_ID NVarChar(10) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, P_QUOT NUMERIC(16, 2) NULL, Q_QUOT NUMERIC(16, 2) NULL, A_QUOT NUMERIC(16, 2) NULL, P_COST NUMERIC(16, 2) NULL, UM NVarChar(4) NULL, REMARK NVarChar(40) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(QOM_ID, ITEM)); CREATE TABLE QOM ( QOM_ID NVarChar(10) NOT NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, NAME NVarChar(40) NULL, TAX NVarChar(6) NULL, RANK NVarChar(1) NULL, A_QUOT NUMERIC(16, 2) NULL, D_QUOT NVarChar(10) NULL, D_EXPIRED NVarChar(10) NULL, TERMS NVarChar(40) NULL, MEMO NVarChar(238) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, PRIMARY KEY(QOM_ID)); CREATE TABLE RCD ( RCM_ID NVarChar(12) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(4) NULL, ICM_SP INT NULL, TYPE NVarChar(1) NULL, FREE NVarChar(1) NULL, POST NVarChar(1) NULL, STK NVarChar(1) NULL, INV_NO NVarChar(12) NULL, STR_ID NVarChar(4) NULL, Q_FIRM NUMERIC(16, 2) NULL, Q_RCV NUMERIC(16, 2) NULL, Q_STK NUMERIC(16, 2) NULL, P_ORD NUMERIC(16, 2) NULL, P_COST NUMERIC(16, 2) NULL, A_RCV NUMERIC(16, 2) NULL, A_NT NUMERIC(16, 2) NULL, A_DISCOUNT NUMERIC(16, 2) NULL, D_DLV NVarChar(10) NULL, D_RCV NVarChar(10) NULL, D_DISCOUNT NVarChar(10) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(RCM_ID, ITEM)); CREATE TABLE RCDDBK ( RCM_ID NVarChar(12) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(4) NULL, ICM_SP INT NULL, TYPE NVarChar(1) NULL, FREE NVarChar(1) NULL, POST NVarChar(1) NULL, STK NVarChar(1) NULL, INV_NO NVarChar(12) NULL, STR_ID NVarChar(4) NULL, Q_FIRM NUMERIC(16, 2) NULL, Q_RCV NUMERIC(16, 2) NULL, Q_STK NUMERIC(16, 2) NULL, P_ORD NUMERIC(16, 2) NULL, P_COST NUMERIC(16, 2) NULL, A_RCV NUMERIC(16, 2) NULL, A_NT NUMERIC(16, 2) NULL, A_DISCOUNT NUMERIC(16, 2) NULL, D_DLV NVarChar(10) NULL, D_RCV NVarChar(10) NULL, D_DISCOUNT NVarChar(10) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(RCM_ID, ITEM)); CREATE TABLE RCM ( RCM_ID NVarChar(12) NOT NULL, INV_NO NVarChar(10) NULL, POM_ID NVarChar(16) NULL, SHIPPER NVarChar(10) NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, DVM_SEQ INT NULL, YY SMALLINT NULL, MM SMALLINT NULL, TYPE NVarChar(1) NULL, MC NVarChar(1) NULL, NAME NVarChar(40) NULL, ADDR NVarChar(60) NULL, TEL NVarChar(18) NULL, REMARK NVarChar(40) NULL, STK NVarChar(1) NULL, RANK NVarChar(1) NULL, POST NVarChar(1) NULL, SHIP_VIA NVarChar(1) NULL, TAX NVarChar(1) NULL, PAY NVarChar(1) NULL, STR_ID NVarChar(4) NULL, PRINT_CNT SMALLINT NULL, A_RCV NUMERIC(16, 2) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_DLV NVarChar(10) NULL, D_RCV NVarChar(10) NULL, D_INV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(RCM_ID)); CREATE TABLE RCMDBK ( RCM_ID NVarChar(12) NOT NULL, INV_NO NVarChar(10) NULL, POM_ID NVarChar(16) NULL, SHIPPER NVarChar(10) NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, DVM_SEQ INT NULL, YY SMALLINT NULL, MM SMALLINT NULL, TYPE NVarChar(1) NULL, MC NVarChar(1) NULL, NAME NVarChar(40) NULL, ADDR NVarChar(60) NULL, TEL NVarChar(18) NULL, REMARK NVarChar(40) NULL, STK NVarChar(1) NULL, RANK NVarChar(1) NULL, POST NVarChar(1) NULL, SHIP_VIA NVarChar(1) NULL, TAX NVarChar(1) NULL, PAY NVarChar(1) NULL, STR_ID NVarChar(4) NULL, PRINT_CNT SMALLINT NULL, A_RCV NUMERIC(16, 2) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_DLV NVarChar(10) NULL, D_RCV NVarChar(10) NULL, D_INV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(RCM_ID)); CREATE TABLE SEM ( PART_NO NVarChar(10) NOT NULL, PART_SP NVarChar(10) NOT NULL, STR_ID NVarChar(4) NOT NULL, YY SMALLINT NOT NULL, MM SMALLINT NOT NULL, A_FORECAST NUMERIC(16, 2) NULL, Q_BEG NUMERIC(16, 2) NULL, A_BEG NUMERIC(16, 2) NULL, Q_RCV NUMERIC(16, 2) NULL, A_RCV NUMERIC(16, 2) NULL, Q_RTV NUMERIC(16, 2) NULL, A_RTV NUMERIC(16, 2) NULL, Q_SHIP NUMERIC(16, 2) NULL, A_SHIP NUMERIC(16, 2) NULL, Q_RFD NUMERIC(16, 2) NULL, A_RFD NUMERIC(16, 2) NULL, Q_ADJ NUMERIC(16, 2) NULL, Q_CNT NUMERIC(16, 2) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO, PART_SP, STR_ID, YY, MM)); CREATE TABLE SHD ( SHM_ID NVarChar(12) NOT NULL, ITEM SMALLINT NOT NULL, SOM_ID NVarChar(10) NULL, SOD_ITEM SMALLINT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(4) NULL, ICM_SP INT NULL, TYPE NVarChar(1) NULL, FREE NVarChar(1) NULL, POST NVarChar(1) NULL, STK NVarChar(1) NULL, Q_FIRM NUMERIC(16, 2) NULL, Q_SHIP NUMERIC(16, 2) NULL, Q_STK NUMERIC(16, 2) NULL, P_ORD NUMERIC(16, 2) NULL, P_COST NUMERIC(16, 2) NULL, A_SHIP NUMERIC(16, 2) NULL, A_DISCOUNT NUMERIC(16, 2) NULL, D_DLV NVarChar(10) NULL, D_SHIP NVarChar(10) NULL, D_DISCOUNT NVarChar(10) NULL, REMARK NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SHM_ID, ITEM)); CREATE TABLE SHDDBK ( SHM_ID NVarChar(12) NOT NULL, ITEM SMALLINT NOT NULL, SOM_ID NVarChar(10) NULL, SOD_ITEM SMALLINT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(4) NULL, ICM_SP INT NULL, TYPE NVarChar(1) NULL, FREE NVarChar(1) NULL, POST NVarChar(1) NULL, STK NVarChar(1) NULL, Q_FIRM NUMERIC(16, 2) NULL, Q_SHIP NUMERIC(16, 2) NULL, Q_STK NUMERIC(16, 2) NULL, P_ORD NUMERIC(16, 2) NULL, P_COST NUMERIC(16, 2) NULL, A_SHIP NUMERIC(16, 2) NULL, A_DISCOUNT NUMERIC(16, 2) NULL, D_DLV NVarChar(10) NULL, D_SHIP NVarChar(10) NULL, D_DISCOUNT NVarChar(10) NULL, REMARK NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SHM_ID, ITEM)); CREATE TABLE SHM ( SHM_ID NVarChar(12) NOT NULL, D_SHIP NVarChar(10) NULL, INV_NO NVarChar(10) NULL, SOM_ID NVarChar(10) NULL, SHIPPER NVarChar(10) NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, DVM_SEQ INT NULL, YY SMALLINT NULL, MM SMALLINT NULL, TYPE NVarChar(1) NULL, MC NVarChar(1) NULL, NAME NVarChar(40) NULL, ADDR NVarChar(60) NULL, TEL NVarChar(18) NULL, REMARK NVarChar(40) NULL, STK NVarChar(1) NULL, RANK NVarChar(1) NULL, POST NVarChar(1) NULL, SHIP_VIA NVarChar(1) NULL, TAX NVarChar(1) NULL, RCV NVarChar(1) NULL, STR_ID NVarChar(4) NULL, PRINT_CNT SMALLINT NULL, A_SHIP NUMERIC(16, 2) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_TEMP NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_DLV NVarChar(10) NULL, D_INV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SHM_ID)); CREATE TABLE SHMDBK ( SHM_ID NVarChar(12) NOT NULL, D_SHIP NVarChar(10) NULL, INV_NO NVarChar(10) NULL, SOM_ID NVarChar(10) NULL, SHIPPER NVarChar(10) NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, DVM_SEQ INT NULL, YY SMALLINT NULL, MM SMALLINT NULL, TYPE NVarChar(1) NULL, MC NVarChar(1) NULL, NAME NVarChar(40) NULL, ADDR NVarChar(60) NULL, TEL NVarChar(18) NULL, REMARK NVarChar(40) NULL, STK NVarChar(1) NULL, RANK NVarChar(1) NULL, POST NVarChar(1) NULL, SHIP_VIA NVarChar(1) NULL, TAX NVarChar(1) NULL, RCV NVarChar(1) NULL, STR_ID NVarChar(4) NULL, PRINT_CNT SMALLINT NULL, A_SHIP NUMERIC(16, 2) NULL, A_CASH NUMERIC(16, 2) NULL, A_CHECK NUMERIC(16, 2) NULL, A_DISC_INT NUMERIC(16, 2) NULL, A_DISC_BAL NUMERIC(16, 2) NULL, A_DISC_ITEM NUMERIC(16, 2) NULL, A_DISC_OTHER NUMERIC(16, 2) NULL, A_TEMP NUMERIC(16, 2) NULL, A_INV NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_DLV NVarChar(10) NULL, D_INV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SHM_ID)); CREATE TABLE SID ( PART_NO NVarChar(10) NOT NULL, PART_SP NVarChar(10) NOT NULL, STR_ID NVarChar(4) NOT NULL, LOCATION NVarChar(10) NULL, DESC_C NVarChar(40) NULL, DESC_E NVarChar(40) NULL, UM NVarChar(6) NULL, Q_ONHAND NUMERIC(16, 2) NULL, P_AVG NUMERIC(16, 2) NULL, Q_BOY NUMERIC(16, 2) NULL, A_BOY NUMERIC(16, 2) NULL, Q_HOLD NUMERIC(16, 2) NULL, Q_CNT NUMERIC(16, 2) NULL, Q_POST NUMERIC(16, 2) NULL, D_RCV NVarChar(10) NULL, D_SHIP NVarChar(10) NULL, D_CNT NVarChar(10) NULL, D_TSF NVarChar(10) NULL, D_ADJ NVarChar(10) NULL, D_HOLD NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(PART_NO, PART_SP, STR_ID)); CREATE TABLE SNM ( SNM_ID NVarChar(10) NOT NULL, SERIAL INT NULL, LENGTH SMALLINT NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SNM_ID)); CREATE TABLE SOD ( SOM_ID NVarChar(10) NOT NULL, ITEM SMALLINT NOT NULL, PART_NO NVarChar(10) NULL, PART_SP NVarChar(10) NULL, DESC_C NVarChar(40) NULL, UM NVarChar(4) NULL, TYPE NVarChar(1) NULL, TRAVEL NVarChar(1) NULL, STR_ID NVarChar(4) NULL, REMARK NVarChar(20) NULL, CURR NVarChar(4) NULL, Q_ORD INT NULL, Q_SHIP INT NULL, P_ORD NUMERIC(16, 2) NULL, A_ORD NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_SHIP NVarChar(10) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SOM_ID, ITEM)); CREATE TABLE SOM ( SOM_ID NVarChar(10) NOT NULL, EMP_ID NVarChar(10) NULL, DLR_VND NVarChar(10) NULL, NAME NVarChar(40) NULL, ADDR NVarChar(60) NULL, TEL NVarChar(18) NULL, REMARK NVarChar(40) NULL, MC NVarChar(1) NULL, TAX NVarChar(1) NULL, STR_ID NVarChar(4) NULL, PRINT_CNT SMALLINT NULL, A_ORD NUMERIC(16, 2) NULL, D_ORD NVarChar(10) NULL, D_DLV NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SOM_ID)); CREATE TABLE STR ( STR_ID NVarChar(4) NOT NULL, NAME NVarChar(20) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(STR_ID)); CREATE TABLE SYS ( SYS_ID NVarChar(10) NOT NULL, VALUE NUMERIC(16, 2) NULL, DATE NVarChar(10) NULL, TYPE NVarChar(10) NULL, DATA NVarChar(20) NULL, REMARK NVarChar(80) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(SYS_ID)); CREATE TABLE TER ( TER_ID NVarChar(4) NOT NULL, NAME NVarChar(40) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, USR_CHG NVarChar(10) NULL, IP_CHG NVarChar(20) NULL, PRIMARY KEY(TER_ID)); CREATE TABLE UPM ( USR_ID NVarChar(10) NOT NULL, MODULE NVarChar(4) NOT NULL, ITEM SMALLINT NOT NULL, PGM_ID NVarChar(6) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, PRIMARY KEY(USR_ID, MODULE, ITEM)); CREATE TABLE USR ( USR_ID NVarChar(10) NOT NULL, PASSWD NVarChar(10) NULL, D_ADD NVarChar(20) NULL, D_CHG NVarChar(20) NULL, PRIMARY KEY(USR_ID));

--> 然後按執行建立資料表  (這個 SQL Script  與 MySQL 所用的相同)。

◎  Windows   轉檔程式：

    以系統管理員身份啟動 Visual Stdio --> 檔案 --> 新增 --> 專案 -->

C#新增專案

選擇 Windows Form 應用程式 --> 名稱：MySQL2MSWinAP --> 確定。

◎  設計畫面：

轉檔程式畫面設計

Form1 放入 buttonMy2MS，buttonBACKUP，buttonEXIT三個按鍵。再放入 textBoxMsSql，textBoxMysql，textBoxBackDir 三個 TextBox，並且將 Enabled 設為 False。在三個 TextBox 之前放入 Label，並標上適當文字。最後加上 dataGridView。習慣上我還會將 Form1 之 WindowState 放到最大：Maximized。

◎  專案加入參考：

   專案 --> 加入參考 --> C:\Program Files (x86)\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.0\MySql.Data.dll 其中 v4.0 符合 .Net Framework 4.0 。與專案的 .NET Framework 相符--> 加入 --> 確定。

MySQL Connector Net 6.8.3 v4.0

◎撰寫程式：

  Form1 上 buttonMy2MS，buttonBACKUP，buttonEXIT三個按鍵都雙擊一次。 開始撰寫轉檔程式。
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using MySql.Data.MySqlClient; using System.Diagnostics; namespace MySQL2MSWinAP { public partial class MAINForm : Form { public int MaxWidth = 1024; public int MaxHeight = 768; public string ConnectionStringMSSQL = @"server=localhost\SQLEXPRESS;database=KT;uid=PAM;pwd=12345678"; public string ConnectionStringMySql = @"server=localhost;database=KT;uid=root;pwd=12345678;charset=utf8;PORT=3306;"; public MAINForm() { InitializeComponent(); textBoxBackDir.Text = @"C:\KT\BACKSQL"; MaxWidth = (int)System.Windows.Forms.Screen.PrimaryScreen.Bounds.Width; MaxHeight = (int)System.Windows.Forms.Screen.PrimaryScreen.Bounds.Height; dataGridView1.Size = new Size(MaxWidth - dataGridView1.Location.X - 80, MaxHeight - dataGridView1.Location.Y - 190); } private void buttonMy2MS_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; DateTime t_beg = System.DateTime.Now; DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt.Columns.Add("Table", typeof(String)); dt.Columns.Add("MsSql", typeof(int)); dt.Columns.Add("MySql", typeof(int)); dt.PrimaryKey = new DataColumn[] { dt.Columns["Table"] }; string Txt = ""; int iMySql = 0; int iMsSql = 0; try { MySqlConnection SC_MySql = new MySqlConnection(ConnectionStringMySql); SC_MySql.Open(); Txt = "Show tables"; MySqlDataAdapter DA_MyTables = new MySqlDataAdapter(Txt, SC_MySql); DataTable DT_MyTables = ds.Tables.Add("DT_MyTables"); DA_MyTables.Fill(ds, "DT_MyTables"); for (int i = 0; i < DT_MyTables.Rows.Count; i++) { if (DT_MyTables.Rows[i].ItemArray[0] != null && DT_MyTables.Rows[i].ItemArray[0].ToString().Length > 0) { string TableName = DT_MyTables.Rows[i].ItemArray[0].ToString(); Txt = "Select * from " + TableName; MySqlDataAdapter DA_MyTable = new MySqlDataAdapter(Txt, SC_MySql); DataTable DT_MyTable = ds.Tables.Add("DT_MyTable" + i.ToString()); DA_MyTable.Fill(ds, "DT_MyTable" + i.ToString()); int iMy = DT_MyTable.Rows.Count; int iMs = Post1(TableName, DT_MyTable); DataRow dr1 = dt.NewRow(); dr1["Table"] = TableName; dr1["MySql"] = iMy; dr1["MsSql"] = iMs; dt.Rows.Add(dr1); iMySql += iMy; iMsSql += iMs; } } dataGridView1.DataSource = dt; if (dataGridView1.Rows.Count > 0) { dataGridView1.Sort(dataGridView1.Columns[0], ListSortDirection.Ascending); dataGridView1.Columns[1].DefaultCellStyle.Format = "n0"; dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns[2].DefaultCellStyle.Format = "n0"; dataGridView1.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } ds.Dispose(); SC_MySql.Close(); SC_MySql.Dispose(); textBoxMySql.Text = String.Format("{0,12:n0}", iMySql); textBoxMsSql.Text = String.Format("{0,12:n0}", iMsSql); } catch (MySqlException ex) { MessageBox.Show("MySQL 錯誤 : " + Txt + " " + ex.Number + " " + ex.Message); } catch (Exception ex) { MessageBox.Show("MySQL 錯誤 : " + Txt + " " + ex.Message); } finally { } DateTime t_end = System.DateTime.Now; TimeSpan diff = t_end - t_beg; MessageBox.Show("轉檔完成，耗時 : " + String.Format("{0} 時 {1} 分 {2} 秒", diff.Hours, diff.Minutes, diff.Seconds)); Cursor.Current = Cursors.Default; } private int Post1(string TableName, DataTable dtMySql) { int iCount = 0; SqlConnection SC_MsSql = new SqlConnection(ConnectionStringMSSQL); SC_MsSql.Open(); string Txt = ""; try { Txt = "Truncate Table " + TableName; SqlCommand sqlCommand = new SqlCommand(Txt, SC_MsSql); sqlCommand.ExecuteNonQuery(); using (SqlBulkCopy SBC = new SqlBulkCopy(SC_MsSql)) { SBC.DestinationTableName = TableName; SBC.BatchSize = 10000; decimal dTO = dtMySql.Rows.Count / 10000; int iTO = (int)Math.Truncate(dTO); if (iTO < 120) { iTO = 120; } SBC.BulkCopyTimeout = iTO; SqlCommand SC_PGM = new SqlCommand(Txt, SC_MsSql); SBC.WriteToServer(dtMySql); iCount = dtMySql.Rows.Count; } } catch (Exception ex) { MessageBox.Show("MSSQL 錯誤 : " + ex.Message); } finally { } SC_MsSql.Close(); SC_MsSql.Dispose(); return iCount; } private void buttonBACKUP_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; int iMySql = 0; int iMsSql = 0; if (textBoxMySql.Text.Length > 0) { iMySql = int.Parse(textBoxMySql.Text.Replace(",", "")); } if (textBoxMsSql.Text.Length > 0) { iMsSql = int.Parse(textBoxMsSql.Text.Replace(",", "")); } if (iMySql == 0 || iMySql != iMsSql) { MessageBox.Show("請先轉檔，再備份"); return; } if (!System.IO.Directory.Exists(textBoxBackDir.Text)) { MessageBox.Show("備份目錄 : " + textBoxBackDir.Text + " 不存在，請 Check"); return; } Process proc = null; try { proc = new Process(); proc.StartInfo.WorkingDirectory = textBoxBackDir.Text; proc.StartInfo.FileName = "BACKKT.bat"; proc.StartInfo.Arguments = string.Format("10"); proc.StartInfo.CreateNoWindow = false; proc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden; proc.Start(); proc.WaitForExit(); } catch (Exception ex) { MessageBox.Show("Exception Occurred : " + ex.Message + " " + ex.StackTrace.ToString()); } Cursor.Current = Cursors.Default; MessageBox.Show("備份到 : " + textBoxBackDir.Text + " 完成，請將備份檔案 Copy 到隨身碟。"); } private void buttonEXIT_Click(object sender, EventArgs e) { this.Close(); } } }  


--> 然後按 執行

◎程式解析 ：

    ○專案參考命名空間：

       using System.Data.SqlClient;
       using MySql.Data.MySqlClient;
       using System.Diagnostics;

     ○資料庫備份目錄：
       textBoxBackDir.Text = @"C:\KT\BACKSQL";

     ○連線字串：
       public string ConnectionStringMSSQL = @"server=localhost\SQLEXPRESS;database=KT;uid=PAM;pwd=12345678";

       public string ConnectionStringMySQL = @"server=192.168.0.250;database=PAM;uid=root;pwd=12345678;charset=utf8;PORT=3306;";

    ○buttonMy2MS_Click：

       建立 dt  --> 連結 MySQL 資料庫 --> 用  Show Tables 讀出 KT 資料庫所有 Tables --> 用 SELECT * from Table 逐一讀取 MySQL 資料表 --> 先用 Truncate Table 清除 MS-SQL 資料表之資料 --> 再用 SqlBulkCopy 將資料存入 MS-SQL --> 返回存入資料筆數。
       最後將 dataGridView1 之 DataSource 綁訂為 dt，為 dataGridView1 做細部設定 --> 然後顯示抓到之總筆數。

 ○buttonBACKUP_Click：

       先 Check MySql 筆數必須大於0，且 MySql 筆數等於MsSql 筆數 --> 再 Check 資料庫備份目錄必須存在 --> 在程式中執行 BACKKT.bat --> 會產生 KT + 星期.bak 的備份檔 --> 所以會有 7 個備份檔。。

       顯示備份完成，並提示將備份檔案 Copy 到隨身碟。

 ○buttonEXIT_Click：
       結束備份程式

◎執行備份程式 ：

偵錯 --> 開始偵錯 -->  按 My --> MS

從 MySQL 將 299 萬筆資料 Copy 到 MsSQL 只需 1 分 18 秒

接著 按 Backup

將 MsSql 資料庫備份到 KT+星期.bak 會產生 7 個備份檔

◎查看備份結果 ：

程式產生的備分檔 C:\KT\BACKSQL\KT6.bak

備份程式會產生 7 個備份檔，週日為 1 ，週六為 7 。可以避免最近的備份檔有問題而無法復原的窘境。

◎自動化備份：

將 Windows 程式改成主控台程式，就可以上 Windows 排程每天自動備份。但是還是要靠人工將備份檔 Copy 到隨身碟。