Difference between revisions of "Samples"

From dbscript Online Help
Jump to: navigation, search
(→‎MediaWiki content created by dbscript)
(→‎Generated Documentation)
 
(22 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
|align="center"| '''Oracle
 
|align="center"| '''Oracle
 
|align="center"| '''PostgreSql
 
|align="center"| '''PostgreSql
 +
|align="center"| '''edmx
 
 
 
|- valign="top"
 
|- valign="top"
 
| dbscript HTML
 
| dbscript HTML
−
|align="center"| ✓
+
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=14]
−
|
+
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=18]
 +
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=16]
 
|
 
|
  
 
|- valign="top"
 
|- valign="top"
 
| dbscript Single HTML
 
| dbscript Single HTML
−
|align="center"| ✓
+
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=15]
−
|
+
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=19]
−
|
+
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=17]
 +
|align="center"| [http://update.devio.at/doc/default.aspx?dgoid=21] [http://update.devio.at/doc/default.aspx?dgoid=22]
  
 
|- valign="top"
 
|- valign="top"
 
| HTML (single file)
 
| HTML (single file)
−
|align="center"| ✓
+
|align="center"| [http://static.devio.at/AdvWorks.html]
−
|align="center"| ✓
+
|align="center"| [http://static.devio.at/Oracle-Demo-Schema.html]
−
|align="center"| ✓
+
|align="center"| [http://static.devio.at/OpenNMS.html]
 +
|align="center"| [http://static.devio.at/AdventureWorks2005ef1.TableMappings.html] [http://static.devio.at/AdventureWorks2005ef1.TableColumnMappings.html]
  
 
|- valign="top"
 
|- valign="top"
Line 31: Line 35:
 
|align="center"| [[Oracle Demo Schema]]
 
|align="center"| [[Oracle Demo Schema]]
 
|align="center"| [[OpenNMS 090807‎]]
 
|align="center"| [[OpenNMS 090807‎]]
 +
|align="center"| [[AdventureWorks Table Mappings EF1|Table Mappings]] [[AdventureWorks Table+Column Mapping EF1|Table+Column Mappings]]
  
 
|- valign="top"
 
|- valign="top"
Line 37: Line 42:
 
|align="center"| [http://screwturn.devio.at/Database_Objects_Oracle_Demo_Schema.ashx]
 
|align="center"| [http://screwturn.devio.at/Database_Objects_Oracle_Demo_Schema.ashx]
 
|align="center"| [http://screwturn.devio.at/Database_Objects_OpenNMS.ashx]
 
|align="center"| [http://screwturn.devio.at/Database_Objects_OpenNMS.ashx]
 +
|
  
 
|- valign="top"
 
|- valign="top"
 
| ScrewTurn Wiki (V3)
 
| ScrewTurn Wiki (V3)
 +
|align="center"| [http://screwturn3.devio.at/Database%20Objects%20AdventureWorks.ashx]
 +
|align="center"| [http://screwturn3.devio.at/Database%20Objects%20Oracle%20Demo%20Schema.ashx]
 +
|align="center"| [http://screwturn3.devio.at/Database%20Objects%20OpenNMS.ashx]
 +
|
  
 
|- valign="top"
 
|- valign="top"
 
| Word HTML
 
| Word HTML
 +
|align="center"| [http://static.devio.at/AdvWorks.html.doc]
 +
|align="center"| [http://static.devio.at/OracleDemoSchema.html.doc]
 +
|align="center"| [http://static.devio.at/OpenNMS.html.doc]
 +
|align="center"| [http://static.devio.at/AdventureWorks2005ef1.TableMappings.html.doc] [http://static.devio.at/AdventureWorks2005ef1.TableColumnMappings.html.doc]
 +
 +
|- valign="top"
 +
| Code
 +
|
 +
|
 +
|
 +
|align="center"| [[AdventureWorks EntityNames EF1|EntityNames]]
 +
|}
  
 +
== Generated Data Diagrams ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''
 +
|align="center"| '''MS SQL Server
 +
|align="center"| '''Oracle
 +
|align="center"| '''PostgreSql
 +
 +
|- valign="top"
 +
| PNG
 +
|align="center"| [http://www.devio.at/images/mie55-dbscript-dd.png MS AdventureWorks]
 +
|align="center"| [http://www.devio.at/images/ora10g-demo-schema-096.png Oracle Demo Schema]
 +
|align="center"| [http://www.devio.at/images/opennms-dbscript-098.png OpenNMS]
 +
 +
|- valign="top"
 +
| Dia
 +
|align="center"| [http://www.devio.at/images/adventureworks_@mie_090830.compressed.dia MS AdventureWorks 2005]
 +
|align="center"| [http://www.devio.at/images/Oracle%20Demo%20Schema%20v090824.compressed.dia Oracle Demo Schema]
 +
|align="center"| [http://www.devio.at/images/OpenNMS_090807.compressed.dia OpenNMS]
 
|}
 
|}
 +
  
 
== Samples (MSSQL) ==
 
== Samples (MSSQL) ==
Line 63: Line 106:
  
 
=== ScrewTurn Wiki content created by dbscript ===
 
=== ScrewTurn Wiki content created by dbscript ===
−
 
−
[http://screwturn.devio.at/Database_Objects_AdventureWorks.ashx Automatically generated documentation of AdventureWorks 2005]
 
  
 
[http://screwturn.devio.at/AdventureWorks-dbscript.ashx ScrewTurn Wiki Page Provider Documentation of MS AdventureWorks database]
 
[http://screwturn.devio.at/AdventureWorks-dbscript.ashx ScrewTurn Wiki Page Provider Documentation of MS AdventureWorks database]
−
 
−
=== Other documentation formats ===
 
−
 
−
[http://www.devio.at/images/mie55-dbscript-dd.png Data Diagram of MS AdventureWorks database]
 
−
 
−
[http://www.devio.at/images/aw-mie55-2.html Documentation of MS AdventureWorks 2005 as Single HTML File]
 
−
 
−
[http://static.devio.at/AdvWorks2008-05-oltp.instawdb.sql.html Documentation of MS AdventureWorks 2008-05 as Single HTML File]
 
−
 
−
== Samples (Oracle) ==
 
−
 
−
[http://www.devio.at/images/ora10g-demo-schema-096.png Data Diagram of Oracle Demo Schema database]
 
−
 
−
[http://www.devio.at/images/ora10g-demo-v090502.html Documentation of Oracle Demo Schema as Single HTML File]
 
−
 
−
[[Oracle Demo Schema]]
 
−
 
−
[http://screwturn.devio.at/Database_Objects_Oracle_Demo_Schema.ashx ScrewTurn wiki documentation of Oracle Demo Schema]
 
−
 
−
== Samples (PostgreSQL) ==
 
−
 
−
[http://www.devio.at/images/opennms-dbscript-098.png Data Diagram of OpenNMS database]
 
−
 
−
[[OpenNMS 090807|OpenNMS Database Schema]]
 
−
 
−
[http://www.devio.at/images/opennms.html OpenNMS in Single HTML file]
 
−
 
−
[http://screwturn.devio.at/Database_Objects_OpenNMS.ashx ScrewTurn wiki documentation of OpenNMS]
 
−
 
−
== Data Diagrams for Dia ==
 
−
 
−
[http://www.devio.at/images/adventureworks_@mie_090830.compressed.dia MS AdventureWorks 2005]
 
−
 
−
[http://www.devio.at/images/OpenNMS_090807.compressed.dia OpenNMS]
 
−
 
−
[http://www.devio.at/images/Oracle%20Demo%20Schema%20v090824.compressed.dia Oracle Demo Schema]
 

Latest revision as of 12:11, 11 July 2010

Generated Documentation[edit]

MS SQL Server Oracle PostgreSql edmx
dbscript HTML [1] [2] [3]
dbscript Single HTML [4] [5] [6] [7] [8]
HTML (single file) [9] [10] [11] [12] [13]
MediaWiki Database Objects AdventureWorks Oracle Demo Schema OpenNMS 090807‎ Table Mappings Table+Column Mappings
ScrewTurn Wiki (V2) [14] [15] [16]
ScrewTurn Wiki (V3) [17] [18] [19]
Word HTML [20] [21] [22] [23] [24]
Code EntityNames

Generated Data Diagrams[edit]

MS SQL Server Oracle PostgreSql
PNG MS AdventureWorks Oracle Demo Schema OpenNMS
Dia MS AdventureWorks 2005 Oracle Demo Schema OpenNMS


Samples (MSSQL)[edit]

Sample: C# const declaration

Sample: VB.Net const declaration

MediaWiki content created by dbscript[edit]

Object Script - Columns - XML - MediaWiki Table (short)

Object Script - Columns - XML - MediaWiki Table DocGen

ProjectVersion Script - XML - MediaWiki ProjectVersion overview

Value Script - XML - MediaWiki ValueScript DocGen

ScrewTurn Wiki content created by dbscript[edit]

ScrewTurn Wiki Page Provider Documentation of MS AdventureWorks database

Retrieved from "http://dbshelp.devio.at/index.php?title=Samples&oldid=2911"