We currently use a DOS based flat file db (FilePro) to conduct surveys for clients. It's a cumbersome system, requiring various text files to be produced which can then be manipulated by Access or Excel, and some of this is then exported to MySql so clients can view data on the web. It's basically a hodgepodge of systems built up the last dozen years or so, each layer being added as time went on.
We want to move to a new, more integrated system. The owners have gone with a local firm of a couple of guys who I know from a previous job. They're ok, but they want to develop the system in Delphi (a visual version of Turbo Pascal, with similarities to VB but more db capability), and change from free MySql to MS Sql Server.
Ok. We want to have the license to work on the code, since many clients have customized needs. But I'm the only one who's worked on Delphi, and not much at that. And none of us have worked on Sql Server. And this will have to interface with MS Office, or the rest of folks will be clueless, or more so than they are now.
Anyway, it's not my decision ultimately, although I have input. What questions should I ask or stuff to look out for? Any suggestions appreciated. Thanks.