By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,888 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Converting MySql database to Postgree

P: n/a
Can someone please provide me an easy and effective way to convert
MySql database (with data included) to new Postgree database?

Thanks,

Konrad
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Konrad wrote:
Can someone please provide me an easy and effective way to convert
MySql database (with data included) to new Postgree database?


You might get better helped in the relevant newsgroup(s) :-)

--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\

Nov 13 '05 #2

P: n/a


Actually I've forgotten that conversion from Ms Access is also one that
I'd like know, so is the place getting a bit relevant now??

Sorry for that mistake. Next time I'll try to be more careful ;).

Greetings

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

P: n/a
In message <41**********************@news.newsgroups.ws>, Konrad Sz
<ko***@eranet.pl> writes


Actually I've forgotten that conversion from Ms Access is also one that
I'd like know, so is the place getting a bit relevant now??

Sorry for that mistake. Next time I'll try to be more careful ;).


Moving data from one back-end database to another is relatively simple.
Create a new database and new tables with the right fields. Use ODBC to
create linked tables in Access then use append queries to append data
from the old table to the new one.

That might not be the most efficient way of moving data across but it is
probably the simplest.

If you have forms or reports in Access you can continue to use those,
they can use the data stored in MySQL or PostgreSQL databases.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #4

P: n/a
Konrad Sz wrote:

Actually I've forgotten that conversion from Ms Access is also one that
I'd like know, so is the place getting a bit relevant now??

Sorry for that mistake. Next time I'll try to be more careful ;).


I wasn't trying to play net cop, just that you get more MySQL experts in
a MySQL newsgroup than in an Access one :-)
--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.