Working with MSSQL and MySQL at the same time, or ..
Posted: Sat Mar 19, 2011 4:39 am
Hi guys,
I'm looking for some advice on dealing with both MySQL and MSSQL databases at the same time, or if possible, to find a way to 'update' the MySQL database with data from the MSSQL database periodically (5/10 minute intervals)
Basically, I am trying to integrate an existing PHP shopping cart with MySQL database, to include "LIVE" stock levels from my own accounting system software.
I know which queries I need for the MSSQL database to get stock levels out, and I have unique fields in both datasets to query to get the data out - I'm just looking for the cleanest, easiest way to display the data.
Ideally I dont want each query going from the webserver, to my local machine to query for stock levels. Hence my theory on the periodic update.
Can anybody push me in the right direction?
Regards
I'm looking for some advice on dealing with both MySQL and MSSQL databases at the same time, or if possible, to find a way to 'update' the MySQL database with data from the MSSQL database periodically (5/10 minute intervals)
Basically, I am trying to integrate an existing PHP shopping cart with MySQL database, to include "LIVE" stock levels from my own accounting system software.
I know which queries I need for the MSSQL database to get stock levels out, and I have unique fields in both datasets to query to get the data out - I'm just looking for the cleanest, easiest way to display the data.
Ideally I dont want each query going from the webserver, to my local machine to query for stock levels. Hence my theory on the periodic update.
Can anybody push me in the right direction?
Regards