Toby, Either MySQL or PostgreSQL are good database alternatives. I'm more of a hardcore database person so I prefer PostgreSQL because of it's support for transactions. I've also found the SQL grammar in PostgreSQL to be a little more standard. Another option would be the Firebird project (http://firebird.sourceforge.net/). It was originally the Interbase product from Borland.
Coming from FoxPro, either database is going to be a nice step up in the world. The main thing to keep in mind is that you'll have to pay a bit more attention to some of the standard database things like normalization and referential integrity. -- William D. 'Diggy' Bell Principal DB Software Development http://www.dbsoftdev.com "Toby z" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > ok guyz i need some inside info ..... > > plz help me with: > > > 1. if i ve to conver a db in foxpro to mysql or sql which one should > i preffer to use with php and y ???? > > > 2. and while im converting the foxpro db to mysql what will i ve to > loose ???? the common pitfalls ...... > > > 3. there aint no foreign keys in mysql then what can i do about > cascading updates, deletes and all > > > 5. n finally do i have anyother choice of open source database > (cheapest if not completely free) for this conversion ????? > > > > id be eternally gratefull if anyone cud guide me thru this ...... > > > thnx a billion zillion guyz ..... > > toby ...... > > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
