# 虚谷数据库数据迁移

> |

- **Type:** Skill
- **Install:** `agentstack add skill-kourou25-xugudb-dev-skills-xugudb-migration`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [kourou25](https://agentstack.voostack.com/s/kourou25)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** Apache-2.0
- **Upstream author:** [kourou25](https://github.com/kourou25)
- **Source:** https://github.com/kourou25/xugudb-dev-skills/tree/master/skills/xugudb-migration

## Install

```sh
agentstack add skill-kourou25-xugudb-dev-skills-xugudb-migration
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 虚谷数据库数据迁移

虚谷数据库支持多种数据迁移方式，覆盖静态迁移、对象复制和在线迁移场景。

## 静态数据迁移

将静态数据源一次性迁移到虚谷数据库，适用于历史表、归档表、旧版本数据等场景。

支持的数据源类型：
- **TXT 文件** — 通过 XGConsole 的 `sqlldr` / `tabldr` 命令导入
- **CSV 文件** — 启用 `csv_deal=true` 参数导入
- **SQL 文件** — 通过 `execfile` 命令执行
- **虚谷备份文件** — 物理备份（全量/增量）、逻辑备份（库/用户/模式/表级）
- **虚谷实例目录** — 直接复制部署目录（单机/集群）
- **数据库** — 同构（虚谷）或异构（Oracle/PostgreSQL/MySQL）通过中间格式迁移

> 详细参考：[static-migration](skills/xugudb-migration/references/static-migration.md)

## 对象数据复制

在同一数据库内复制表结构和数据，适用于数据重组、环境复制、数据归档等场景。

| 方式 | 语法 | 说明 |
|------|------|------|
| 创建并复制 | `CREATE TABLE ... AS SELECT` | 同时复制结构和数据，支持临时表 |
| 插入/替换复制 | `INSERT/REPLACE INTO ... SELECT` | 向已有表插入或替换数据 |
| 流式复制 | `IMPORT [APPEND\|REPLACE] TABLE ... FROM SELECT` | 大数据量高性能导入 |

> 详细参考：[object-replication](skills/xugudb-migration/references/object-replication.md)

## 在线数据迁移

在线数据迁移工具暂未正式发布。如需获取试用版，请通过虚谷官方渠道联系。

## 参考文档

- [静态数据迁移](skills/xugudb-migration/references/static-migration.md) — TXT/CSV/SQL/备份文件/实例目录/数据库迁移
- [对象数据复制](skills/xugudb-migration/references/object-replication.md) — CREATE AS SELECT / INSERT INTO SELECT / IMPORT SELECT

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [kourou25](https://github.com/kourou25)
- **Source:** [kourou25/xugudb-dev-skills](https://github.com/kourou25/xugudb-dev-skills)
- **License:** Apache-2.0

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** yes
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-kourou25-xugudb-dev-skills-xugudb-migration
- Seller: https://agentstack.voostack.com/s/kourou25
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.