Login

    Register

Managed Hosting

PROJECT CATEGORIES

 

DBX
Project Home Forums Known Issues Screenshots External Project Link Contact Project

Author: Kevin Miller (All RIAForge projects by this author)
Last Updated: February 25, 2015 2:58 PM
Version: 10.1.13
Views: 55,795
Downloads: 2,667
License: Apache License, Version 2

Description:

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).

Requirements:

ColdFusion 6.1+
SQLServer 2000/2005/2008/2012

Issue Tracker:

ID ISSUE STATUS UPDATED
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
1 MS SQL error - fulltext error Fixed 11/29/07 2:11 AM

View All Issues

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