B
B
BonBon Slick2017-04-13 17:30:11
MySQL
BonBon Slick, 2017-04-13 17:30:11

Migrating site from Mysql to PostgreSQL?

The site is written in Laravel, the database is sooo big. So they asked me to move. I will be given a copy of the site with PhpPgAdmin installed. I will mostly deal with the transfer of data, tables, correction and optimization of database queries. Worked with both DBMS.
I'm already looking forward to how much byak there will be)) The
question is mainly addressed to those who have already done this, who endured it.
Please tell me what difficulties may arise and what to expect, how does this entire transfer process go?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
F
Falseclock, 2017-04-13
@BonBonSlick

There is no need to invent anything .. everything is already there
https://wiki.postgresql.org/wiki/Converting_from_o...

V
Vovanys, 2017-04-13
@Vovanys

Navicat can transfer from one database to another
. Just need to correct auto-increments for sequences

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question