SQLTransmutate - Converts one database to another using SQLAlchemy

  •        476

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

elastic-db-tools - Elastic database tools client library allows ADO


Elastic database tools client library allows ADO.NET developers to create applications that implement and use the pattern known as database sharding in Azure SQL Database. Learn more at http://azure.microsoft.com/en-us/documentation/learning-paths/sql-database-elastic-scale/ .To get started on contributing, take a look at issues that are up-for-grabs.

Open DBDiff


Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.

DBBalancer - Middleware btw Database client and server


DBBalancer is some sort of middleware that would sit in between of database clients and a server. Currently the only server supported is Postgres, but the architecture is open to embrace more servers in a future. It's a connection pool, a load balancer and a database replicator.

JugglingDB - Multi-database ORM in NodeJS


JugglingDB is cross-db ORM for nodejs, providing common interface to access most popular database formats. Currently supported are: mysql, sqlite3, postgres, mongodb, redis and js-memory-storage (yep, self-written engine for test-usage only). You can add your favorite database adapter, checkout one of the existing adapters to learn how.

php-db-tools - Php mysql database tools and data access object framework.


Php mysql database tools and data access object framework.



DB Script Runner


Utility to run multiple scripts in a specified order against a database. It's developed in VB.net.

SIDU admin GUI : MySQL PostgreSQL SQLite


SIDU is a FREE database web GUI written in PHP. Handy and powerful for MySQL + PostgreSQL + SQLite + CUBRID. SIDU is simple and easy DB tool to use! SIDU has all features you need for database admin and web development. It's a great DB admin tool! No installation need. Best database front-end web based tools, cross platform looking no further

db-backup - Database backup and recovery tools


Database backup and recovery tools

MassDataHandler


The MassDataHandler is a framework to assist with Database Unit Testing. The framework makes it very easy to insert test data into a database, which in turn makes it very easy to write database unit tests. The user merely needs to specify their relevant data in a simple XML f...

Database Synchronization Tool


This tool enables a development team to synchronize their local application databases instances to the central common application database instance using DDL and DML scripts.

mosql - MongoDB to PostgreSQL Streaming Replication


MoSQL imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a MongoDB database, and then run offline analytics or reporting using the full power of SQL.

DB Fit


Please note the project has moved to GitHub, see http://benilovj.github.com/dbfit DbFit is a set of fixtures which enables FIT/FitNesse tests to execute directly against a database, enabling developers to manipulate database objects in a relational form, making database TDD much easier then with xUnit-style tools.

IQ.DbA


IQ.DbA is a light weight database management tool. - Easily browse through your table's data, run queries. - Compare schema / meta data. - Compare & synchronize table data (schema must be the same). - Create, Backup & Restore Db. - View & kill connections. - Added, sync...

DBSourceTools


DBSourceTools is a GUI utility to help developers bring SQL Server databases under source control. A powerful database scripter, code editor, sql generator, and database versioning tool. Compare Schemas, create diff scripts, edit T-SQL with ease. Better than Management Studio.

Chinook Database


Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

Maatkit - Power tools for open-source databases


Maatkit is a toolkit for users, developers, and administrators of open-source databases. Most of Maatkit’s functionality is designed for MySQL. It makes MySQL easier and safer to manage. Maatkit could be used to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much more.

mysql2mongo - MySQL to MongoDB importer


MySQL to MongoDB importer. The scripts are using simple relational to non-relational (r2n) mapping mechanism that should let You automagically convert Your MySQL database into MongoDB set of collections.

kdb - Go (golang) database/sql helpers. Can convert db tables to Go code.


Go (golang) database/sql helpers. Can convert db tables to Go code.

Contextual Database Content Viewer


The Database Content Viewer will help any developer working on a database oriented application. No longer creating complex SQL statements to inspect the complete data hierarchy of an object in the database.

PostGIS - Spatial and Geographic objects for PostgreSQL


PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.