This is a question about ideas and opinons on the best method to achive the following
I have a mssql data base that sits on a server that is not connected tot he net, it is on the network but we do not use it for the net. What I need to do is to update two table in a mysql data base that a web site is reading from. the two table will hold class information student and courses.
I have come up with several ideas and am looking for the best method and for each idea is it good can you see any pit falls in the idea and what else copuld I do.
1) the mssql holds the two table that I could export out each night to a text file that could be uploaded via a third party pakage written in C# or VB that would update the tables every night. if it was updated each night this would be ok
2) possible build a interface to another pc that has intenet access up to date a table here that could then be used to up load the file to the server mysql data base.
3) upload the field to the server its self in some auto upload file, and have a program up on the server auto extract and load the table. Have not done this before not even sure how you could do it.
4) have limited output access from the server pc and create a portal that would access the mysql data base on the web server and then up date the data base directly.
5) create a standalone php comp on the server to hold a miirror of the data and use this to directly update the web server.
note ***have never had to convert data from mssql data base and place it into mysql data base not sure what is involved in this
*******************
so at presrnt that is were Im at, I am trying to get informaed on the best way to do thiis.
any help would be appreciated
garry
Start Free Trial
