Qlik Replicate: How to export table structure from metadata into a diagnostic package

avidary_qlik — Mon, 31 Mar 2025 10:11:22 GMT

Repctl dumpmetadadqa is a command that retrieves the table structure from the Metadata folder.

The structure can provide helpful information about table changes between source and target or manifest the source and target DDL.

To achieve this:

Open a command line as an administrator (elevated permissions)
Move to ~ Attunity\Replicate\bin
Run:
```
repctl dumpmetadata sqlite_file="C:\Users\administrator\Downloads\Full Load Task and CDC - ANADDR__diagnostics__20250321170305\Metadata\dynamic_metadata.sqlite"
```
Make sure the path used is correct.

A successful command will return:

command dumpmetadata response:
{
"out_dir": "C:\\Users\\administrator\\Downloads\\Full Load Task and CDC - ANADDR__diagnostics__20250321170305\\Metadata\\20250324123730263852"
}
[dumpmetadata command] Succeeded
Browse to the newly created folder (example: Metadata\2025033112622103323)
Open the numbered folder (example: 2025033112622103323)
Open table_defs. Our example has returned the following tables:
Use an editor of your choice (example Notepad++) to compare the source and target tables:

article Qlik Replicate: How to export table structure from metadata into a diagnostic package in Official Support Articles