How to migrate data from mySQL to PostgreSQL?
Let’s learn how to migrate data from mySQL to PostgreSQL. The most accurate or helpful solution is served by Stack Overflow.
There are ten answers to this question.
Best solution
My postgresql is installed on windows, how can I migrate data from mysql db to postgresql. I've read tons of aricles. nothing helps :( Thanks. My actions: 1)mysql dump: mysqldump -h 192.168.0.222 --port 3307 -u root -p --compatible=postgresql synchronizer > c:\dump.sql 2)create db synchronizer at pgsql 3)import dump: psql -h 192.168.0.100 -d synchronizer -U postgres -f C:\dump.sql 4) output: psql:C:/dump.sql:17: NOTICE: table "Db_audit" does not exist, skipping DROP TABLE psql...
Answer:
My experience with MySQL -> Postgresql migration wasn't really pleasant, so I'd have to second Daniel...
Andrew Kalashnikov at Stack Overflow Mark as irrelevant Undo
Other solutions
Answer:
I'd go with PostgreSQL. AFAIK Postgres and Oracle are ANSI SQL compliant making it easy for you to almost...
Nupul Kukreja at Quora Mark as irrelevant Undo
I have a MySQL schema dump. I need to convert it to PostgreSQL. The data is not important right now; I just need to deal with the schema. It actually looks like the easiest way to do this is just to manually find-and-replace all of MySQL's nonstandard...
Answer:
Every time I've heard of someone doing something like this, they end up doing it by hand or else writing...
vogon_poet at Ask.Metafilter.Com Mark as irrelevant Undo
My database is in Oracle 11g. I want to migrate the data to MySQL database. I have made the similar structured tables in my MySQL database. Now I want to push the data from Oracle to MySQL.
Answer:
There are many data integration tools available. It all depends on the scale. How many rows are you...
Alex Buzunov at Quora Mark as irrelevant Undo
Compared to MySQL, PostgreSQL has more features and fewer pitfalls.
Muhammad Wasif at Quora Mark as irrelevant Undo
We are going to launch a video based e-learning program by buying an existing precoded social LMS (not SaaS, but a precoded script that's developed in Java with MongoDB), but our lil tech team has experience in LAMP technology with experience in WordPress...
Answer:
Coursera managed this in October with a then user base of about 1.6 million users and thousands to tens...
Frank Chen at Quora Mark as irrelevant Undo
Context: I am working with MySQL and i know when you run an alter command on MySQL. It internally delete the table and creates a new table by locking the table. 13.1.4 ALTER TABLE Syntax Now: At work we have started using PostgreSQL and Oracle. We are...
Answer:
Alter table to create column in PostgreSQL will not lock a big table. It will take some milliseconds...
VinÃcius Corrêa at Quora Mark as irrelevant Undo
We are building the app using Rails on MySQL but PostgreSQL seems to be the DB of choice on Heroku for Rails apps. What will we miss if we don't stay with MySQL? Our data is mostly text but both writes and reads are expected in high numbers. How are...
Answer:
MySQL handles huge numbers of connections (thousands) more gracefully than Postgres. Note that this...
Jason Dusek at Quora Mark as irrelevant Undo
http://dev.mysql.com/doc/refman/... I have used DRBD as part of a data store for Citrix but I just saw a PostgreSQL data store setup using it. Clearly, a good use for fail-over, but doesn't replication provide the same protection?
Answer:
DRBD is the right tools to just fool yourself. It gives you a false feeling of security in most case...
Jean-Gérard Pailloncy at Quora Mark as irrelevant Undo
We're using Cassandra for data store, but want to migrate data out of Cassandra and into MySQL on a daily basis so that marketing/product users can query data independently using an SQL syntax. Any advice here?
Answer:
For large amounts of Data (stored in Cassandra) you might want to look into using Brisk (for Hive and...
Ben Coverston at Quora Mark as irrelevant Undo
Related Q & A:
- How to completely backup all mysql databases?Best solution by Server Fault
- How to Migrate from SQLite DB to MySQL?Best solution by Stack Overflow
- How to store data in php and get data from php?Best solution by Stack Overflow
- How to migrate from Ubuntu to Fedora?Best solution by Super User
- How to migrate from Australia to France?Best solution by wikihow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.