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

[avidary_qlik]

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:

1. Open a command line as an administrator (elevated permissions)
2. Move to ~ Attunity\Replicate\bin
3. 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
   
   
   
   
4. Browse to the newly created folder (example: Metadata\2025033112622103323)
   
   
   
   
5. Open the numbered folder (example: 2025033112622103323)
   
   
   
   
6. Open table_defs. Our example has returned the following tables:
   
   
   
   
7. Use an editor of your choice (example Notepad++) to compare the source and target tables:
   
   
   
   

Environment

• Qlik Replicate