-
-
Notifications
You must be signed in to change notification settings - Fork 122
Description
I am using evolve to create schema, tables and some application meta data from CI/CD server. The migration script is spilt into two files , first one for creating schema and tables and the second sql file contains INSERT statements for the data. I am using the dotnet tool commands as below:
`evolve migrate postgresql -c "Server=${RDS_DB_HOST};Database=${USER_SERVICE_DB_NAME};User Id=${RDS_DB_ADMIN_USER};Password=${RDS_DB_ADMIN_PWD};" -l "$(pwd)/UserService/db-scripts/create-user-schema/" -p USER_SERVICE_DB_USER:${USER_SERVICE_DB_USER} -p USER_SERVICE_DB_PWD:${USER_SERVICE_DB_PWD} -p USER_SERVICE_DB_SCHEMA:${USER_SERVICE_DB_SCHEMA}
echo 'Finished migration of schema, functions and tables'
evolve migrate postgresql -c "Server=${RDS_DB_HOST};Database=${USER_SERVICE_DB_NAME};User Id=${RDS_DB_ADMIN_USER};Password=${RDS_DB_ADMIN_PWD};" -l "$(pwd)/UserService/db-scripts/create-user-data/" -p USER_SERVICE_DB_SCHEMA:${USER_SERVICE_DB_SCHEMA}
echo 'Finished migration of data'`
The first migration is applied successfully, schema and tables are created successfully. But the second migration gives error:
Validate failed: invalid checksum for migration: V1_0_0_0__Create_user_data.sql.
I tried using repair , it gives no error when I use repair, but it doesn't execute the sql script.
How can I resolve this issue ? I don't want to use a single sql file for the migration.