activiti 把数据库中8月份的数据导入到另外一个库中

act_ru_task
SELECT * FROM act_ru_task WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31'

act_ru_variable
SELECT * from act_ru_variable WHERE PROC_INST_ID_ in (SELECT PROC_INST_ID_ FROM act_ru_task WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31')


SELECT * from act_ru_variable WHERE TASK_ID_ in (SELECT ID_ FROM act_ru_task WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31')

act_ru_identitylink
SELECT * FROM act_ru_identitylink WHERE PROC_INST_ID_ in (SELECT PROC_INST_ID_ FROM act_ru_task WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31')

SELECT * from act_ru_identitylink WHERE TASK_ID_ in (SELECT ID_ FROM act_ru_task WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31')

act_ru_execution
SELECT * FROM act_ru_execution WHERE PROC_INST_ID_ in (SELECT PROC_INST_ID_ FROM act_ru_task WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31')

act_hi_varinst
SELECT * FROM act_hi_varinst WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31'

act_hi_taskinst
SELECT * FROM act_hi_taskinst WHERE START_TIME_ >= '2019-08-01'  and START_TIME_ <= '2019-08-31'

act_hi_identitylink
SELECT * FROM act_hi_identitylink WHERE PROC_INST_ID_ in (SELECT PROC_INST_ID_ FROM act_hi_taskinst WHERE START_TIME_ >= '2019-08-01'  and START_TIME_ <= '2019-08-31')

SELECT * FROM act_hi_identitylink WHERE TASK_ID_ in (SELECT ID_ FROM act_hi_taskinst WHERE START_TIME_ >= '2019-08-01'  and START_TIME_ <= '2019-08-31')

act_hi_procinst
SELECT * FROM act_hi_procinst WHERE START_TIME_ >= '2019-08-01'  and START_TIME_ <= '2019-08-31'

act_hi_comment
SELECT * FROM act_hi_comment WHERE PROC_INST_ID_ in (SELECT PROC_INST_ID_ FROM act_hi_procinst WHERE START_TIME_ >= '2019-08-01'  and START_TIME_ <= '2019-08-31')

act_hi_actinst
SELECT * FROM act_hi_actinst WHERE START_TIME_ >= '2019-08-01'  and START_TIME_ <= '2019-08-31'


====================================
如何8月份没有动流程下面的操作不需要进行
act_re_model
SELECT * FROM act_re_model WHERE CREATE_TIME_ >= '2019-08-01'  and CREATE_TIME_ <= '2019-08-31'

act_re_deployment
SELECT * FROM act_re_deployment WHERE DEPLOY_TIME_ >= '2019-08-01'  and DEPLOY_TIME_ <= '2019-08-31'

act_re_procdef
SELECT * FROM act_re_procdef WHERE DEPLOYMENT_ID_ in (SELECT ID_ FROM act_re_deployment  WHERE DEPLOY_TIME_ >= '2019-08-01'  and DEPLOY_TIME_ <= '2019-08-31')

act_ge_bytearray
SELECT * FROM act_ge_bytearray WHERE DEPLOYMENT_ID_ in (SELECT ID_ FROM act_re_deployment  WHERE DEPLOY_TIME_ >= '2019-08-01'  and DEPLOY_TIME_ <= '2019-08-31')