Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MSSQL to MySQL conversion


Guest

Recommended Posts

Can someone tell me if they know a method to import / convert a MSSQL database to a MYSQL data base.

 

Here is the dilemma, I have a MSSQL database running on another server with over 40,000 items, updated every 24 hours. And I have just began redesigning the website and have choosen OsCommerce as the catalog. However, I need to import and convert? this database to use it with OsCommerce MSQL on my server. I hope I made sense, as I am new to this! Trying to learn.

That is why I like open forums, since everyone is so willing to share and help others.

Thanks in advance!

Link to comment
Share on other sites

OK, but here is the nextdelimma. The MSSQL database is updated daily and requires to be imported daily. How can this be done automatically? to include pictures and descriptions etc....

Link to comment
Share on other sites

Some custom programming to extract the product information and image links from the MSSQL site and then additional custom programming to take that information and load it on to your mysql database and the appropriate image directories.

 

Then have those custom applications run either as a "scheduled Task" under windows or via cron on a *nix box.

 

Tom

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...