How To Export/Import To Any Database

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: Squirrel SQL