dump FMP
go to mysql

You might think about normalizing
bite the bullet and redevelop your tafs. You're smarter than when you created them. they will be simpler

(if you name your tables and fields the same, you have a chance of selecting all your data sources in a taf and changing them to a new one, but you have to be very careful)


get a simple admin tool to manage mysql (Navicat, sql4x manager j)
You'll have to stumble through the odbc and/or jdbc thing. 

there are many helpful people on this list.


On Sep 30, 2005, at 2:28 PM, [EMAIL PROTECTED] wrote:

Chaps


I'm just about to convert my Tango 3.5 TAFs (WebSTAR 4.5, OS 9.1, Filemaker 4) to 5.5 Lite running on OS X 10.3.9 and then 10.4.2 with Apache

I was planning to use Filemaker 6 or Filemaker 8 but obviously have the option of MySQL as well. I have 20 Filemaker databases, all very simple, that could, in theory, be moved over to MySQL to dump Filemaker altogether

From a cursory inspection of 5.5 Lite it looks as though direct connections to Filemaker are out and I need to use OBDC or something. In some ways I'd like dump Filemaker completely and jump to MySQL to avoid dealing with Filemaker and ODBC but some of my complex TAFs (there are about 50 of them) have thousands of references back to Filemaker fields and even with careful Search & Replace I would be in for some serious debugging afterwards 

So, to my questions:

- Jump straight to MySQL?
- setup Filemaker, figure out that ODBC thang and migrate gently to MySQL?
- learn PHP as well and build some simple bits in PHP?
- farm the work out to someone who knows what he's doing?

I understand my site and the TAFs very well, even though it's a few years since I've said hello to some of them, but know nothing at all about MySQL

The bigger of the two sites can wait to be relaunched in January so there's no real time problem for that. The more important site has two TAFs, one database


Good to be back, by the way!


Nick Froome
________________________________________________________________________



Roland A. Dumas
310 W. Bellevue Ave.
San Mateo, CA 94402
650-347-1373
415-412-9300 (cell)
AIM: radumas



________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to