What is your position at the school? If you are on the IT staff and have great say in the decision-making process, I would suggest that you migrate to MySQL *and* switch to a Linux/BSD system. The latter is more a matter of preference, but I feel that using a more common DBMS (like MySQL or PostgreSQL) would be beneficial to all involved. There's no need to teach staff and/or students the inner workings of a system they'll probably never see again.
At 13:15 10/05/2003 10/05/2003, colbey@dreamwerx.net wrote:
If you do end up considering migrating to mySQL on any platform.. search google for SQLyog .. it's a win32 db client that can migrate odbc datasources such as your paradox db to mysql.. So easily, that you might consider doing it one night when your paradox db get's slow.. migrate the
database, copy all the php code to a 2nd location, modify for mysql and test it out ;)
Thanks a lot for all these suggestions. I tried SQLyog and converted from Paradox to MySQL a whole DB with many tables (some with more than 10000 rows) in less than a minute! Really remarkable for a free and slim (only 500k of download) product!!
I am now encouraged to try the migration, but to modify the php code will be not that simple: it isn't just a matter of finding 'odbc' and replacing with 'mysql' ...
Any way I am seriously thinking to substitute Paradox with MySQL for teaching purposes too; I found MySQL Control Center a free and easy to use interface, which should be good in the classroom too.
Paolo Bonavoglia --------------------------------------------------------------------------- Webmaster http://www.liceofoscarini.it/ E-Mail paolo.bonavoglia@liceofoscarini.it paolo_bonavoglia@virgilio.it
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
