I'm looking for some insight on connecting to a MSDE database on Windows 2000 Server via a local Linux / Apache
/ PHP / mySQL box. I am comfortable with PHP / mySQL, but am very new to MSDE / SQL Server.
I have created a small web app to help our production departments track work progress, etc. The problem is, as of now most information is entered twice; once for the original order / invoicing application, and the second time when much of the same data is duplicated manually into the web app. Needless to say, this is big waste of time, and a potential source for errors.
All I want to do is be able to SELECT from the database on the Win2K server and then INSERT / UPDATE the mySQL db on the Linux box. I don't want to modify the extremely important data in the original application in any way. I'd have a hard time trying to justify how I murdered years worth of data (yes, we have backups!) tinkering away.
There will never be more than 5 to 10 simultaneous connections to my web app, so the solution doesn't have to be the most robust, scalable, super-duper approach around. A simple, easy does it setup will work here as long as it can gaurantee no harm will be done to the MSDE database or the Win2K server.
Fully updated / service pack'd
SQL Server 2000 / MSDE
Current database is from order / invoicing application.
Dell PowerEdge 4200
RedHat 9 (Shrike)
PHP Version 4.2.2
Both machines are on the same subnet, and I have full physical and administrative access to each. Is this going to be a relatively simple thing to do, or am I way off base?