You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi guys,
I've been running on MS SQL express for the last six months and for the most part without problems. I know SQL Express is not listed as a supported database but it is basically MS SQL server with a few restrictions applied for database size etc. It now looks as though some minor problems can possibly be attributed to SQL express so I'm thinking of changing to MySQL. I'm running CCP6 on a Windows 2003 web edition server and am wondering if I can migrate without damaging existing data or having to setup the cart again.
The problems I'm having are uploads to the cart (custom connector) being terminated before they're complete, they sometimes work and sometimes not.
If anyone can offer any advice I would be most grateful.
Thanks and regards,
RobH
Offline
Your biggest challenge is likely to be finding a tool to migrate your data from one SQL engine to the other. Beyond that CCP won't care and running the installer will allow you to change the connection information easily.
Offline
Ok, thanks Dave, I noticed the 'backup database tables' option in KHXC admin, would this backup SQL version specific data or would it be in a generic format that could then be restored to the new SQL version?
I don't suppose it would be a huge issue to start again with an empty database, only some of our customers might be a bit annoyed at having to recreate their account, we would also end up with a lot of duplicate account information in our business system.
Thanks again
RobH
Offline
Backup through CCP simply creates copies of the tables in the same database. Usually useful to use before you make some sort of major change and need a way to back out if necessary.
Offline
ok, thanks
Offline
I would recommend looking at the following page. There is a section that lists tools recommended by MySQL to convert a database from MSSQL to MySQL.
http://dev.mysql.com/tech-resources/art … osoft.html
Offline
Thanks for that, very useful!
Cheers
RobH
Offline