Questions tagged [database-migration]
database-migration is the process of transferring data between storage types, formats, or computer systems. Also refers to migrating the database from one vendor to another, or to upgrading the version of the database software.
database-migration
4,378
questions
-2
votes
0
answers
19
views
I am getting "Error 1045 (28000): Access denied for user 'user'@'ip' (using password: YES)" when tried to update my rds password in gitea container
Scenario, using gitea with gitea image and mounted to an EFS.
Things I Have Done,
Changed My RDS Password, tried to connect with workbench, it worked
Stopped Running gitea container
Updated database ...
0
votes
0
answers
28
views
How to generate Liquibase changelogs with Quarkus using the Liquibase Hibernate extension?
I'm working on a Java application using Quarkus and I'm trying to generate Liquibase changelog files from my JPA entities. Previously, I have successfully used the Liquibase Hibernate extension with ...
0
votes
1
answer
38
views
Unable to perform migrations in .NET Core
The error which I am facing:
PM> update-database
Build started...
Build succeeded.
An error occurred while accessing the Microsoft.Extensions.Hosting services. Continuing without the application ...
0
votes
0
answers
27
views
How to Avoid Using --run-syncdb with python manage.py migrate
I am working on a Django project that I cloned from GitHub. When I try to run python manage.py migrate, it fails and requires me to use --run-syncdb. However, I want to make it so that python manage....
1
vote
0
answers
28
views
Data Migration of multiple tables from one database to other using Spring Boot and Spring Batch
I want to migrate from one database to other using Spring Batch and Spring Boot. I have learnt that we have to declare @Bean for step, Job, JobLauncher, ItemWriter, ItemReader. But for those beans to ...
0
votes
0
answers
30
views
Prisma Client Error: Column User.stripe_customer_id Does Not Exist in PostgreSQL Database
I'm encountering an error while using Prisma Client with a PostgreSQL database. The error message indicates that the column User.stripe_customer_id does not exist in the current database. Here are the ...
1
vote
0
answers
42
views
How to seed local DB from remote supabase DB
I have a supabase database. I've been doing development locally by directly connecting to the remote DB. I want to move to a local dev environment for the DB so that my remote DB does not get impacted....
0
votes
1
answer
70
views
Sonatype Nexus database migration from H2 in EC2 to external PSQL
I currently have a Sonatype Nexus instance running on an EC2 instance with the H2 database. I'm looking to migrate the database to PostgreSQL. Sonatype Nexus offers an in-built option only for the Pro ...
0
votes
1
answer
49
views
Apps without migrations must not have relations to apps with migrations. Why?
There is a vague paragraph in django docs:
Apps without migrations must not have relations (ForeignKey,
ManyToManyField, etc.) to apps with migrations. Sometimes it may work,
but it’s not supported.
...
0
votes
1
answer
46
views
azure flexible server migration failing with collation UTF8
we're testing migration of postgres running on a VM to azure flexible server using the migration option in the portal. On the validation it fails saying
Error 603401: Collation mismatch. Collation ...
0
votes
0
answers
26
views
How to solve transient error when migrating database using PowerShell/EF6 commands?
I am trying to create an Azure DevOps pipeline to migrate database using PowerShell and EF6. Here is my code:
steps:
- powershell: |
$binPath = {some-path}
$ef6Exe = $binPath + "\ef6.exe&...
2
votes
1
answer
39
views
Did I write data migration for data type change in a correct way?
Say, I have a model TestModel:
class TestModel(models.Model):
field1 = models.CharField(max_length=255)
field2 = models.IntegerField()
def __str__(self):
return f"{self....
0
votes
2
answers
69
views
Equivalent of ORACLE signature with bind variable IN PostgreSQL
I am in the process of migrating from Oracle to Postgres with Ora2pg but I find this problem that the signatures on the Postgres side do not exist
can you help me find the right solution ?
What will ...
0
votes
0
answers
15
views
How to migrate SQL Server data to another database with persisting identity keys? [duplicate]
I have a new database on Microsoft SQL Server 2019 Express.
The tables are:
CREATE TABLE tbl1SalesOrders (
SalesOrderID INT NOT NULL IDENTITY(1,1),
SalesOrderCode NCHAR(11) NOT NULL UNIQUE ...
0
votes
0
answers
17
views
flask db init command executing without end
I had ran the command initially at the start of my project. I accidentally ran it again at the end when I was trying to get the whole project to run.
I tried to remove the migration directory and ...