Brian, My question is,
Can PostGreSQL successfully replace MS SQL Server, whilst maintaining the ability to replicate or import from a remote MS SQL Server database? I've ported our CF(MX) apps over to linux but have retained MS SQL 7 as the backend database with the intention of upgrading soon to SQL2000 for compatibility with our suppliers and clients systems which are mostly M$ centric. I'd love to be able to save several thousand dollars (SQL2000 enterprise is approx �12000 GBP) and move to an alternative whilst retaining the ability to update (replicate) from our suppliers SQL 2000 box and push updates to our clients using SQL/Access. Can PostGreSQL do this? Are there any good comparison matrix sites? Thanks, Dave -----Original Message----- From: Brian Panulla [mailto:[EMAIL PROTECTED]] Sent: 16 January 2003 17:10 To: CF-Linux Subject: RE: flare networks Because the defacto standard of PHP backends is MySQL. I can only guess this is because most PHP/MySQL developers come into Web development never having used a proper, full-featured RDBMS like MS SQL Server or Oracle. If all you ever use is MySQL, you learn to code by working around the limitations of your RDBMS, which is suicide the moment your application passes that magical critical complexity line and your wonder why your pages are all slow. PostgreSQL is also a little arcane to administer. It took me a few weeks to really get the hang of the pg_hba.conf file. Now that I know how it works (and have written best-practices scripts for my co-workers) I don't look back. Viva PostgreSQL! :) For all you MySQL devotees out there, take the time to try out PostgreSQL... you won't look back either! -B -----Original Message----- From: Fabio Serra [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 11:18 AM I really don't understand why linux hosting company offers only Mysql database. It's the weak point of all Linux hosting vs Windows hosting. How could compare sql server vs mysql? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
