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.