Project Home • Forums • Known Issues • Screenshots • External Project Link • Contact Project
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.
- added display of column descriptions inline
- update null handling syntax in cfqueryparam
- added a 600 second requesttimeout
- fixed bug in table index listing where included columns were inaccurate
- improved indexes report
- enhanced index usage tuning results
- added sorting to columns table
- updated tuning permissions check for versions > 2008
- updated automated dsn gathering for lucee compatibility; may come at the expense of some older ACF compatibility
ColdFusion 6.1+, Railo, Lucee
To enter issues for this (or any other) project, you must be logged in.
Adobe and the Adobe product names are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.