Download the PHP package jumper423/migration-mysql-to-postgresql without Composer
On this page you can find all versions of the php package jumper423/migration-mysql-to-postgresql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download jumper423/migration-mysql-to-postgresql
More information about jumper423/migration-mysql-to-postgresql
Files in jumper423/migration-mysql-to-postgresql
Package migration-mysql-to-postgresql
Short Description Миграция из Mysql в PostgreSql
License Apache License 2.0
Homepage https://github.com/jumper423/migration-mysql-to-postgresql
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package migration-mysql-to-postgresql
FromMySqlToPostgreSql - the database migration tool.
WHAT IS IT ALL ABOUT?
FromMySqlToPostgreSql is a tool, intended to make a process of migration from MySql to PostgreSql as easy and smooth as possible.
Important update!
Recently I've developed NMIG, a database migration app, written in Node.js, and highly inspired by FromMySqlToPostgreSql.
NMIG has a few important functional enhancements.
Due to Node.js asynchronous nature, NMIG executes a part of its tasks in parallel, what makes it up to 3 times faster than FromMySqlToPostgreSql. Visit https://github.com/AnatolyUss/nmig.
However, if you're not into Node.js, you can still use old and proven FromMySqlToPostgreSql.
KEY FEATURES
- Ease of use - the only thing needed to run this script is the PHP(CLI) interpreter.
- Accuracy of migration the database structure - FromMySqlToPostgreSql converts MySql data types to corresponding PostgreSql data types, creates constraints, indexes, primary and foreign keys exactly as they were before migration.
- Ability to migrate big databases - in order to reduce RAM consumption
FromMySqlToPostgreSql will split each table's data into several chunks.
The chunk size can be adjusted easily via configuration file. - Speed of data transfer - in order to migrate data fast
FromMySqlToPostgreSql uses PostgreSQL COPY protocol.
Note: migration of tables, containing "varbinary" or "blob" columns may be considerably slower. - Ease of monitoring - FromMySqlToPostgreSql will provide detailed output about every step, it takes during the execution.
- Ease of configuration - all the parameters required for migration should be put in one single file, which can be in either "xml" or "json" format.
- Ability to transfer only a data (in case of an existing database).
SYSTEM REQUIREMENTS
- PHP (CLI) 5.4 or above
- PDO_MYSQL should be installed and enabled
- PDO_PGSQL should be installed and enabled
- mbstring should be installed and enabled
- register_argc_argv should be enabled (check php.ini).
USAGE
1. Create a new database.
Sample:CREATE DATABASE my_postgresql_database;
2. Download FromMySqlToPostgreSql package and put it on the machine running
your PostgreSql.
Sample: /path/to/FromMySqlToPostgreSql
3. Create configuration
4. Run the script from a terminal.
Sample:
php index.php
5. At the end of migration check log files, if necessary.
Log files will be located in "logs_directory" folder in the root of the package.
Note: "logs_directory" will be created during script execution.
6. In case of any remarks, misunderstandings or errors during migration,
please feel free to email me
[email protected]
VERSION
Current version is 1.4.0
(major version . improvements . bug fixes)
TEST
Tested using MySql Community Server (5.6.21) and PostgreSql (9.3).
The entire process of migration 59.6 MB database (49 tables, 570750 rows),
which includes data types mapping, creation of tables, constraints, indexes,
PKs, FKs, migration of data, garbage-collection and analyzing the newly created
PostgreSql database took 3 minutes 6 seconds.
Tested using MySql Community Server (5.6.21) and PostgreSql (9.4).
The entire process of migration 3.1 GB database (56 tables, 8732967 rows),
with the same steps as above, took 2 hours and 10 minutes.
REMARKS
Errors/Exceptions are not passed silently.
Any error will be immediately written into the error log file.
ACKNOWLEDGEMENTS
Big thanks to all contributors for their valuable remarks!
