RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

Well, My Site runs now on Solaris. Both the front end (Web Server / php code / Apache) and the Database (Backend server). We had some problems with Mysql and we don't find it 100% reliable for such a busy site. We also want to use a db cluster for high availability (we are talking about $200,000 of hardware and software for the change). The code will still run on Apache / PHP / Solaris so there is no change in that. Only the access to the Database will change. Does this help? berber -----Original Message----- From: Manuel Lemos [mailto:mlemos@acm.org] Sent: Saturday, January 12, 2002 10:28 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hello, Boaz Yahav wrote: > > Hi > > I'm planning to move my site (Very successful / high traffic Auctions > site) from MySQL to MSSQL Server 2000. > I was wondering if anyone has done this move and if there are any pit > falls to notice. > > 1. Is ODBC the only way to work from a Solaris / Apache / PHP 4 machine > to a Win2K / SQL Server 2000? > 2. What could be the performance cost (if any). > 3. Are there any special points that need to be taken into consideration > on either side? If you have these doubts I wonder if you are really sure if moving from OS and databases is the right thing to do. Maybe if you tell what is you motivation for the move we can address your real problems more objectively. Changing OS, Web Server and database server all at the same time sounds like an operation of great risk. If your motivation really justifies all the changes, maybe changing one thing at a time would be of less risk. Don't forget the Hotmail platform change fiasco. Regards, Manuel Lemos -- 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