4,386 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Score of -3
0 answers
42 views
Problem facing while migration Data NAV16 to NAV16 in the Database [closed]
I’m currently working on a Microsoft Dynamics NAV 2016 to NAV 2016 data migration project, and I’m facing a challenge where I’d really appreciate some guidance from people who have handled similar ...
- reputation score 1
Score of 0
1 answer
142 views
Spring boot: flyway: Schema validation: missing table [products]
I was trying to integrate flyway to do migrations and now I am stuck at an error. I think it basically says Schema validation: missing table [products]. I have 2 .sql files under resources/db. I kept ...
- reputation score 3
Best practices
0
votes
3
replies
128
views
Is it safe to auto-generate Alembic migrations in CI/CD pipeline for a shared database?
I have a Python application using Postgres. The application connects to a shared AWS-hosted database for development.
I’m considering introducing a workflow where:
During the CI/CD pipeline run, ...
- reputation score 23
Advice
1
vote
3
replies
90
views
How to migrate existing custom versioning (validFrom/validUntil) to MariaDB system versioning?
I have a MariaDB 11.8.6 database with 142 tables.
Most tables have two additional columns:
validFrom DATETIME(3) - tracks when the record was created.
validUntil DATETIME(3) - tracks when the record ...
- reputation score 87
Best practices
0
votes
1
replies
102
views
Oracle TRUNC(date) vs PostgreSQL TRUNC(numeric) behavior in jOOQ (3.19.6) — better approach than rewriting via parserListener?
I'm currently working on a migration from Oracle Database to PostgreSQL using jOOQ (version 3.19.6), and I’ve run into a behavioral difference with the TRUNC function.
Problem
In Oracle, TRUNC is ...
- reputation score 61
Score of 0
1 answer
78 views
Drop foreign key constraint and add new columns
I'm having an error with dropping a foreign key constraint column and add a new columns. The error says that the column doesn't exists from the table. How to fix this error?
Syntax error or access ...
- reputation score 41
Score of 0
0 answers
37 views
SQLAlchemy create_all() does not add new columns to existing SQLite tables [duplicate]
I added a new column to an existing SQLAlchemy ORM model in an SQLite-backed application.
My model:
class User(Base):
__tablename__ = "users"
id = Column(String(36), primary_key=True)...
- reputation score 37
Score of 0
0 answers
41 views
Manual edits to Alembic migration file are not being implemented
I am attempting to include manual updates to an Alembic-generated migration file for my SQLite database. In models.py tables are defined. The update of the auto-generated table works however, I want ...
- reputation score 1
Advice
0
votes
2
replies
82
views
Migrating ServiceNow On-Prem DB from MariaDB to PostgreSQL during ITOM implementation
I am currently implementing ITOM (Discovery and Service Mapping) on a Self-Hosted (On-Premises) ServiceNow instance. The current backend is MariaDB, and we are planning a migration to a different DB ...
- reputation score 23
Score of 0
0 answers
73 views
Why did the project show a problem with SeedData Migration during run?
I added the model and its SeedData. There was no problem while adding the migration or updating the database. The SeedData was also saved to the database without any problems. But during the project ...
- reputation score 11
Score of 0
0 answers
31 views
Error message when doing Update-Database in Blazor using VIsual Studio [duplicate]
when I run Update-Database command after creating a new migration, I get the following error:
Introducing FOREIGN KEY constraint 'FK_Booking_Employee_EmployeeId' on table 'Booking' may cause cycles or ...
- reputation score 9
Advice
0
votes
0
replies
88
views
How apply airflow db migration and save them into postgress docker image?
I use docker-compose to run airflow. Postgres section is
postgres:
image: postgres:12.16
environment:
- POSTGRES_USER
- POSTGRES_PASSWORD
- POSTGRES_DB
healthcheck:
test: [ "...
- reputation score 34078
Score of 1
0 answers
81 views
WaveMaker 9.4 to 10.6.6 Migration: Type Mismatch Errors (Integer to BigInteger) in Generated Java Code
Problem Summary
I'm attempting to migrate a WaveMaker project from version 9.4 to 10.6.6 and encountering persistent compilation errors related to type mismatches between Integer and BigInteger in the ...
- reputation score 11
Score of 0
1 answer
207 views
How to squash multiple DDL migrations into one script in Flyway Community Edition?
I’m using Flyway Community Edition and want to squash a long chain of DDL migrations into a single script to simplify migration history.
I’d like to remove the old DDL files, but we already have ...
- reputation score 1
Score of 1
1 answer
93 views
Django migration successfully applied, but the database is not modified
I need to use a secondary SQLite database in a new Django project. This database is on the local filesystem but outside the Django folder. Its path is specified in a .env file at the root of the ...
- reputation score 1648