Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sync multiple tables #43

Open
huangkai31 opened this issue Dec 13, 2021 · 4 comments
Open

sync multiple tables #43

huangkai31 opened this issue Dec 13, 2021 · 4 comments
Labels
enhancement New feature or request

Comments

@huangkai31
Copy link

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 osalvador added the enhancement New feature or request label Dec 20, 2021
@osalvador
Copy link
Owner

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
Copy link
Author

--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
Copy link

Trippik commented Oct 13, 2022

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

@prensgold
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

4 participants