This project provides a Rust-based solution for migrating MSSQL databases to MySQL.

Bitalizer

Last update: Jul 10, 2023

Related tags

Database db-migrator

Overview

MSSQL to MySQL Database Migration

A Rust project to migrate MSSQL databases to MySQL, including table structures, column data types, and table data rows.

Features

Connects to MSSQL and MySQL databases to perform the migration.
Converts MSSQL table structures and column data types to their corresponding MySQL equivalents.
Transfers table data rows from MSSQL to MySQL.
Provides flexibility in configuring connection details, table mappings, and migration options.
Handles differences in data types, constraints, and other database-specific details during the migration process.

Dependencies

tokio - Asynchronous runtime for Rust.
tokio-util - Utilities for working with Tokio.
chrono - Date and time library for Rust.
toml - TOML parsing and serialization library for Rust.
tiberius - MSSQL database driver for Rust.
sqlx - Database toolkit for Rust, including support for MySQL.

Usage

Copy the config.example.toml file to config.toml.
Configure the connection details and whitelisted tables for the MSSQL and MySQL databases in the config.toml file.
Customize the table mappings and migration options in the mappings.toml file.
Build and run the migration tool using Cargo:

cargo run --release

Installation

Make sure you have Rust installed. You can install Rust from the official website: https://www.rust-lang.org/tools/install

Clone the repository:

git clone https://github.com/bitalizer/db-migrator.git

A highly scalable MySQL Proxy framework written in Rust

mysql-proxy-rs An implementation of a MySQL proxy server built on top of tokio-core. Overview This crate provides a MySQL proxy server that you can ex

175 Dec 19, 2022

Mysql client library implemented in rust.

mysql This crate offers: MySql database driver in pure rust; connection pool. Features: macOS, Windows and Linux support; TLS support via nativetls cr

548 Dec 31, 2022

A user crud written in Rust, designed to connect to a MySQL database with full integration test coverage.

SQLX User CRUD Purpose This application demonstrates the how to implement a common design for CRUDs in, potentially, a system of microservices. The de

78 Nov 27, 2022

cogo rust coroutine database driver (Mysql,Postgres,Sqlite)

cdbc Coroutine Database driver Connectivity.based on cogo High concurrency，based on coroutine No Future'q,Output=*，No async fn, No .await , no Poll*

10 Nov 13, 2022

rust-mysql-simple support library for the r2d2 connection pool

r2d2-mysql rust-mysql-simple support library for the r2d2 connection pool.

44 Nov 1, 2022

A tool for automated migrations for PostgreSQL, SQLite and MySQL.

Models Models is an implementation for a SQL migration management tool. It supports PostgreSQL, MySQL, and SQLite. Quick Start install the CLI by runn

45 Nov 16, 2022

CRUD example with Rocket, Toql and MySQL

Todo (Rocket, Toql, MySQL) This is a little REST server built with Rocket, Toql and MySQL. The server allows to call CRUD functions on a Todo item. It

7 Jan 5, 2022

Gibbs MySQL Spyglass

Gibbs MySQL Spyglass Ahoy Matey! The Gibbs MySQL Spyglass is a application used to capture application traffic into a MySQL database. It is designed t

82 Nov 14, 2021

fast & easy CLI and vscode extension specialized to format MySQL INSERT queries.

insertfmt fast & easy CLI specialized to format MySQL INSERT queries. format queries so that they look like a table. NOTE: If you wanna use the VSCode

7 May 2, 2023

Comments

Hide details behind --verbose flag

Only display verbose details such as executed queries and created table definitions when the --verbose flag is active. If this flag is not present, the program should only present a high-level overview of its progress. This overview will allow users to quickly identify the program's version and any warnings, making clear which tables are processed.

opened by henno 0
Helpful hints for users to speed up INSERT queries in MySQL
When starting, the program should:

check the 'max_allowed_packet' value set on the MySQL server. If this value is less than 16777217 (default is 16777216 or 16MB), it should show a yellow warning message that "The MySQL max_allowed_packet value is {} MB. If you have more than 1.6GB of RAM, this is not optimal because it should be between 1% of your total RAM and 1GB".

check the 'innodb_buffer_pool_size' value set on the MySQL server. If this value is less than 134217729 (default is 134217728 which is 128MB), it should show a yellow warning message that "The MySQL max_allowed_packet value is {} MB which is not optimal because it should be 50-75% of total RAM in case of a dedicated MySQL server".
opened by henno 0
Releases

It would be good if people could just download the binary without having to install Rust and Cargo on their machines to use the program.

The binary should diplay its release version number when it is executed.

opened by henno 0
Show header with program's metadata

It would be good if the program showed a header every time it runs where one can see a link to this github page, so that when a person who does not know what program this is runs the executable, he can refer to this Github project page to read the README

opened by henno 0