Auto move data from MySQL to MSSQL?

[shaztesting]

Hi guys,

I'm looking for some direction on how to tackle this challenge.

My client has their custom Customer Relationship Management system in a windows enviroment using MSSQL (and some Access 97).

They have agreed to zen cart as long as they can pull sales data out from MySQL into MSSQL for order processing.

How should I go about this? (I don't have much experince with databases)

1. I know I can manually backup the store db into an .SQL file or a .CSV or a .XML but how would I go about populating a database inside MSSQL with values from MySQL live (or atleast daily automated scheduling)?

2. Ideally we would like to have one neat table row that includes all customer details, all order details, all attribute details, etc. Is this possible using a custom php query script and sorting by order_id?

3. If not, and we need to find the data accross multiple tables, what tables would one need? To me it seems order_id is the most important column as it links all the relevant data together.

This is my plan for retreiving sales data:

-> use order_id in 'orders' to retreive relevant order data
-> use order_id in 'orders' to find customers_id

-> use customers_id in 'customers' to retreive relevant customer data

-> use order_id in 'orders_products' to retreive relevant product sale data
-> use order_id in 'orders_products_attributes' to retreive relevant attribute data

What am I missing?



Thanks in advance for any direction you can help me with,

Regards,
shaztesting

[poolprorich]

you should find the drivers for MySql ODBC conect her at this location including docs.

ODBC Driver for MySQL
http://www.mysql.com/products/connector/