database Section

Database configuration

Parameter Name

Required

Default

Description

type

Yes

MsSqlServer2000

Specifies the type of database. Valid values are:

  • MsSqlServer7
  • MsSqlServer2000
  • MsSqlServer2005
  • MsSqlServer2008
  • Oracle8
  • Oracle9
  • Oracle10
  • Oracle11

connectionString

Yes

N/A

An ADO.NET connection string to use with the specified DB type (or default if none is specified). The default provider is MSSQL and the connection string must be useable by the System.Data.SqlClient.SqlConnection class. Consult the .NET framework documentation for specifics about what parameters are allowed in the connection string. Please consult the documentation for other ADO.NET providers if you plan on using a different data provider type (like Oracle or Sybase).

<!-- Sample MSSQL Database Connection String -->
<connectionString>Data Source=databaseServer; Initial Catalog=databaseName; User Id=userName; Password=password;</connectionString>
 
<!-- Sample Oracle Database Connection String -->
<connectionString>Data Source=databaseSID;user id=userName;password=password; </connectionString>

ignoreViews

No

 

Allows for certain views in the database to be ignored. Refer to the ignoreViews Object for details and an example.

See Also

.SchemaEditor files

inputFilePath Section

exportFilePath Section

reportFilePath Section

oracleDropColumnStrategy Section

storageLocations Section

ignoreViews Section

Next

inputFilePath Section

database Section