All Projects → wentaojin → transferdb

wentaojin / transferdb

Licence: Apache-2.0 license
TransferDB 支持异构数据库 schema 转换、全量数据导出导入以及增量数据同步功能( Oracle 数据库 -> MySQL/TiDB 数据库)

Programming Languages

go
31211 projects - #10 most used programming language
HTML
75241 projects
PLSQL
303 projects

Projects that are alternatives of or similar to transferdb

awesome-csv
Awesome Comma-Separated Values (CSV) - What's Next? - Frequently Asked Questions (F.A.Q.s) - Libraries & Tools
Stars: ✭ 46 (+53.33%)
Mutual labels:  schema, csv
data-models
Collection of various biomedical data models in parseable formats.
Stars: ✭ 23 (-23.33%)
Mutual labels:  schema, csv
Dbwebapi
(Migrated from CodePlex) DbWebApi is a .Net library that implement an entirely generic Web API (RESTful) for HTTP clients to call database (Oracle & SQL Server) stored procedures or functions in a managed way out-of-the-box without any configuration or coding.
Stars: ✭ 84 (+180%)
Mutual labels:  csv, oracle
Csv2db
The CSV to database command line loader
Stars: ✭ 102 (+240%)
Mutual labels:  csv, oracle
Omniparser
omniparser: a native Golang ETL streaming parser and transform library for CSV, JSON, XML, EDI, text, etc.
Stars: ✭ 148 (+393.33%)
Mutual labels:  schema, csv
Pyetl
python ETL framework
Stars: ✭ 33 (+10%)
Mutual labels:  csv, oracle
Dumpling
Dumpling is a fast, easy-to-use tool written by Go for dumping data from the database(MySQL, TiDB...) to local/cloud(S3, GCP...) in multifarious formats(SQL, CSV...).
Stars: ✭ 134 (+346.67%)
Mutual labels:  csv, tidb
Apijson
🚀 零代码、热更新、全自动 ORM 库,后端接口和文档零代码,前端(客户端) 定制返回 JSON 的数据和结构。 🚀 A JSON Transmission Protocol and an ORM Library for automatically providing APIs and Docs.
Stars: ✭ 12,559 (+41763.33%)
Mutual labels:  oracle, tidb
Specs
Technical specifications and guidelines for implementing Frictionless Data.
Stars: ✭ 403 (+1243.33%)
Mutual labels:  schema, csv
Flatfiles
Reads and writes CSV, fixed-length and other flat file formats with a focus on schema definition, configuration and speed.
Stars: ✭ 275 (+816.67%)
Mutual labels:  schema, csv
DataAnalyzer.app
✨🚀 DataAnalyzer.app - Convert JSON/CSV to Typed Data Interfaces - Automatically!
Stars: ✭ 23 (-23.33%)
Mutual labels:  schema, csv
exodus
Migration tools for Tabular Data to Oracle JSON/Tabular Data
Stars: ✭ 19 (-36.67%)
Mutual labels:  schema, oracle
E Commerce Db
Database schema for e-commerce (webstores) sites.
Stars: ✭ 245 (+716.67%)
Mutual labels:  schema, oracle
linkifier
Database reverse engineering
Stars: ✭ 32 (+6.67%)
Mutual labels:  schema, oracle
SyncUtil
Sync Utilities For UNET
Stars: ✭ 38 (+26.67%)
Mutual labels:  sync
idataapi-transform
Full async support toolkit for IDataAPI for efficiency work, read data from API/ES/csv/xlsx/json/redis/mysql/mongo/kafka, write to ES/csv/xlsx/json/redis/mysql/mongo/kafka, provide CLI and python API
Stars: ✭ 36 (+20%)
Mutual labels:  csv
txbox
Elixir Bitcoin transaction storage schema, built on Ecto.
Stars: ✭ 14 (-53.33%)
Mutual labels:  schema
avro ex
An Avro Library that emphasizes testability and ease of use.
Stars: ✭ 47 (+56.67%)
Mutual labels:  schema
PECI-Java-MAR-2015
Repositorio del curso de Java de Mar 2015
Stars: ✭ 29 (-3.33%)
Mutual labels:  oracle
csv2xls
Put together some CSV files into a single Excel file, in different sheets.
Stars: ✭ 14 (-53.33%)
Mutual labels:  csv

TransferDB

TransferDB 定位于异构数据库 ORACLE -> MYSQL/TiDB 对象信息收集、表结构映射、表结构对比、数据同步等功能一体化工具

Features

  • ORACLE 数据库表结构定义转换,支持库、表、列级别以及默认值自定义
  • ORACLE 数据库表索引、非空约束、外键约束、检查约束、主键约束、唯一约束转换
  • ORACLE、MySQL/TiDB 数据库表结构对比
  • ORACLE 数据库对象信息收集
  • ORACLE 数据库全量/CSV 数据迁移
  • ORACLE 数据库实时同步【实验性】
  • ORACLE、MySQL/TiDB 数据校验

Quick Start

请参考 使用手册

Development

信息收集 make gather

表结构转换 make prepare / make reverse

表结构核对 make check

全量数据迁移 make full

数据实时同步 make all

CSV 数据导出 make csv

数据校验 make diff

程序编译 make build

License

This software is free to use under the Apache License.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].