Qlik Replicate Select ALL Tables in a Database

[janezhang401]

From UI, it is easy to select all tables.

However, if I manually input a json task file, is there a way to define migrating all tables? Instead of adding a list of tables to "explicit_included_tables"?

[Heinvandenheuvel · Accepted solution]

It is essentially just an 'include *'. 

If unsure about the syntax just use the GUI to set it up and export task to see the result.

No need to list all tables.

Hein

...
"source":	{
  "rep_source":	{
    "source_name":	"Oracle_Source",
    "database_name":	"Oracle_Source"
    },
  "source_tables":	{
    "name":	"Oracle_Source",
    "included_pattern":	[{
	"owner":	"ATT_USER",
	"name":	"%"
	}]
    }
},
"targets":	[{  ...