MS SQL to MYSQL for stock quantity update

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][/url]



D. Ustundag

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

The option quantities def. make it harder.

Yes Indeed, using linked server on MsSql to mysql.

And how do you handle the options?