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):
(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:
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! :)