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:
Tags: derby, hsql, mysql, oracle, postgresql, sqlite, sqlserver, squirrel-sql
February 3rd, 2007 at 1:53 pm
Now the DBCopy plugin comes with the installer since 2.3. So just select it when you get to the optional plugins panel in the installer and it will be installed. If you aren’t into installers, then get the optional plain zip archive.
Rob
February 8th, 2007 at 3:41 am
[...] Original post by Alex Pooley’s Blog and software by Elliott Back Share and Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages. [...]