What would be the benefit in converting a paradox db into a mysql one other then the fact that mysql is more popular these days with most programmers? Any ideas or constructive thoughts? - Swapw
From what point of view? Paradox and mySql are of so different kind thats its very hard to talk about benefits without talking about the loss. Paradox is a frontend engine build on bde (borland database engine) It could rather be more or less compared to oracle forms in pov of its porpose. Across the board, if you skip paradox and the bde for mysql you get a wider range of deploy options but left behind they forms. You have to rebuild all these paradox forms from scratch. I would not say its a bad idea. The bad idea was to use a RAD system like paradox at the beginning.
In terms of view, I meant more towards its effectiveness, modification, compatibility, and management. Why is using a RAD system like paradox in the beginning is a bad idea? More info pls, thanks!
These are feature-length questions. i will drop out those anwers who i will remind first, anybody is invited to extend this list! effectiveness, paradox: + you can develop and deploy small to medium customer solutions as a desktop applications in a fast manner - you have to distribute patches/update to your customer mysql: + you can develop and deploy small customer to carrier-grade solutions and you are not limited to the computers desktop - you need a software what processes and displays your forms, this includes (but is not limited to) php or java compatibility, paradox: + database format is well know + other bde based software have direct access + native import to bde from DB2, Informix, Interbase, MS SQL Server, Oracle and Sybase + other DB's can import via ODBC + plenty abstraction layers from borland based products.. - ..who unfortunately reach end of lifetime cycle - limited to windows - keys for encryption are at the db mysql: + runs on so many operating systems, thats even hard to say on what plattform it will not run + is supported by the most DB abstraction layers + embraces several DB engines + compatible to no-budget projects management: paradox: is there more management tools than those mentioned importers and the start/stop button at the windows services dialog? - you can stop/start than engine from windows service dialog - no replication - no clustering + a nice product box from corel where you can store your discs and the installation guide mysql: + you can powercycle mysql with a single command, but you can even use start/stop on windows if you usually need that to be sure - no glossy product box + powerful replication + powerful clustering no more time sorry..