SQLTransmutate - Converts one database to another using SQLAlchemy

  •        0

SQLTransmutate helps to converts one database to another using SQLAlchemy. It inspects a database, creates the same schema in another database with another engine, then copies over all the data. It has no knowledge whatsoever of which databases it's moving from and to. Whatever SQLAlchemy can handle, this script can handle. Currently it supports MySQL and PostgreSQL.

https://github.com/j0057/sqltransmutate

Tags
Implementation
License
Platform

   




Related Projects

SQL Workbench - DBMS-independent SQL query tool


SQL Workbench is a DBMS-independent, cross-platform SQL query tool. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. It could compare the data of two database and generate the necessary SQL statements to migrate one to the other.

Adminer - Database Management in Single PHP file


Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch and MongoDB

MySQL Workbench - Visual database design tool for MySQL


MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

Orbada - Database manager


ORBADA is a database, SQL, query client using JDBC drivers. It is a tool to administrate and manage database structure. It Is for Oracle, SQLite, Firebird, HSQLDB, DerbyDB, MySQL and other databases.

Eclipse SQL Explorer - SQL client


Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases. It is available as standalone client as well as Eclipse plugin.

Slony-I - Replication System for PostgreSQL


Slony-I is a "master to multiple slaves" replication system with cascading and failover. Slony-I is a system designed for use at data centers and backup sites, where the normal mode of operation is that all nodes are available.

HammerDB


HammerDB (formerly Hammerora) is an open source load testing tool for Oracle, SQL Server, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL and Redis Databases

JSqlTool


JSqlTool is a swing based application used to view/edit database tables content and to execute sql scripts, by connecting to a database using JDBC/ODBC. It'a a multilanguage application, tested on Oracle, SQLServer, MySQL, DB2 and many other databases.

VoltDB - Fast Scalable SQL DBMS with ACID


VoltDB was specifically designed for contemporary software applications that are pushed beyond their limits by high volume data sources. VoltDB provides the ability to capture, store and process incoming data at millions of read/write operations per second. And VoltDB’s relational model opens that data to be analyzed in real-time, using familiar Business Intelligence tools, to identify data patterns and trends, spot anomalies, or perform tracking and alerting.

Clam AntiVirus


Clam AntiVirus is an anti-virus toolkit for UNIX, designed especially for e-mail scanning on mail gateways. It provides a number of utilities including a flexible and scalable multi-threaded daemon, a command line scanner and advanced tool for automatic database updates.