On Sat, 2006-08-12 at 08:08 -0700, RPK wrote: > How can I migrate a PostgreSQL database to MySQL or MS Access? Are there any > tools available? Although migrating away from PostgreSQL is not a popular idea on this list, it can be done. If you're using any PostgreSQL-specific features, plan how you want those things to work in MySQL/MSAccess. For everything else, just export the tables from PostgreSQL using PgAdminIII (www.pgadmin.org), phpPgAdmin, or just COPY ( http://www.postgresql.org/docs/8.1/static/sql-copy.html ). Then import them into MySQL/MSAccess. You may need to make some simple changes, like changing the data type of a column. Also consider writing some quick scripts using JDBC or ODBC to move data. Consider whether that's really what you want to do. PostgreSQL can most likely be run in your environment (it runs on windows, linux, and many other operating systems). Also, it most likely has far more capability to do what you want than either MSAccess or MySQL. You can connect to PostgreSQL with ODBC or JDBC and almost all languages have a PostgreSQL module in addition to ODBC/JDBC. It is probably worth your time to ask a few questions on this list to determine how PostgreSQL can work better for you. Regards, Jeff Davis
