Dan560
asked on
MS SQL import script
Hi,
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 -
select
ID,price
from items
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!
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 -
select
ID,price
from items
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.