Guest Posted April 23, 2005 Share Posted April 23, 2005 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 More sharing options...
Guest Posted April 24, 2005 Share Posted April 24, 2005 I was hoping someone could tell me how to incorporate the MSSQL database into OSCommerce catalog! Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2005 Share Posted April 24, 2005 export to excell then import via easypopulate Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2005 Share Posted April 24, 2005 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 More sharing options...
OceanRanch Posted April 24, 2005 Share Posted April 24, 2005 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 More sharing options...
Guest Posted April 24, 2005 Share Posted April 24, 2005 so, no easy way to do this then is there? Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2005 Share Posted April 24, 2005 it isnt as bad as you think, just takes a bit of programming Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.