Good Day,
I got this client who has a legacy application with stale data on progress.
The db server is on Wint NT4 and the client is on Windows NT terminal.
They want to access their data , for historical research sometimes, in another method then Windows NT terminal client.
Right now, both the server and the terminal are virtualized with VmWare, so Hardware is not a problem.
My initial approach was to extract data from the db, convert it to mysql, and build a php web app so it is centralised on their local network.
I am having a really hard time converting to mysql without losing data integrity.
Instead of this approach, I was wondering if it would be possible to interface php with the windowsNT server db with odbc ? That way, db remains intact, and i can provide an small interface to do their neeeded baisc research ? If this was possible, any quick gist of how it can be done ?
I got this client who has a legacy application with stale data on progress.
The db server is on Wint NT4 and the client is on Windows NT terminal.
They want to access their data , for historical research sometimes, in another method then Windows NT terminal client.
Right now, both the server and the terminal are virtualized with VmWare, so Hardware is not a problem.
My initial approach was to extract data from the db, convert it to mysql, and build a php web app so it is centralised on their local network.
I am having a really hard time converting to mysql without losing data integrity.
Instead of this approach, I was wondering if it would be possible to interface php with the windowsNT server db with odbc ? That way, db remains intact, and i can provide an small interface to do their neeeded baisc research ? If this was possible, any quick gist of how it can be done ?