Computing.Net > Forums > Programming > Convert File Maker to SQL Database

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Convert File Maker to SQL Database

Reply to Message Icon

Name: dlublink
Date: December 27, 2003 at 11:56:36 Pacific
OS: NA
CPU/Ram: NA
Comment:

Hi.

I have a a 200 megabyte FileMaker Database that I need to convert to SQL so that it can be used on a PHP website. It contains some graphics (which is part of why it is soo big.) Is there any quick way to convert it to SQL without having to pay FileMaker for their program?

Also It would be nice if I could extract the graphics and have the file name be the primary key from the field they were pulled from.

David



Sponsored Link
Ads by Google

Response Number 1
Name: anonproxy
Date: December 27, 2003 at 21:45:03 Pacific
Reply:

FileMaker has an ODBC interface, correct? Use a script (maybe in PHP) to pull the data from FileMaker and dump it into the other database. Example here. Write your SQL queries and wrap your script code around them.

"extract the graphics and have the file name be the primary key from the field they were pulled from."

Do this while you are transfering the data or after. I suppose it would be more straightforward to alter the data after you have made the conversion.

It's usually best to simply use the vendor software for this task unless you have a good idea of what you are doing. In the end buying the software may actually save you time, hence money.



0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Convert File Maker to SQL Database

Connecting to sql database code www.computing.net/answers/programming/connecting-to-sql-database-code/14462.html

converting Visual Foxpro to SQL? www.computing.net/answers/programming/converting-visual-foxpro-to-sql/3468.html

import files to SQL server www.computing.net/answers/programming/import-files-to-sql-server/10825.html