dbscript Features

dbscript is an ASP.Net web application with a SQL Server database.

The main functionality covers:

Projects

  • Every piece of information is part of a Project
  • Project Versions contain database schema, version date, identifiers to bug tracker
  • Customers, Contacts, Installations of versions
  • Project branches
  • Update Notification Management

MSSQL source databases

  • Import and upload of database schemas
  • Script imported schemas
  • Script table values of databases
  • Generate scripts to script table values
  • Generate C# const or enum definitions based on table data
  • Generate VB.Net const definitions based on table data
  • Compare database schemas
  • Generate a database schema migration script from these comparisons
  • Comparison of multiple schemas, display as matrix or timeline
  • Generate XML-based documentation of database objects
  • Store T-SQL code snippets which can be run on accessible databases
  • Supports 2000 and higher

Oracle source databases (0.96)

  • Requires ODP.Net installed on web server
  • Import of database schemas
  • Generating XML-based documentation of database objects
  • Storing PL/SQL code snippets which can be run on accessible databases
  • Supports 10g and higher

PostgreSQL source databases (0.98)

  • Includes Npgsql client
  • Import of database schemas
  • Generating XML-based documentation of database objects
  • Storing PgSql code snippets which can be run on accessible databases
  • Developed with PostgreSQL 8.4

Documentation Generator

  • XML representation of database schemas
  • Supports pre-defined and user-generated XSL for documentation generation
  • Create MediaWiki documentation based on database schema
  • Create ScrewTurnWiki documentation based on database schema
  • Create Single HTML file documentation
  • Create Data Diagram from database schema (.png)
  • Create Dia Data Diagram from database schema
  • Built-in HTML documentation generator (single HTM, or TOC + selected object)
  • Create Word HTML documentation based on database schema

Users and Roles

  • Multi-user environment
  • Users can be assigned to multiple projects
  • Project Versions visible to other users based on tagging

dbscript up to version 1.02 requires IIS, .Net 2.0 with Ajax Control Toolkit installed, and a SQL Server 2000, 2005 or 2008.

dbscript from version 1.03 on requires IIS, .Net 3.5 SP1, and SQL Server 2000-2008.