MySQL website to/from SQL in store

movieprodw
movieprodw used Ask the Experts™
on
Hello,

I run a magento storefront and my client asked if I could connect the website to the in store sql db to pull inventory and send orders to.

I am not familiar with how to do this and I am thinking that I could run a cron to send a csv file to a location on the website then tell the customers computer to pull that file and import it into the SQL server they have locally?

I would have to map the fields while doing this.

On a difficulty scale how hard would this be? I can easily have the file dumped to a folder no problem and can use php to map the fields but how to I get that file to their local sql server?

Matt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can configure a SQL Agent job to pick this particular files from specific folder - this agent can be configured to run every x time..In other words can run at specific times.

This SSIS package can pull the data from dump file and insert the data to SQL Server. This is one option.

Still you can write custom code with .net and run as windows service too.

Also powershell script is another option.

Author

Commented:
thx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial