Red Gate forums :: View topic - SQL Doc project files.
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

SQL Doc project files.

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
david connell

Joined: 21 Nov 2005
Posts: 207

PostPosted: Mon Feb 26, 2007 1:20 pm    Post subject: SQL Doc project files. Reply with quote

The SQL Doc project files.
Please note that if you incorrectly edit this file directly you may not be able to document your database again using this project file. The structure documented here maybe altered in future versions of SQL Doc.

The project files for SQL Doc are outputted in XML and has the following structure

<?xml version="1.0" encoding="utf-16"?>
<Project Database="WidgetStaging2005">
    <Database >

As you can see the basic structure is based around a Project which has several attributes. Each Project consists of Items and ObjectExclusions (objects excluded). The Items itself is a collection of databases which in turn have a collection of objects.
In this document I will only describe the attributes for the Project.

SQL Doc 1.0 Features
    Version-Version of the XML format. Currently 1
    Author-Name of Author
    Copyright-Copyright details
    URL-URL link
    HtmlPath-Path to the generated output
    ProjectDescription-Description of the project displayed on the front page
    Treeview-Specifies if to generate a tree view or not
    OutputStyle-StandardHTML/FramedHTML/ CompiledHelpThe generated format
    Server-the default Sever name
    Database-the default Database name
    IntegratedSecurity-True or false
    Username-The user name if not using integrated security
    paswword-The password for the username
    AllowEditing-True or false enabling the editing of the descriptions
    ApproxVals-Number of database objects
    Forced-Over-write previously generated output

SQL Doc 1.1 Features
    AutoAppend-True or false to specify if the server name/date is auto added to the generated path.
    IncludeSQLScript-Include SQL Scripts in generated output
    IncludeTriggers-Include Table/View Triggers in generated output
    IncludeIndexes-Include Indexes in generated output
    IncludeForiegnKeys-Include Foreign Keys in generated output
    IncludePermissions-Include Permissions in generated output
    ThemeName-The name of the theme. The name must match the folder name under %Program Files%\Red Gate\SQL Doc 1\Style1\Skins
    NewDatabaseObjects-Enabled/Disabled. Specifies if new items to this documentation are automatically enabled or disabled.

SQL Doc 1.2 Features
    IncludeFullIndexInfo-Specifies if indexes are given their own page.
Back to top
View user's profile Send private message

Joined: 01 Oct 2008
Posts: 8

PostPosted: Wed Oct 01, 2008 3:04 pm    Post subject: xsd schema Reply with quote

I'm very surprised to see the chosen xml tag naming conventions (Object0..., Object1..., Object2...). This makes it impossible to provide a schema - and I'd be amazed if there was a valid technical reason for this choice(?).

Any plans to remedy this?

(Also foreign is spelled incorrectly (foriegn) )-: )
David McKinney
Back to top
View user's profile Send private message

Joined: 14 Dec 2007
Posts: 98

PostPosted: Thu Oct 02, 2008 11:17 am    Post subject: Reply with quote


Thanks for your post. At the moment, we are not planning on changing the project file format.

I am interested in hearing why you would like a schema for the project file? Is there anything particular you would like to be able to do?


Back to top
View user's profile Send private message

Joined: 01 Oct 2008
Posts: 8

PostPosted: Thu Oct 02, 2008 12:37 pm    Post subject: Reply with quote

No particular reason.

In this post you publish a 'description' of the xml file. IMO Normal practice would be to publish the schema.

Among the benefits of the schema approach is that if you do make modifications to the xml and it subsequently doesn't work, you can validate against the xsd schema, and often this will tell you where you've broken it. (Depending on the tool, you may also benefit from intellisense etc..)

But basically I just find it a very bizarre design choice, which is hard to explain.
David McKinney
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group