Stack Overflow
Stack Overflow

Questions tagged [schema-migration]

Schema migration refers to altering the data schema used in an application. This may merely involve changing the database, but frequently also involves code alterations.

Schema migration refers to altering the data schema used in an application. This may merely involve changing the database, but frequently also involves code alterations.

Because the data schema is often relatively stable, and code usually embeds assumptions about it, schema-migration must be handled carefully.

64 questions
1
vote
1 answer

Is it possible to run Visual Studio Database Edition schema migrations from the command line?

Visual Studio 2008 Database Edition (Data Dude) has the ability to perform schema comparisons between databases and generate a script which migrates from one database to the other. Is it possible to perform this comparison and generate the migration…
Damian Powell
  • 8,655
  • 7
  • 48
  • 58
1
vote
1 answer

Django South: Auto schemamigration didn't work for adding ManyToMany

I am pretty new to south. I am working off of a friends project, and he seems to already have done some migrations. I have a model and I am trying to to add an additional ManyToMany field to it. This is the class with owned_geofences being the…
ApathyBear
  • 9,057
  • 14
  • 56
  • 90
1
vote
0 answers

How to deal with RDBMS breaking changes with Flyway?

Given an existing database that was setup using Flyway, and I want to migrate this database to the latest version of my RDBMS (ex. Postgres 9.2->9.3). If the database vendor changes something in its API and one of my already run migration now…
Patrick M
  • 166
  • 12
0
votes
1 answer

In Grails is it possible to configure database migrations plug in to run before other plugins?

I'm using the database migration plugin in my app but im having issues when using other plugins that have DB schema dependencies. I want to use the migrations plugin to setup / refactor my DB in preparation for using a freshly installed plugin…
tinny
  • 4,232
  • 7
  • 28
  • 38
0
votes
0 answers

Migration ran successfully but model not updated

I have faced an interesting case. What happened is that i recently switched to data_migrate gem for running migrations in my rails project. In my local system, everything works swiftly. On running migration the schema is updated successfully and the…
googlesnet
  • 85
  • 9
0
votes
1 answer

How does Flyway estimate the 10GB data limit for its BigQuery extension?

I am interested in Flyway's BigQuery extension and planning to use in an unfunded small project for schema migration. However, I couldn't find any details in term of how the 10GB data limit is being calculated. I have tried creating and updating a…
ann20502
  • 1
  • 2
0
votes
1 answer

What happens with the existing data if Decimals decimal_places are changed in a Django model?

I need to change a DecimalField from having decimal_places=0 to decimal_places=7 while keeping max_digits=50. I think all numbers in this column are between 0 and 1,000,000,000. So the data migration could be unproblematic. However, I'm uncertain. I…
Martin Thoma
  • 124,992
  • 159
  • 614
  • 958
0
votes
1 answer

Can't rollback a particular Alembic migration by revision ID

I am trying to do schema migration in PostgreSQL via Alembic. Following this question Undo last alembic migration I have 2 migrations with: revision = '0eb4bd9decb0',down_revision = None --and revision = 'bf34bf428845' ,down_revision =…
Anurag Dabas
  • 23,866
  • 9
  • 21
  • 41
0
votes
1 answer

Can Azure Migrate be used similarly to Flyway for schema migration?

Our team's application is in early development and will be using our application for usage/testing purposes. There'll be changes in our SQL schema that will require dealing with schema migrations. While I know that Liquidbase and Flyway are good…
Joseph Woolf
  • 500
  • 5
  • 14
0
votes
0 answers

trying to convert ORACLE code into POSTGRESQL

ls_sql := (CONCAT_WS('', ' SELECT INITCAP( CASE WHEN (TRIM(STREET_NUMBER) IS NOT NULL) THEN TRIM(STREET_NUMBER)||'' '' END)|| …
Bilal Shaikh
  • 47
  • 5
0
votes
1 answer

Is there any standard tools to update MongoDB collections with Spring Boot during start-up?

I use flyway or liquibase to manage my schema and to update some table in application during start-up. I wondering if there is some way to update mongodb collections during start-up? I want to add one new field to collection and provide a value for…
Oleh Kurpiak
  • 1,339
  • 14
  • 34
0
votes
0 answers

SSDT doesnt see table schema changed

I suddenly felt into issue when schema which I have edited for table doesnt applied on server. Found that out when wrote seed script and it crashed: I've changed most fields to null so script inserts only NOT NULL values. But in runtime it crashes…
DevOvercome
  • 151
  • 1
  • 12
0
votes
0 answers

Schemamigration runs for existing columns in the application

Assume I am having a Django app named animals. The app has a model named "mammal" as below class Mammal(models.Model) name = models.CharField(max_length=256) is_active = models.BooleanField(default=True) date_added =…
Fahim Ahmed
  • 397
  • 4
  • 16
0
votes
0 answers

Rails 4 - Remove all traces of a previously used Active Record database

This is the Log. ActiveRecord::SchemaMigration Load (5.0ms) SELECT `schema_migrations`.* FROM `schema_migrations` Unable to load samplero, underlying cause No such file to load -- samplero org/jruby/RubyKernel.java:1065:in…
vishless
  • 829
  • 1
  • 5
  • 28
0
votes
1 answer

South not recognizing added model field?

My teammate and I have been using South for a little bit now with very minimal problems. We now just hit an issue where South isn't recognizing our added model field. When I run ./manage.py schemamigration appname --auto I keep getting "Nothing…
Sweetman
  • 75
  • 1
  • 9
1 2 3
4
5