Skip to main content
Participant
May 2, 2013
Question

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

  • May 2, 2013
  • 1 reply
  • 1412 views

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?

    This topic has been closed for replies.

    1 reply

    bforta@adobe.com
    Adobe Employee
    Adobe Employee
    May 2, 2013

    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

    Legend
    May 3, 2013

    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/coldfusion10-support-matrix.pdf

    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.