Ability to specify database_sql_queries.xml file to execute for UploadTool
Hi. We have multiple databases that we want to update periodically with UploadTool.
I generate own database_sql_queries.xml file for every database.
What I want is to be able to specify file to execute like:
./bin/UploadFromDB.sh ~/sql_xml_files/database_sql_queries_organization_123.xml
As I understand, what I can do right now is to either replace conf/database_sql_queries.xml file after previous import completes and start import again or duplicate whole UploadTool folder each with own database_sql_queries.xml and start import for every instance.
It is clear that both solutions are not appropriate and not possible to automate.
How would you suggest to solve that?
I generate own database_sql_queries.xml file for every database.
What I want is to be able to specify file to execute like:
./bin/UploadFromDB.sh ~/sql_xml_files/database_sql_queries_organization_123.xml
As I understand, what I can do right now is to either replace conf/database_sql_queries.xml file after previous import completes and start import again or duplicate whole UploadTool folder each with own database_sql_queries.xml and start import for every instance.
It is clear that both solutions are not appropriate and not possible to automate.
How would you suggest to solve that?