Sql Schema

AutoTag includes the program BuildSqlSchema.exe. You can use this program to create a schema file (by pointing it at a database) or create one by hand. Sample: schema.xml for Northwind database.

There are a couple of cases where this is a better way to connect to a database:

• If you only want to show a subset of the tables and/or columns in the database. Delete the ones your report designers will not use from the schema file before using it. (This does not stop designers from using those tables/columns in a select, it merely does not display them in the tag editor.)

• Hand code the PK:FK joins. AutoTag knows a path to join two tables, but it has no way of determing the best path.

• The database does not have complete metadata, it may be missing descriptions or PK:FK joins.

Schema File: the schema.xml file containing the connection and metadata information.

You create the schema using BuildSqlSchema