stephensaw Posted June 14, 2007 Share Posted June 14, 2007 Hi, I downloaded the lastest version of osCommerce, is there any method I can connect to MSSQL? I googled it and I from the result topic I saw someone said managed to migrate, but the result actually don't bring me to the real page. Thanks. Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 14, 2007 Share Posted June 14, 2007 No, they are not compatible. You will need to convert it to Mysql. There are many conversion tools available, although I don't know how well they work. Check the Mysql website for some. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Bloged Posted June 14, 2007 Share Posted June 14, 2007 No, they are not compatible. You will need to convert it to Mysql. There are many conversion tools available, although I don't know how well they work. Check the Mysql website for some. Jack I agree! As it would be very simple to change the class that connects to a MySQL database to one that connects to a MSSQL database the SQL syntax is different so that all statements need a rewrite... Your best option is to convert the database into a MySQL version! Grtz, Arjan Gelderblom I think computer viruses should count as life. I think it says something about human nature that the only form of life we have created so far is purely destructive. We've created life in our own image. -- Stephen Hawking Link to comment Share on other sites More sharing options...
stephensaw Posted June 14, 2007 Author Share Posted June 14, 2007 Hi, If I manage to convert the MySQL database to MSSQL database, then I might need to convert the connection string on each page, right? Thats a lots of works. Link to comment Share on other sites More sharing options...
aznkpride0922 Posted June 15, 2007 Share Posted June 15, 2007 Hi, If I manage to convert the MySQL database to MSSQL database, then I might need to convert the connection string on each page, right? Thats a lots of works. yes.. you will hab to edit every single query being genrated in php code to fit MSSQL. I suggest converting MSSQL to MySQL. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.