How To Export/Import To Any Database
Why don't you subscribe to my blog while you're here? I'm a freelance web developer and I blog about Ruby, Rails, and business online.
Go ahead and subscribe to my RSS feed. Thanks for visiting!
Occasionally I need to transfer my data from one database product to another, and it’s always a real pain. There’s a few commercial packages available but my budget doesn’t really permit that. Anyway, I finally found a free and easy way to transfer tables from one database to another database, of almost any type.
Install Squirrel SQL which is a SQL client written in Java. Then, grab the DBCopy Plugin and install it according to their instructions. After installing DBCopy simply open up the two databases and copy then paste tables using the right click menu. Too easy!
Please note that you will need to install the appropriate JDBC driver for your databases, and then tell Squirrel SQL where it can find them. Here’s links to the JDBC drivers for the more popular databases:
