There are few things you should consider; perhaps you already have. You may
not be replacing the OS of your Web server but you will be adding a new OS
for the database since MS SQL only runs on Windows. So now your site will
have a Solaris / Apache piece and Windows cluster running MS SQL.
I have run configurations like this and they do work however if your
fundamental goal is better reliability I suggest to be careful about MS SQL.
My experience (not wanting to start any flame wars here) has been that MS
SQL is not as reliable as some of the bigger names such as Informix / IBM
and Oracle. All of those also run on Solaris which means you could still
only have one OS. That may or may not be an advantage to you.
The other issue to be very careful about regarding MS SQL is it is not
supported on Solaris. So if you have an issue where the database appears to
be functioning normally yet your Apache Web server cannot retrieve data from
the DB Microsoft will have nothing to do with helping you fix this. It is
an unsupported configuration; the connectivity products you will use,
whatever they are, will not come from Microsoft nor will any help.
But to answer your specific questions:
ODBC, JDBC are not the only ways to move data from the database to Apache
but they are the most popular ways because they're easy to use and they do
work very well.
Also check out freeTDS (tabular data stream) and a product called OpenLink,
there are others try Web search from your favorite search engine.
A few months ago we did a benchmark and we found JDBC to be faster than the
Microsoft client or ODBC. In our case we believe this was because of the
way that JDBC returned results in larger chunks which matched our needs for
that App. Your mileage may vary; these things depend on your application
and a particular versions of the software and combinations of the software
using. Nothing beats having the time to try a couple different combinations
and see which works best for your situation.
I don't think there any particularly special points you need to consider
because you're using MS SQL but as I've said each application can be
different and have its own unique needs.
> 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?
> -----Original Message-----
> From: Manuel Lemos [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 12, 2002 10:28 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000
> Boaz Yahav wrote:
>> 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
>> 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
>> 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.
> Manuel Lemos
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]