Working with MSSQL and MySQL at the same time, or ..

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Wabby
Forum Newbie
Posts: 2
Joined: Sat Nov 13, 2010 6:08 am

Working with MSSQL and MySQL at the same time, or ..

Post by Wabby »

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
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

Sounds like a job for cron script populating some MySQL tables from MSSQL.
Post Reply