This is a part of a project where a joomla e-shop is about to get built and there is an SQL server 2005 intranet database (auto tyres). We want to get data from one table (products and quantities) in SQL server and update the joomla e-shop with virtuemart.
The update could be done once per day or on every transaction when a client is buying some tyres and the SQL Server gets updated.
What i need is a solution to get data from SQL server and update virtuemart (mysql)
I am looking forward for your bids.