Export to SQL

[DonH]

My client bought FM 6 because he heard that we can export data to SQL. Anybody want to confirm or deny this? I went thru the book that came with it and it had nothing. I also went to the export function and I don't see anything about SQL. Maybe I can connect to SQL Server some other way?

Don

[paulmetzger]

I don't think that FMP will generate .sql files (a text file with all the queries needed to create and populate your table), but there ARE a few ways to get the data out.

You can export from FMP to tab delimted, and then create your tables in SQL and import the data. FMP also has some ODBC stuff that should let you directly connect to your database server from within FMP and then do SQL queries. I've never done that, however, and I've heard it's a pain in the ass.

What SQL are you running? (ie, MySQL, MS SQL Server, Oracle, Postgres, etc)

[andygaunt]

Also, look into the Execute SQL script step, found under the miscellaneous functions

[DonH]

I have MSSQL running under SQL Server 2k.

Right now I am doing the export to tab, import to SQL route and the client wanted to speed it up by being able to go directly to SQL.

I found where I can set up an ODBC connection in FM but that is about as far as I have gotten it to go. Haven't been able to connect SQL Server to the tables.

Don

[leenu_n]

Even I am facing similar problems. I have to migrate from FM to SQL Server and I don't know how to do it. I have heard abt using ODBC to access SQL d/b but I am not sure how to go about doing it. Will you still have tables in FM ? What scripts will I have to write to insert or update data in the SQL d/b via FM ?