Can you use SQL 2012 with ColdFusion 9? Or upgrade to 10?

[shaunpyle1]

Currently have a client with SQL 2008 and ColdFusion 9.  They are upgrading to SQL 2012. Do they need to upgrade CF to 10? Or will 9 work?

[bforta@adobe.com]

SQL Server 2012 is mostly backwards compatible with SQL Server 2008, there are known changes but not that should impact client login and the ability to submit most SQL statements. You may want to install an evaluation version of SQL Server 2012 on another machine and just try to create a datasource connection to test it. But, that said, it should indeed work.

--- Ben

[carl type3]

The CF10 support matrix says SQL Server 2005 and 2008.

http://wwwimages.adobe.com/www.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/cf10/coldfusi...

SQL 2008 r2 or 2012 are not listed as supported. If it helps I have been using CF9 and 10 with SQL 2012 without any issues. As Ben notes perform some testing before switching working environment over to SQL 2012. HTH, Carl.