RE: [PHP-DB] Converting ASP/MS-SQL 6.5 to PHP/MySQL - any tips, hints, HELP!?

There are a number of MS-SQL specific features that you will either have to re-code in PHP or do without: Stored Procedures, triggers etc, and non standard (SQL92) SQL (e.g. SQL Server has a CONVERT function), SQL Server specific data types may prove problematic too. If the SQL Server DB has been developed "correctly" (taking full advantage of SQL Servers Features), you may face a few difficulties. Non of which should be insurmountable though - take it a step at a time... I'm about to move a rather large SQL Server 7.0 DB to our own proprietary back end -Easysoft RDBMS (included with the Easysoft SQL Engine) so if I come up with any hint/tips, I'll pass them on... _____ ~ Richard Allsebrook ~ Applications Developer and Webmaster Easysoft Limited, No3 The Embankment, Leeds, LS1 4BJ http://www.easysoft.com <http://www.easysoft.com> The Home of Data Access Middleware "A computer lets you make more mistakes faster than any invention in human history-with the possible exceptions of handguns and tequila." _____ -----Original Message----- From: Brian Tully [mailto:btully@gstockco.com] Sent: Tuesday, July 11, 2000 6:13 PM To: PHP DB Subject: [PHP-DB] Converting ASP/MS-SQL 6.5 to PHP/MySQL - any tips, hints, HELP!? hi there - I've just been honored with the dubious task of migrating a site from NT (MS-SQL 6.5/ASP) over to our dedicated Linux box. I'm hoping that I can convert the site over to MySQL/PHP as painlessly as possible. Has anyone on this list done this before? I'm not at all familiar with MS-SQL or ASP so I was wondering if there were any utilities or scripts that would convert the output of MS-SQL into something MySQL would understand (i've already discovered an asp2php script). Any help/suggestions would be greatly appreciated. Regards, B r i a n T u l l y -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net