What to migrate from MS SQL to? MySQL or PostgreSQL?

P

Pavel2012-03-10 12:42:00

MySQL

Pavel, 2012-03-10 12:42:00

There are about 30 tables in the database. The largest has about 20,000,000 entries.
Now we use HP, but we want to refuse them and store only tables with data in the database.
We refuse in connection with the transition from the Windows platform to Linux (Ubuntu).
What to prefer for migration, MySQL or PostgreSql? What tool to migrate?

Reply

Answer the question

In order to leave comments, you need to log in

7 answer(s)

A

Alexey Ashurok, 2012-03-10
@AotD

Prefer PostgreSql, more goodies and features -> less hemorrhoids with rewriting DBMS-dependent code.

I

Ivan Komarov, 2012-03-10
@FreeTibet

PostgreSQL. In MySQL, you will constantly encounter that there are no chips that you are used to.

M

maratfmu, 2012-03-10
@maratfmu

Why not try MongoDB?

G

gmlexx, 2012-03-10
@gmlexx

First you need to decide for yourself how you see your application in the future. If there will be 20 billion records in a couple of months, and more work with the database, then PostgreSQL.
If the database is needed as a rarely updated warehouse, then MySQL will do. Why fire a cannon at sparrows?

C

codecity, 2012-03-10
@codecity

Compared MySQL and Postgree for speed. There is a huge difference between single-threaded and multi-threaded usage (many connections from about 100 threads).
I am writing the test results from memory (I ran it on a laptop). Time is 1 second. Value - the number of records less than 1 KB (one field and key).
MS SQL: ~700 records per second in both modes.
My SQL: 20 to one, 120 to many.
Postgree: 100 to one, 100 to many. But in multi-threaded, errors were thrown one after another, from which I concluded that it does not work correctly in multi-threaded mode.
In general, I recommend comparing the speed of work, it is not as big as it seems at first glance ... IMHO, this is one of the most important parameters.
I ended up choosing MySQL.

Z

ztxn, 2012-03-14
@ztxn

Pg is a version, its write does not block reading, MS is a blocker. Transaction isolation is implemented quite differently.
A simple example:
ms, executing the query insert into table (value) select max(value) +1 from table, in read commited will not allow duplicate values when inserted by several sessions, and in PG it is easy.
In this context, it may be much easier to migrate to MySQL. He is also a blocker.