This is a free application I have been working on for a couple of days. I have not done a lot of testing with it yet, but so far it works well. It is all Java, so it should run on Mac, Windows, and Linux
The project homepages is at http://goldcougar83.googlepages.com
FM Escape will generate “CREATE TABLE” and “INSERT INTO” statements from your FileMaker data through my FileMaker XML JDBC Driver. It has a preference tab to completly customize the generate sql to fit any sql database. It also replace all non-alphanumeric characters in fields names with a _ to make them SQL compliant. On the Connection URL, please use the layFilter so that you can direct the driver to 1 layout. Otherwise it goes to the first layout, and uses that for the field list and data.
Below are screenshots and a download link.
Best of all, it is FREE!..and maybe open source at a later point.
CHANGE LOG
10/11/06- Updated zip for windows users, and set new line characters in filemaker to be relaced with a “\n”.
FM_Escape.zip (157 KB)