access another database with lower cost
Posted: Tue Mar 03, 2009 9:03 pm
we need to make a web site using php on Unix, and let user search and view data, however, the database is MS SQL located in another machine.
we know how to use php to access MS SQL data, however, we don't want to purchase extra license for MS SQL because of budget issue, is there any good way to do it ? we have thought of transferring data from MS SQL to MySQL automatically, but just worrying the transfer time because we want the website has data as less discrepancy as possible.
Pls suggest if anyone has a better way, thanks.
we know how to use php to access MS SQL data, however, we don't want to purchase extra license for MS SQL because of budget issue, is there any good way to do it ? we have thought of transferring data from MS SQL to MySQL automatically, but just worrying the transfer time because we want the website has data as less discrepancy as possible.
Pls suggest if anyone has a better way, thanks.