MSSQL to MySQL conversion

[Guest]

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!

[Guest]

I was hoping someone could tell me how to incorporate the MSSQL database into OSCommerce catalog!

[Guest]

export to excell then import via easypopulate

[Guest]

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....

[OceanRanch]

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

[Guest]

so, no easy way to do this then is there?

[Guest]

it isnt as bad as you think, just takes a bit of programming