Exporting to Oracle

[ent1701e]

Hi,

I have some data in a FMP database that I want to transfer to an Oracle database. How would I go about doing it? I am using FMP 5.0, I heard that 5.5 has ODBC connections but I think 5.0 has it too... How would I set up this connection so that I can move the data? Thanks...

[Fitch]

Oracle? If this is just a one-shot deal, it's probably overkill to set up ODBC. Just export text or dbf or sylk or whatever format Oracle prefers, and import that.

[bbaliner]

It's 'should be' easy to set up ODBC. Simply enable Remote or Local Data Access Companion in Preferences. File Maker even has "File Maker Oracle 8 Driver" which could be applicable to your situation.

Remember, though, that FM supports only Level1 OBDC, which I think means most basic SQL statements. Others may correct me on that.