Skip to main content
Participating Frequently
April 1, 2011
Answered

CF9,IIS7, and SQL Server 2008 R2 - Recommendations

  • April 1, 2011
  • 1 reply
  • 793 views

Hello Ladies and Gents,
I've been task (in a short amount of time), to place a CF website built by another group (and pointing to an Oracle DB), onto IIS7, using SQL Server 2008 R2 and CF9 without CF Builder.
I've done quite a bit of research (but not enough), and found conflicting answers such as you install CF9 on the same box as IIS7 and others say place CF9 on your PC (makes sense). I have Adobe Press  books for CF9 however they reference CF Builder (don't have) and not Dreamweaver CS5 (do have). I'll add to this that the last time I used CF was CF5. My hat is off to Adobe for all the great improvements.

My question: Where, in your opinion can I find a good "How to" source for making this all come together?

Thank you!
JoDigital

    This topic has been closed for replies.
    Correct answer Dave Watts

    The ColdFusion server documentation really tells you everything you need to know, and it's pretty concise. I recommend you start there.

    You will install CF on your IIS server for your production environment. This is the standard approach followed 99+% of the time. There are two alternate approaches: distributed mode and reverse proxy configuration, but unless you have very specific requirements (usually related to security) you can safely ignore those approaches.

    CF Builder and Dreamweaver are development tools. You don't have to worry about them for setting up your production environment. Individual developers can use CF Builder or Dreamweaver (or really any other text editor) installed on their own workstations to write scripts that can be deployed to a development or testing environment. Individual developers can also install CF on their own workstations, if they want to test locally - that's a pretty common thing to do. But none of this has anything to do with setting up your production environment, really.

    None of these things have really changed that much since CF 5 either. Just like with CF 5, you install CF on your production web server, and you may also install it locally for development.

    If you're switching from Oracle to SQL Server, that's a separate thing, which will require you change things on your database and in your existing CF codebase.

    Dave Watts, CTO, Fig Leaf Software

    http://www.figleaf.com/

    http://training.figleaf.com/

    1 reply

    Dave WattsCommunity ExpertCorrect answer
    Community Expert
    April 1, 2011

    The ColdFusion server documentation really tells you everything you need to know, and it's pretty concise. I recommend you start there.

    You will install CF on your IIS server for your production environment. This is the standard approach followed 99+% of the time. There are two alternate approaches: distributed mode and reverse proxy configuration, but unless you have very specific requirements (usually related to security) you can safely ignore those approaches.

    CF Builder and Dreamweaver are development tools. You don't have to worry about them for setting up your production environment. Individual developers can use CF Builder or Dreamweaver (or really any other text editor) installed on their own workstations to write scripts that can be deployed to a development or testing environment. Individual developers can also install CF on their own workstations, if they want to test locally - that's a pretty common thing to do. But none of this has anything to do with setting up your production environment, really.

    None of these things have really changed that much since CF 5 either. Just like with CF 5, you install CF on your production web server, and you may also install it locally for development.

    If you're switching from Oracle to SQL Server, that's a separate thing, which will require you change things on your database and in your existing CF codebase.

    Dave Watts, CTO, Fig Leaf Software

    http://www.figleaf.com/

    http://training.figleaf.com/

    Dave Watts, Eidolon LLC
    JoDigitalAuthor
    Participating Frequently
    April 1, 2011

    Dave,
    Thank you for the quick response! I will check out the CF sever documentation (which I overlooked, yes the pressure is on), very helpful answers. I’m looking at your website and the classes you offer. I'll see if I can’t get management to look into some funding.

    Thank you again,

    JoDigital


    Community Expert
    April 1, 2011

    You're welcome!

    Dave Watts, CTO, Fig Leaf Software

    http://www.figleaf.com/

    http://training.figleaf.com/

    Dave Watts, Eidolon LLC