# taos-migration

**Repository Path**: finsiot-dev/taos-migration

## Basic Information

- **Project Name**: taos-migration
- **Description**: 基于TDEngine V3.X版本库之间迁移使用
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-03-07
- **Last Updated**: 2024-04-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

TDEngine Migration


基于TDEngine V3.X版本库之间迁移使用（由jdbc驱动决定兼容性问题）

子表与超级表的关系是：  主表tag字段中一个device_id是主表名称拼接上"_"+"<device_id>"，举例：
```roomsql
CREATE STABLE `device_log_o402` (`ts` TIMESTAMP, `id` NCHAR(256), `type` NCHAR(256), `content` NCHAR(2048), `messageId` NCHAR(256), `createTime` TIMESTAMP, `timestamp` TIMESTAMP, `productId` NCHAR(256), `productName` NCHAR(256), `deviceName` NCHAR(256), `orgId` NCHAR(256), `orgName` NCHAR(256), `regionId` NCHAR(256), `regionName` NCHAR(256), `system` NCHAR(256)) TAGS (`location` NCHAR(64), `server` NCHAR(64), `deviceId` NCHAR(64), `tag` NCHAR(64));
CREATE TABLE `device_log_o402_156802050232` USING `device_log_o402` (`location`, `server`, `deviceId`, `tag`) TAGS ("default", "default", "156802050232", "default");
CREATE TABLE `device_log_o402_156802050231` USING `device_log_o402` (`location`, `server`, `deviceId`, `tag`) TAGS ("default", "default", "156802050231", "default");
```


工具使用
jar