How do I migrate joomla mySQL to msSQL?

Asked By David Harrison 0 points N/A Posted on - 03/18/2013

Hi people.  Can someone help me with this? 

How can I accurately migrate Joomla MySQL to MySQL? 

I have Joomla 1.7.0, Ubuntu 10.04.4 server and PHP 5.3.3. 

I plan to migrate it on Windows Server 2008. 

Any suggestions would be highly appreciated. 

Thanks.

• Status: Open
• Question Views: 11825
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Drake Vivian 30 points N/A #139675

How do I migrate joomla mySQL to msSQL?

Hi there David Harrison,

Even the migration to Microsoft SQL sounds really nice, unfortunately, in your case it cannot be done successfully.

 

Joomla CMS doesn't support Microsoft SQL databases before the 2.5 version, so in order to migrate your site you will need to upgrade your Joomla site first.

 

Also, you should know that many of the components, modules and plugins will not work on the Microsoft SQL database so make sure you have the backup option for every extension that might stop working.

 

Once you've updated your website, migration is not hard at all. For detailed instructions please visit this link: MySQL to Microsoft SQL.

 

Best regards,

Drake Vivian

About Drake Vivian

Questions
0

Answers
820

Best Answers
186

• Vote Up 0 Vote Down

• Posted on - 04/08/2013
• Question Category: MS SQL Server