Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2009-05-08 10:14:28
- Qwest
- Member
- From: London, UK
- Registered: 2007-01-24
- Posts: 112
Txp & Ms Sql?
I’ve slowly been redeveloping my company website basing it on TXP as opposed to an archaic ASPX system previously used.
I’ve only just recevied details of the company host & server – and have learned that it uses an MS SQL server as opposed to an MySQL server.
Will this cause a problem? Does TXP & MS SQL Work well together?
Offline
Re: Txp & Ms Sql?
Qwest wrote:
Will this cause a problem? Does TXP & MS SQL Work well together?
No, Textpattern doesn’t officially work on MSSQL. MySQL is required, or a compatible.
- PHP uses different functions for MSSQL and MySQL – as those both dbs work differently. So you would need to change all (TXP) SQL related functions to work with MSSQL, or use a alternative driver plus mods.
- Plus there are some restrictions by shitass MS libs, that for example limit the lenght of colnames and so on. Unicode support is also so… so… bad.
- Plus those PHP’s MSSQL functions don’t apparently work so well. PHP doesn’t really like MSSQL as userbase relies on MySQL.
Easiest solution is to install MySQL on that server. It’s easy, and MySQL and MS SQL don’t cause anykind of incompatiblies when run on same server. I would recommend to do that, if the host allows it.
Last edited by Gocom (2009-05-08 12:57:21)
Offline
#3 2009-05-08 16:13:21
- progre55
- Member
- Registered: 2006-05-02
- Posts: 668
Re: Txp & Ms Sql?
Gocum:
Sticking with the same topic. Have you come across any solid conversition tools when it comes to taking a MS SQL DB and importing it into a TXP MYSQL DB …
progre55
Offline
Re: Txp & Ms Sql?
progre55 wrote:
Have you come across any solid conversition tools when it comes to taking a MS SQL DB and importing it into a TXP MYSQL DB …
You would want to convert the MSSQL data to MySQL first and then modify the schema in a PHP script. mssql2mysql seems to be a popular converter, but there are some more listed under the “Migration Tools” heading here.
Offline
Pages: 1