General
- Installation
- PLReader
- Quick start
- Improving PCT
- Changelog
- TestNG report (v9)
- TestNG report (v10)
- TestNG report (v10 64 bits)
Tasks
- PCT
- PCTRun
- PCTCompile!!UPDATED!!
- PCTCompileExt!!UPDATED!!
- PCTWSComp
- PCTCreateBase
- PCTDumpSchema
- PCTLoadSchema
- PCTDumpData
- PCTLoadData
- PCTDumpIncremental
- PCTBinaryDump
- PCTBinaryLoad
- PCTSchemaDoc
- PCTLibrary
- PCTProxygen
- PCTCRC
- PCTXCode
- PCTASBroker
- PCTWSBroker
- ProUnit
- PLExtract
- ProgressVersion
- PCTVersion !!UPDATED!!
Types
Selectors
PCTDumpIncremental task -- <pct:incr_dump />
Description
Creates a schema diff file between two databases. This is a wrapper around prodict/dump_inc.p from POSSENET code.
Parameters
| Attribute | Description | Type | Requirement | Default value |
|---|---|---|---|---|
| destFile | File containing the schema dump | File | Required | No default value |
| renameFile | The RenameFile parameter is used to identify tables, database fields and sequences that have changed names | File | Optional | No default value |
| debugLevel | DebugLevel (0, 1 or 2 (verbose)) | Integer | Optional | 0 |
| activeIndexes | If indexes should be created Active (true) or Inactive (false) | Boolean | Optional | True |
PCTDumpIncremental inherits attributes from PCT and PCTRun. However, PCTDumpIncremental must have two and only two PCTConnection. One database must have a dictdb alias, while the second one must have a dictdb2 alias.
Parameters as nested elements
NoneExamples
<PCTDumpIncremental destFile="incr.df">
<PCTConnection dbName="db1" singleUser="true">
<PCTAlias name="dictdb"/>
</PCTConnection>
<PCTConnection dbName="db2" singleUser="true">
<PCTAlias name="dictdb2"/>
</PCTConnection>
</PCTDumpIncremental>
Compares db1 to db2, and generates a diff named incr.df, which could be loaded into db2 to bring it to same schema as db1.