Migration from mysql to postgresql

shrini

Friends.

I want to migrate from mysql to postgresql.
I have a lot of databases and tables in mysql.
I can export them.

I need your guidance for importing the databases into postgresql.

Thanks.

T.Shrinivasan.

Mar 27 '06 #1

Subscribe Post Reply

1676

noone

shrini wrote:

Friends. I want to migrate from mysql to postgresql.
I have a lot of databases and tables in mysql.
I can export them. I need your guidance for importing the databases into postgresql. Thanks. T.Shrinivasan.

you might try requesting this from a postgresql forum....

try exporting your data in comma-seperated variable format and I am quite
certain that postgresql has a method to import it. (I am NOT a postgresql
expert)

Mar 27 '06 #2

Similar topics

mass migration from mysql?

by: Mike Henley | last post by:

considering the recent changes to the mysql licensing terms, which meant the php5 team had to adopt sqlite instead into the php5 and drop mysql stuff from the standard language distro (as i...

PHP

mysql to pgsqwl migration

by: K. Suresh | last post by:

Hello, I have a database application with Java and PHP clients. I used mysql with 64 tables. Now, we have decided to use pgsql. Please suggest the migration procedure. Thanks. Suresh

PostgreSQL Database

PostgreSQL versus MySQL

by: Joshua D. Drake | last post by:

Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake

PostgreSQL Database

Migration from SQL Server to PostgreSQL

by: Shrikant S Kulkarni | last post by:

Hello All One of our clients is at very initial stage of migration from SQL 2000 to PostgreSQL. It’s not been finalized and some research is going on. Since I am new to PostgreSQL, I don't have...

PostgreSQL Database

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware