We are in process of setting up ETL and Business Objects for our new client. The database strcuture for this new client would be same as of our old client. So, we have copied the database structure of old client. We have also copied the entries/data in RoundHouse.ScriptsRun table. As a part of ETL code deployment script, we also run DB upgrade script. This DB upgrade script checks for the DB scripts from code base.
When the DB upgrade script is executed then we are getting error
one time script has changed since last run. Please donot change one-time scripts once it is executed
Is there a way we can skip the execution of one-time scripts whose entries are already present in RoundHouse.ScriptsRun table?
Note:
- The database structure that we copied has latest DB changes that we will be performing through one-time scripts. For the same reason, we want to skip the execution of one-time scripts
- I tried executing the script using --warnOnOneTimeScriptChanges=true setting but it executes the scripts again which is causing discrepancy in our database structure