Managed Hosting



Project Home Forums Known Issues Screenshots External Project Link Contact Project

Author: Kevin Miller (All RIAForge projects by this author)
Last Updated: November 13, 2017 10:58 AM
Version: 10.2.0
Views: 65,515
Downloads: 2,835
License: Apache License, Version 2


DBX is a tool to aid in the development of repetitive coding tasks for SQL Server 2000/2005/2008/2012 databases, as well as providing a convenient way of viewing db objects and schema without resorting to Enterprise Manager / SQL Management Studio.

DBX allows easy exploration of SQLServer 2K+ database objects and metadata, generates cut and paste CFQUERY and CFSTOREDPROC code based on the datatypes contained in the given db object, and lets you quickly access the schema and details of tables, views, stored procedures, user-defined functions, triggers and more.

When generating stored procedure (both cfquery and cfstoredproc) code, the code generator generates 'positionally correct' SQL statements, in addition to providing the named parameters. This allows the generated code to be used with earlier versions of CFMX / SQL Server where named parameters were not supported, but relied upon sequence of the parameters in the executed call.

DBX does not employ nor require an application scope; it is by design intended to be able to be dropped anywhere, regardless of framework, or lack thereof.

DBX provides a number of customization points which allows you to create your own generated output templates if desired; these features do not attempt to impose any specific code generation styles upon you (such as specific methods of creating CFC's); instead, it provides a number of hooks which allow you to take db object data, contained in a query, and customize your own output templates from there.

Last Update:

Added 'support' for SQL2012; that is, DBX now identifies SQL2012 DSNs without rejecting them as unsupported. Internally, these DSNs are treated like SQL2008 databases (post a bug if incompatibilities are found).


ColdFusion 6.1+
SQLServer 2000/2005/2008/2012

Issue Tracker:

6 cfusion_encrypt & cfusion_decrypt depricated in CF11 and later Open 12/09/16 8:43 AM
5 SQL*EXEC window prefills column and database names without brackets Fixed 11/18/08 11:20 AM
4 DBX won't run on sites listening on ports other than 80 Fixed 11/08/08 4:14 PM
3 Error after changing dbx.enckey Fixed 10/12/08 5:25 AM
2 SQLExec window javascript bug onload Fixed 09/25/08 8:34 AM

View All Issues

To enter issues for this (or any other) project, you must be logged in.