Thread: Trying to find a low-cost program for Data migration and ETL
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. Basically we are just starting up the database after dealing with Excel: we had a size problem… So im trying to find a program that will allow us to do two different things: the migration of our data from the old system to the new one and a specialized software to perform ETL (Extract, transform and load) on our database. 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? Thanks for your help. -- View this message in context: http://www.nabble.com/Trying-to-find-a-low-cost-program-for-Data-migration-and-ETL-tp24375920p24375920.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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
On Tue, Jul 7, 2009 at 11:48 AM, Rstat <tom.ruster@gmail.com> 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. Basically we are just starting up the database after dealing
with Excel: we had a size problem… So im trying to find a program that will
allow us to do two different things: the migration of our data from the old
system to the new one and a specialized software to perform ETL (Extract,
transform and load) on our database.
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?
Thanks for your help.
You may have some luck by viewing a similar thread on another mailing list:
-- Scott
On Tue, Jul 7, 2009 at 1:26 PM, Scott Mead <scott.lists@enterprisedb.com> wrote:
You may have some luck by viewing a similar thread on another mailing list:
That being said, I would highly recommend using:
As a tool to help in Migrations. Also, a quick google for ETL Mysql or ETL Postgres shows many different companies (both software and consulting) that have the ability to quickly and easily build you a solution.
--Scott
How about using an open source ETL tool? You could go with Talend Open Studio, it is an open source program to do data migration, ETL and data synchronization. Check the site: http://www.talend.com/ Scott Mead-3 wrote: > > On Tue, Jul 7, 2009 at 11:48 AM, Rstat <tom.ruster@gmail.com> 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. Basically we are just starting up the database after >> dealing >> with Excel: we had a size problem… So im trying to find a program that >> will >> allow us to do two different things: the migration of our data from the >> old >> system to the new one and a specialized software to perform ETL (Extract, >> transform and load) on our database. >> >> 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? >> >> Thanks for your help. > > > You may have some luck by viewing a similar thread on another mailing > list: > > http://www.theserverside.net/discussions/thread.tss?thread_id=54755 > > > -- Scott > > -- View this message in context: http://www.nabble.com/Trying-to-find-a-low-cost-program-for-Data-migration-and-ETL-tp24375920p24407304.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.