Skip to main content

Database migration from MySQL to PostgreSQL

Information Technology Blog - - Database migration from MySQL to PostgreSQL - Information Technology Blog

MySQL and PostgreSQL are both very popular open source RDBMS having rich set of administration tools and programming APIs.

PostgreSQL Advantages

PostgreSQL, however, has multiple important advantages over MySQL:

  • it is fully complied with ANSI SQL standard
  • supports several models of indexing
  • provides asynchronous commit
  • supports both synchronous and asynchronous replication

That is why many businesses and organizations consider migrating their databases from MySQL to Postgres.

In general, database migration consists of the following steps:

  • Extract table definitions from the source database in form of DDL SQL statements
  • Convert these statements into the destination format and load into the target database
  • Export data from the source database into an intermediate storage (for example, csv files)
  • Transform the data according to the destination format and load it into Postgres database
  • Extract views, stored procedures and triggers from MySQL database in form of SQL statements and source code
  • Convert these statements and source code into the destination format and load into PostgreSQL database

Obviously, the procedure of migrating database from MySQL to Postgres requires many efforts when doing it manually. In addition, there is high risk of data loss or corruption due to the human factor. It would be wise to use special software to automate the conversion process.

PostgreSQL Converters

One of such conversion tools is MySQL to PostgreSQL developed by Intelligent Converters. Intelligent Converters is a software vendor specializing in solutions for database conversion, migration and synchronization since 2001. Their MySQL to Postgres converter has extremely high performance due to direct reading and writing data without any middleware libraries or components. It supports all versions of MySQL and PostgreSQL including cloud solutions. The product provides command line version in order to automate and to schedule database conversion. MySQL to PostgreSQL converter allows not only migrate MySQL data into new database but also merge or synchronize it with existing PostgreSQL database.

postgresql 300x247 - Database migration from MySQL to PostgreSQL postgresql2 300x247 - Database migration from MySQL to PostgreSQL

Do you need to migrate only certain records to the destination database? No problem, the tool allows to filter data via SELECT queries. With this option, it is possible to select particular columns and records or even transform the data before converting it into PostgreSQL format. Here is a few examples of using this feature for different purposes.

  • Filtering records: SELECT * FROM TheTable WHERE IdColumn < 300
  • Select and rename individual columns: SELECT col1 AS LastName, col2 as CellPhone FROM TheTable
  • Skip NULL values: SELECT * FROM TheTable WHERE Details IS NOT NULL

Sometimes it is necessary to change column type in the resulting database. For this purpose MySQL to PostgreSQL converter provides feature called “custom column mapping”. It is a dialog window that allows to change name, type, default value and NULL-attribute for any column of table as well as exclude certain columns from conversion.

If the target PostgreSQL server does not allow remote connection, the program provides option to export the data into SQL script. In this approach source database is exported into local file containing SQL-statements to create tables with all indexes and constraints and fill them with the data. Then database administrator can import the script file to PostgreSQL server the standard tools like psql or phpPgAdmin.

Visit the official product page for more information:

MySQL to PostgreSQL Converter

Originally posted 2016-11-17 19:49:21. Republished by Blog Post Promoter

The post Database migration from MySQL to PostgreSQL appeared first on Information Technology Blog.



Udimi - Buy Solo Ads from Information Technology Blog https://ift.tt/3l4gvZQ
via IFTTT
Labels:

Comments

Post a Comment

Popular posts from this blog

9 VCs in Madrid and Barcelona discuss the COVID-19 era and look to the future

Spain’s startup ecosystem has two main hubs: Madrid and Barcelona. Most observers place Barcelona first and Madrid second, but the gap appears to close every year. Barcelona has benefitted from attracting expats in search of sun, beach and lifestyle who tend to produce more internationally minded startups. Madrid’s startups have predominantly been Spain or Latin America-focused, but have become increasingly international in nature. Although not part of this survey, we expect Valencia to join next year, as city authorities have been going all-out to attract entrepreneurs and investors. The overall Spanish ecosystem is generally less mature than those in the U.K., France, Sweden and Germany, but it has been improving at a fast clip. More recently, entrepreneurs in Spain have moved away from emulating success in pursuit of innovative technologies. Following the financial crisis, the Spanish government supported the creation of startups with the launch of FOND-ICO GLOBAL, a €1.5 billi...
Post a Comment
Read more

Emulating USB Dongle – Introducing HASP Dongle Emulator Software

Information Technology Blog - - Emulating USB Dongle – Introducing HASP Dongle Emulator Software - Information Technology Blog Over the years the methods used by software developers and producers to limit the amount of users to a specific number in a licensing agreement have become more complex.  The aim of copy protection is to protect the intellectual rights and financial investment of the individual developers and manufacturing companies.   A way of getting around this protection is to reproduce the media through which you can deliver the application to other users,  meaning that the software can be replicated far in excess of that specified in the license. One of the most common methods has been to use hardware keys or dongles which will enable the user to activate an application, unlocking its full functionality without using a device.  In addition, it offers good protection against attempts to pirate the software. In this article, we will look at th...
1 comment
Read more

Advantages and Disadvantages of using Vouchers in eCommerce

Information Technology Blog - - Advantages and Disadvantages of using Vouchers in eCommerce - Information Technology Blog To decide whether vouchers and coupons are the right tool to add to your online marketing strategy, it is essential that you consider the benefit and the cost of using coupons. In this article, we will use Gtech coupon marketing strategy as an example a successful coupon strategy.  Also check out these great books on coupon codes for ecommerce . Advantages of Using Coupons Increase Sales This is the obvious benefit. Coupons serve to increase sales especially for high ticket items such as luxury gadgets. Gtech discount codes is a good example as Gtech quality is reflected on the price of both the Gtech eBike and Gtech AirRam. In order to boost sales, the company releases 10% off offers certain times of the year when online sales would normally be low. Enlarge Email List Acquiring a customer can be expensive in terms of advertising and marketing. If yo...
1 comment
Read more