Rstat wrote:
Hi, Im building a database for my company. We are a rather small size book
company with a lot of references and still growing.
We have a Mysql database here and are trying to find some good tools to use
it at its best.
You do realise this is a PostgreSQL mailing list? You'll find more
experience re: this question on a MySQL list/forum.
About the price of the tools, if we were one year ago, the accounting
department would have been pretty relaxed about this. But today, we have
some budget restrictions and therefore need a low cost tool. So could you
give me some advice on a good data migration and etl tool for a low cost?
1. You don't mention what limitations you've hit with mysqladmin etc.
2. If you have copy of MS-Access you could use that as a staging point.
That plus some ODBC drivers would be a simple way of going forward. You
might even want to replace your Excel spreadsheets with Access and just
stop there for a bit.
3. Google is your friend. The results for "mysql etl tools" should give
you a list on MySQL's site as the second hit.
Best of luck!
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
