MS SQL import script
Posted on 2013-01-25
I was wondering if someone could assit me with this problem -
I have an ERP system that controls the stock levels of my products and want to update this and pricing information so that it matches my website's database.
From my server I have remote access to both databases. The ERP system uses MS SQL but my website uses MYSQL 5.0
My stock items will have the same ID in both databases.
I use the following SQL statement on my ERP system -
where status = 'a';
I basically want to update the results to the same fields on my websites database by scheduling a script to run on an hourly schedule.
The reason why I need help is because i've never really done this thing before with PHP and really not sure where to start!
Any help is appreciated!