Recently we were having issues on our database server and after long efforts it was decided to change the database server. So we managed to restore the database on another server, change the connec...

I've mucked up my migrations, I used IgnoreChanges on the initial migration, but now I want to delete all my migrations and start with an initial migration with all of the logic. When I delete the...

I can use Drizzle kit to create and run schema changes to my database, but I don't know how to make data migrations with it. I've got experience from Django where you can manually create migration ...

I have a library that's part of a bigger project. The library uses its own schema in a (PostgreSQL) database shared with the larger project. I want to use alembic revision --autogenerate to only g...

I want to remove an app from a django project. I want to remove the tables of the app the content-types foreign-key usages of these content-types Running manage.py migrate app_to_remove zero d...

yekabathula-macbookair2:roster yekabathula$ python manage.py migrate Operations to perform: Synchronize unmigrated apps: staticfiles, messages Apply all migrations: admin, contenttypes, api, auth...

I want to rollback only : Rolled back: 2015_05_15_195423_alter_table_web_directories I run php artisan migrate:rollback, 3 of my migration are rolling back. Rolled back: 2015_05_15_195423_alter_ta...

I have a file db_table.py that looks like: from flask import Flask from flask_sqlalchemy import SQLAlchemy from flask_migrate import Migrate app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_...

Issue: In order to start in a clean environment for developing stuff for a web app I would appreciate to be able to retrieve some data from an existing DB (let say the 10 first lines of every table...

While setting up flyway i am getting this error in my spring-boot app org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class ...

I have a Django app named app1 with models and migrations files. I renamed this app to app2 and I fixed all imports, urls etc... I now have a problem with migrations files and data in tables. How c...

I'm having trouble getting Alembic to autogenerate candidate migrations from changes to classes using db.Model (Flask-SQLAlchemy) instead of Base. I've modified env.py to create my Flask app, impo...

Is there any library or tool to perform database migrations in python without SQLAlchemy? I am using a PostgreSQL database and the queries are raw SQL. I use psycopg2 for the database connection.

How to manage schema migrations for Google BigQuery, we have used Liquibase and Flyway in the past. What kind of tools can we use to manage schema modifications and the like (e.g. adding a new colu...

My application needs a pre registered data set to work. So i need to insert them in the database when i set up the application. Laravel propose two mechanisms : Database migrations : "They allow...

I have user_id fk column in my table $table->foreign('user_id')->references('id')->on('users'); I should add on cascade delete feature to this existing column. How can I do this?

I am considering using Flyway for versioning database migrations for my Spring Boot API. I have been reading lots of article about it and I find that they talk mostly about setting it up which is g...

I have a local database that is currently in it's second version and should now go to it's third version. The code for the previous migrations was generated by another programmer so I am assuming ...

I am considering using Liquibase for versioning database migrations for my Spring Boot API. I have been watching some videos about it before considering it and I find that they talk mostly about se...

I am working on a Rails 5.x application, and I use Postgres as my database. I often run rake db:migrate on my production servers. Sometimes the migration will add a new column to the database, and...

I have a problem with pushing my migrations to the production database. The issue: I've altered database schema by adding 1 column. I've migrated it to the production database: MacBook-Air-Mac:...

I've followed the following tutorial for creating a custom entity on my own in shopware 6: https://www.youtube.com/watch?v=mTHTyof4gPk I created a migration by using bin/console database:create-mig...

I'd like to write a data migration where I modify all rows in a big table in smaller batches in order to avoid locking issues. However, I can't figure out how to commit manually in a Django migrati...

I have a rails migration that is not being applied to my schema.rb. The migration should create a table: class CreateUserGraphs < ActiveRecord::Migration def change create_table :user_graphs ...

I've created a table using migration like this: public function up() { Schema::create('despatch_discrepancies', function($table) { $table->increments('id')->unsigned(); $table->integer...