We have an existing proprietary ecommerce software with database running on MSSQl
We want to upgrade to another open source software (Magento) with a database on MySql.
We expect the MSSql database structure and the MySQL database structure will be different so the requirement for extraction, verification, validation and then upload.
What we need
1. We want to pull all data from this MsSql database to MySql database on Magento Platform
2. The data transfer should allow for selection by Date or Order id or Customer id for Data Verification and checking
4. We also understand that Customer Id and Order id format will be different; so a tool to convert to Magento format would be useful also.
3. A copy of the Magento Database table is attached. I will provide the MsSql database structure later.
Let me know your thoughts and solutions + bids.