MySQL Forums
Forum List  »  Microsoft SQL Server

Vexing MSSQL 2000 to MySQL Conversion Problem Involving phpBB - Please Help!
Posted by: mysql
Date: September 17, 2004 05:51PM

Hello folks,

I'm trying to move a phpBB2 2.0.6 forum database from a Microsoft SQL 2000 server running on Windows NT 4 (I believe) to a MySQL 4.0.20 server running on RedHat Linux 9.0.

I've tried a number of methods, including Intelligent Converter's (http://www.convert-in.com/mss2sql.htm) MSSQL-to-MySQL program (which I bought last year), Michael Kofler's (http://www.kofler.cc/mysql/mssql2mysql.html) MSSQL2MySQL conversion VB script (I actually used Roberto Alicata's GUI version on the same site), a trial version of (http://www.realsoftstudio.com)SqlPorter, and Microsoft's DTS Import/Export Wizard (that comes with SQL Server) coupled with a MySQL ODBC driver in Windows, all with various options. Every time I load up the converted DB into the MySQL server and look at the result in phpBB2, I see this with nearly all the posts (a live running demo here):

http://www.requestnetwork.com/phpBB2/viewtopic.php?t=278

(feel free to look around at other posts and see more of the effects)

Whereas here is an example of the forum displaying properly on the old server:

http://www.request-a-song.com/phpBB2/viewtopic.php?t=278

Aside from the most obvious problem -- something breaking the post display table(s), there are a number of other errors such as what looks like attempts to comment out quotation marks (\" etc) and also barely any forum quote boxes are working. The odd thing is that last year I ported the same forum DB (albeit much smaller then) to a Windows 2003 machine running MySQL using the same IC MSSQL-to-MYSQL convertor program and it seemed to run fine without a hitch. But now, on linux, no such luck. / Update: I recently transferred the DB to my Windows 2000 computer running MySQL and a new copy of phpBB 2.0.10 last night just to test, and the same exact symptoms appear. So it's not Linux-specific.

It's not a corrupt template problem in phpBB. This happens with freshly downloaded multiple copies of phpBB 2.0.10 on multiple machines. It also happens in a copy of PHPBB 2.0.6 that I copied from the old server.

Let it be noted that the same database in its native MSSQL 2000 format works flawlessly.

I suspect there is some weird problem with line break conversion that's screwing up some of the code, but I'm not certain at all and I really need help sorting this out because I need to move this forum to a new server VERY soon.

Any help anyone could provide would be greatly appreciated! I need it urgently, as I need to migrate soon for a site relaunch.

Thanks a bunch! :)
Benj

http://www.requestnetwork.com/phpBB2/viewtopic.php?t=278

Options: ReplyQuote


Subject
Written By
Posted
Vexing MSSQL 2000 to MySQL Conversion Problem Involving phpBB - Please Help!
September 17, 2004 05:51PM
October 08, 2004 06:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.