294 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
195
views
How to use migration commands with Litestar?
I am trying to use migration commands with Litestar, but I keep encountering the error:
No such command 'database'.
I have configured my project with pyproject.toml, main.py, and models.user.py as ...
1
vote
1
answer
62
views
Wrong number of arguments in add_column() of sqlite3_adapter.rb
After an upgrade to RoR 3.4.2/8.0.2, migrating the db hits the following problem.
When running rake db:migrate, I see the following error:
...
== 20151121064619 AddUploadToEntries: migrating ==========...
0
votes
0
answers
43
views
Is there a way to create a migration that always runs in db-migrate, even if it has already been executed?
I'm using the db-migrate tool for managing database migrations in my project, and I need a way to ensure that a particular migration always runs, even if it has already been executed previously.
I ...
0
votes
1
answer
279
views
Spring dosn't run flyway migrations automatically
When I run migrations manually, everything is ok. but when running spring boot application, flyway does not apply automatically.
Is there other
configuration which must fix it?
I expect flyway ...
0
votes
0
answers
190
views
Exporting data from SQL server to PostgreSQL limited 100 records
I have a database in SQL Server, but now I must transfer to PostgreSQL.
I'm trying to the way:
Right-click on the database
Task/ExportData
Choose the database input enter image description here
...
1
vote
0
answers
261
views
Sybase to MSSQL migration: Lock Datarows while create table
I am migrating a Sybase DB to a SQL Server DB. I can see that existing Sybase tables have lock datarows or lock allpages specified along with create table statement something like this:
create table ...
1
vote
0
answers
1k
views
Mongodb 6.0 error: Unsupported OP_QUERY command: listCollections. The client driver may require upgrade [duplicate]
We are upgrading Node and Mongodb version for our applications. We have upgraded
Mongodb: 6.0.8
NodeJs Mongo Driver: 6.0.0
NodeJs: 18.17.0
db-migrate: 0.11.14
in migrations file we are declaring ...
1
vote
1
answer
3k
views
Flyway - why all my schemas were deleted and how can i revert it
I was running a db repair command on my db, and surpassingly found out later that for each old migration version a new DELETE migration was created.
It was only effecting the flyway_schema_history ...
1
vote
1
answer
535
views
How to make bit column like in SQL Server using Laravel Database Migration
So I'm creating a new table, replicating an existing table, and one of them has a column of type bit, like this:
I already understand the concept of migration and have made it often, but to create ...
0
votes
1
answer
416
views
Most efficient way to migrate a MySQL database while altering the primary key data type
Since MySQL 5.6 support is coming to an end next month, we are preparing for the migration.
The DB is hosted on AWS Aurora. If we are to simply upgrade the engine to 5.7, we could do it online (RDS ...
2
votes
0
answers
382
views
db-migrate and db-migrate-pg How to control order of migrations?
Is there a way to run only specific migration file using db-migrate, or to at least execute migrations in a specific order? Some workarounds would be to change the dates in migration file name, or to ...
0
votes
0
answers
40
views
Gems for rake DB
Good day
What I have add to gem file ?
And how install ?
TODONE:
added: gem 'rake', '0.8.7'
run: > bundle install
or run: > bundle install rake
All it's not work
Thank You
**Gemfile**
...
1
vote
1
answer
1k
views
What do the various columns in schema_version_history table of flyway represent?
I'm new to flyway & have been going through the documentation of flyway but couldn't find a doc which describes what each column in schema_version_history (or whatever you would have configured to ...
0
votes
1
answer
1k
views
How to store a return value of an SQL query inside a variable
Given a users and a roles table, I want to write an SQL statement, which inserts a new row into the users table and associates a row of the roles table with it.
This is what I have tried:
INSERT INTO ...
0
votes
1
answer
57
views
Intershop | dB migrate
"Address already in use" This is the error which I get while doing dbmigration, I have written the AddService and Addconfiguration properties file now wanted to do dbmigration and getting ...