You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: