Category "database-migration"

Upgrading Solr from 6.x to 8.x and Keeping the data

I'm trying to upgrade from Solr 6.x to 8.x and I'm facing an issue of keeping/saving/importing the old data that I've had. The approaches I tried using the same

Data Synchronisation in Blue Green Deployment - Cloud

In a blue green deployment environment, I'm trying to use two separate database for each environment. In this case, How does realtime data synchronisation could

Add-Migration not adding column to existing table in Entity Framework Core

I am trying to add a new column to my existing table in database, i am specifying new field into class and running Add-Migration command but everytime it is cre

Access denied for user 'homestead'@'localhost' (using password: YES)

I'm on a Mac OS Yosemite using Laravel 5.0. While in my local environment, I run php artisan migrate I keep getting : Access denied for user 'homestead'@'local

Default row order in SELECT query - SQL Server 2008 vs SQL 2012

Our team recently upgraded our databases from SQL Server 2008 to SQL Server 2012. One breaking change we noticed was in the default order of rows returned by th

Mark an individual Doctrine migration as ran/executed

Is there a way that I can mark a Doctrine migration as "ran" or "executed" in the way that it won't be shown as a migration that needs to be migrated? app/cons

How to define a default value for a column after a cast in a pgloader script?

Let's say I'm migrating a MySQL database to PostgreSQL with pgloader, using the default sample on the official website: load database from mysql://

Running migrations with Rails in a Docker container with multiple container instances

I've seen lots of examples of making Docker containers for Rails applications. Typically they run a rails server and have a CMD that runs migrations/setup then

TypeORM migration results in PostgreSQL error

I am having an issue running migrations with TypeORM (with the intent of establishing my database for use in local development). In running a migration on the i

ETL Migration Solution for OceanBase to Aurora

I am looking for an ETL solution that has all the necessary components with limited hand-coding that helps to migrate data from Oceanbase DB to AWS aurora. I tr

deploying Prisma with Nuxt on heroku

I have spend several days now trying to figure out why my back-end is not working on the online version of my app. I created a Nuxt project that uses Prisma for