sync multiple tables

[huangkai31]

suggest: --source-table support multiple tables separate with comma --source-table support * or regular expressions like [a-z].* --source-table support another option file, which contains table names separate with comma like table1,table2,table3

[osalvador]

Hi @huangkai31,

--source-table support multiple tables separate with comma. This is something I have been thinking about for some time. --source-table with wildcard, perhaps only valid for replicating complete schemas. Querying the source schema objects with regular expressions depends on the source database capabilities. --source-table support another option file, which contains table names separate with comma like table1,table2,table3. Perhaps the same as the first option, do you have any particularly useful use cases?

Many thanks for your suggestions. Regards!

[huangkai31]

--source-table support another option file this is a brain storm, I don't have a use case yet. In my imagination , it's like i have more than 100 tables need to replica, some table need to replicate in hours, some in days, so I can use different files to store the table names, pass the table file name, and reuse other options

[Trippik]

Hey there, really liking the tool, is there any roadmap for this?

[prensgold]

Hi @huangkai31,

--source-table support multiple tables separate with comma. This is something I have been thinking about for some time. --source-table with wildcard, perhaps only valid for replicating complete schemas. Querying the source schema objects with regular expressions depends on the source database capabilities. --source-table support another option file, which contains table names separate with comma like table1,table2,table3. Perhaps the same as the first option, do you have any particularly useful use cases?

Many thanks for your suggestions. Regards!

for moving multiple tables; in the background ; 1* transfer more than one typed tables to a temp text. 2* Then, to run the tables written in temp text one by one for your current application with a for loop. Here, it can be run for more than one table at the same time with thread logic to speed up the process. Is it possible to add this stream to your app? I think this will make your app even more useful.