# SQLServer2MySQL

**Repository Path**: icefox/sqlserver2-my-sql

## Basic Information

- **Project Name**: SQLServer2MySQL
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-12-17
- **Last Updated**: 2025-12-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README


## 开发需求
 开发WPF程序,实现从SQLServer 2008 同步数据到 Mariadb 10.11.x

## 技术规范
- WPF桌面框架
- NLog日志记录
- 数据库驱动兼容性Windows 7+ 或WinServer 2008 +
- 设置数据库连接字符串窗体,并能持久化保存配置
- 记录同步数据信息,并用表格显示,表格需要进行分页显示
- 关闭时最小化到托盘,托盘右键才允许关闭,并且关闭需要用户二次确认
- 建议使用Dapper库进行数据读写

## SQLServer表数据结构如下
```sql
CREATE TABLE [dbo].[electrode] (
  [barcode] char(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [moldno] varchar(300) COLLATE Chinese_PRC_CI_AS  NULL,
  [FType] varchar(10) COLLATE Chinese_PRC_CI_AS  NULL,
  [FName] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jingdu] nvarchar(25) COLLATE Chinese_PRC_CI_AS  NULL,
  [FMaterial] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [FSpec] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Flag] int DEFAULT 0 NULL,
  CONSTRAINT [PK_electrode] PRIMARY KEY CLUSTERED ([barcode])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)  
ON [PRIMARY]
GO

ALTER TABLE [dbo].[electrode] SET (LOCK_ESCALATION = TABLE)
```
## 同步方向 SQL Server ==> MariaDB

## 同步数据查询SQL
```sql
SELECT
	electrode.barcode, 
	electrode.moldno, 
	electrode.FType, 
	electrode.FName, 
	electrode.FMaterial, 
	electrode.FSpec, 
	electrode.Flag
FROM
	dbo.electrode
WHERE
	electrode.Flag = 0
```

## 连接字符串信息
#### SQLServer连接字符串:Data Source=10.199.89.241;Initial Catalog=MJmes_MS;User ID=rsync;Password=Rsync@2025;Encrypt=False;TrustServerCertificate=True

#### MariaDB连接字符串:Server=127.0.0.1;Port=3306;Database=hjwms_prd;Uid=share;Pwd=!shareP@ssword;Allow User Variables=true;

### Mariadb数据库信息
 10.11.6-MariaDB-0+deb12u1 Debian 12
### SQLServer数据库信息
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) 
	Apr  2 2010 15:48:46 
	Copyright (c) Microsoft Corporation
	Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)