<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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.<br />
<br />
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?<br />
<br />
I would have to map the fields while doing this.<br />
<br />
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?<br />
<br />
Matt
</div>
</div>


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

MySQL website to/from SQL in store

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.