MS SQL to MYSQL for stock quantity update

General General Questions
1

We wish to update the stock Quantity of cs-cart in the internet from our office account stock program based on MS SQL .

I belive we basically only need two columns product code l, stock quantity and possibly the option. (options makes it more difficult.

What is the best and user friendly method. I would like to update the quantities

once per day.

Any recommendation???

Having checked the internet, I have noted the following article item. [url]http://developer.infi.nl/daniel/Linking%20MySQL%20and%20MSSQL.pdf[/url]

I

Thanks

D. Ustundag

2

Did you ever get this hooked up, i would like to know how you got on?



The option quantities def. make it harder.

3

Yes Indeed, using linked server on MsSql to mysql.

4

And how do you handle the options?