We are in the process of a complete e-commerce web site redesign on a new server with a new platform, and a new shopping cart and we require database migration. We need to migrate all of the data currently on our SQL Server, which is currently an ASP .net environment to our new server, which is Red Hat Linux, and mySQL database.
Our current e-commerce software is storefront.net. On the our new server, we are switching to x-cart. We require complete database transfer and population including: images, brands/vendors, product short and long descriptions, all product attributes (size, weight, flavor, etc.), categories, prices, shipping weight, volume pricing config, specials, coupons and give certificates, customer information: logins, ship to and built to addresses, order history, etc.
Must we very experienced with X-Cart and have previous experience and references developing X-Cart e-commerce sites.
Well this is interesting...i have never seen som, ebody migrating shopping cart from .Net to X-Cart. This is a challenging job as migrating data from MS SQL to MySql database. I have a experience of both MS SQL, .Net and php, MySql...so for me its quiet interesting and challenging..I know the X_cart or OsCommerce kind of open source shopping cart. I am not sure whether it is possible to migrate data from MS SQL to My sql without losing any constraints as you haven't mentioned the version of My Sql database. I have a offer for you...provide me details of ur database server i shall ask my DBA to analyse and give you report...for free....then we can proceed further..My friend you are asking for toughest task to implement so take my words and let me help you.......hope to hear from you.......take care