Questions tagged [migrate]
Migration is the process of moving data from container to another. This includes migration to and from physical containers (e.g. hard disks) and migration to and from logical containers.
migrate
1,111
questions
343
votes
8
answers
924k
views
Copy tables from one database to another in SQL Server
I have a database called foo and a database called bar. I have a table in foo called tblFoobar that I want to move (data and all) to database bar from database foo. What is the SQL statement to do ...
- 6,039
299
votes
16
answers
332k
views
Moving Git repository content to another repository preserving history
I am trying to move only the contents of one repository (repo1) to another existing repository (repo2) using the following commands:
git clone repo1
git clone repo2
cd repo1
git remote rm origin
git ...
- 3,033
129
votes
7
answers
269k
views
How do you migrate an IIS 7 site to another server?
I'm wondering what is the best practice for moving a website to another server (along with all settings, etc.)
Manually recreate the site on the new server (not maintainable for obvious reasons)
Copy ...
- 22.6k
74
votes
3
answers
114k
views
How to force migrations to a DB if some tables already exist in Django?
I have a Python/Django proyect. Due to some rolls back, and other mixed stuff we ended up in a kind of odd scenario.
The current scenario is like this:
DB has the correct tables
DB can't be rolled ...
- 953
72
votes
15
answers
99k
views
Django: dependencies reference nonexistent parent node
When I run the following command
python manage.py migrate
I receive this error from django so can't step forward in my practice:
Traceback (most recent call last):
File "manage.py", line 10, in &...
- 4,080
66
votes
4
answers
42k
views
How to efficiently manage frequent schema changes using sqlalchemy?
I'm programming a web application using sqlalchemy. Everything was smooth during the first phase of development when the site was not in production. I could easily change the database schema by simply ...
- 7,664
51
votes
9
answers
40k
views
SyntaxError: Generator expression must be parenthezised / python manage.py migrate
I'm really new in programming and I wanted to follow the Djangogirls tutorial, but I'm stucked now.
In the tutorial, I am here:
To create a database for our blog, let's run the following in the ...
- 511
43
votes
28
answers
147k
views
"no such table" exception
In Django I added models into models.py. After manage.py makemigrations, manage.py migrate raised this exception:
django.db.utils.OperationalError: no such table: auth_test_usertranslatorprofile
I ...
- 18.6k
41
votes
4
answers
28k
views
How to migrate existing asp.net application to asp.net MVC pattern format
I want to migrate an existing ASP.NET application to an ASP.NET MVC pattern format. What procedure should I follow? Any step-by-step instructions would be very helpful.
prabu
34
votes
3
answers
27k
views
How to change schema of multiple PostgreSQL tables in one operation?
I have a PostgreSQL 9.1 database with 100 or so tables that were loaded into the 'public' schema. I would like to move those tables (but not all of the functions in 'public') to a 'data' schema.
I ...
- 1,261
33
votes
11
answers
34k
views
Django migrations error KeyError: ('list', u'user')
I am trying to run
python manage.py migrate
or
python manage.py makemigrations
I got this error:
Running migrations:
No migrations to apply.
Traceback (most recent call last):
File "manage.py"...
- 1,522
33
votes
4
answers
82k
views
new to rails, setting up db then running rake db:create/migrate
hi im currently learning rails, and following a tutorial. the instructions were to edit the migration file after i've created the app, then running rake db:migrate, then rake db:create.
i've edited ...
- 898
33
votes
1
answer
37k
views
Laravel migrate on production server
I'm using Laravel and as part of my deploy routine I have the command
RUN php artisan migrate
Since I'm in production, I get the error
Application in production, Command Cancelled!
The fix is ...
- 2,133
32
votes
2
answers
14k
views
VS 2015 to 2017 migrate to package reference failed
I've inherited a VS-2015 C# application and would like to migrate it to VS 2017 or 2019. It has a packages.config file with 4 packages:
<package id="AjaxControlToolkit" version="15....
- 684
30
votes
7
answers
19k
views
Laravel migration transaction
When developing i'm having so many issues with migrations in laravel.
I create a migration. When i finish creating it, there's a small error by the middle of the migration (say, a foreign key ...
- 3,379
29
votes
7
answers
26k
views
How to update a database schema without losing your data with Hibernate?
Imagine you are developing a Java EE app using Hibernate and JBoss. You have a running server that has some important data on it. You release the next version of the app once in a while (1-2 weeks) ...
- 9,311
28
votes
6
answers
19k
views
TFS shelveset migration from one branch to another
I have to migrate the shelveset created in one branch say "development" to another say "release".
so that I can directly merge the shelveset then to release which was created for development branch.
...
- 377
26
votes
1
answer
23k
views
Error: SQL71564 When migrating to Azure
I'm trying to do my first migration to Azure and I'm getting the following error:
One or more unsupported elements were found in the schema used as part
of a data package. Error SQL71564: Error ...
- 1,476
25
votes
3
answers
6k
views
Meteor how to perform database migrations?
How do you perform database migrations with Meteor? With Ruby on Rails there is ActiveRecord::Migration. Is there an equivalent mechanism in Meteor?
For example, I make an app with some user data. ...
- 9,519
22
votes
3
answers
6k
views
Can't migrate database after scaffold. Section 2.2 Ruby on Rails Tutorial Michael Hartl
I'm working through the Hartl ruby on rails tutorial (section 2.2), and I'm having trouble migrating the database. Everything seemed to be working, and then I ran rails generate scaffold User name:...
- 251
22
votes
2
answers
20k
views
Not retrieving schema list from source when migrating from MSSQL to MySQL using Workbench
I'm trying to migrate my database which is in MS SQL Server to MySQL, I'm using Workbench to do so.
I get connection to both databases but get the following warning:
Retrieve schema list from source.
...
- 757
22
votes
6
answers
35k
views
Run only the next migration file
Is it possible to run only the next migration file with the sequelize-cli?
I have been looking through the docs and help-section of the cli, and it does not appear to be such a feature.
For instance,...
- 12.7k
21
votes
11
answers
45k
views
General error: 1824 Failed to open the referenced table
I am trying to set foreign key of my 'books' table with 'categories' table using php artisan migrate, but I got the following error:
Illuminate\Database\QueryException
SQLSTATE[HY000]: ...
- 337
20
votes
5
answers
31k
views
Web project requires missing web component ASP.NET Web pages with Razor syntax 3.0.0.0
I Migrate my project to mvc 5.0 and razor engin 3 with Microsoft Instruction
But when open my solution Get this:
The Web project 'ProjectName' requires missing web components to run with Visual ...
- 3,209
16
votes
11
answers
48k
views
Laravel: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
after installing a new laravel app 5.7 and trying to migrate I get this error:
Illuminate\Database\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
- 1,890
16
votes
3
answers
12k
views
from django.db import models, migrations ImportError: cannot import name migrations
So I've started to experience some issues with south on my Django web server.
Migrate command is failing with this output everytime:
from django.db import models, migrations
ImportError: cannot ...
- 163
15
votes
3
answers
13k
views
Rails: How to add add_index to existing table
I already migrated a table called units with several columns. I was wondering how to migrate in a stand alone 'add_index' to this table using the cmd. Is this code correct:
class AddIndexToUnits < ...
- 14k
14
votes
7
answers
17k
views
How do I preserve installed applications when migrating Ubuntu to another platform?
I'm looking at maybe moving from an older AMD64 to a new Intel dual-core which is 32 bit. Installation isn't a problem but can I transfer all the installed apps? I haven't been
able to find anything ...
- 7,123
13
votes
9
answers
25k
views
django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')
My model:
class Course(models.Model):
language = models.ForeignKey(Language)
name = models.CharField(max_length=50, unique=True, default='course')
title = models.CharField(max_length=1024,...
- 1,148
13
votes
6
answers
12k
views
Rails mysql2 undefined method `accept' for nil:NilClass
I know that was a million times here but tried everything and I am still getting this error:
$ rake db:migrate
rake aborted!
undefined method `accept' for nil:NilClass
Tasks: TOP => db:migrate
(...
- 2,245
13
votes
4
answers
6k
views
Django 1.8 RC1: ProgrammingError when creating database tables
I'm using AbstractBaseUser for my user models in various projects. Updating to Django 1.8 RC1 works smoothly and I can run the migrate management command. However, when trying to create a fresh ...
- 6,725
13
votes
3
answers
13k
views
Migrating Subversion Repositories across servers
We're in the process of moving servers and one of the last items is moving over the svn repositories.
There are about 10 gigs of various svn repositories. They were created using this command:
...
- 663
13
votes
1
answer
3k
views
Converting big bzr repository to git, what to expect?
I'm trying to convert some old Bazaar repositories to git, and while everything seem to go through smoothly, I'm a bit unsure if it really went as well as it claimed.
My Bazaar repository is ...
- 6,730
13
votes
2
answers
7k
views
How to 'switch' from MySQL to Amazon RDS with minimal application impact?
Amazon officially states: "Amazon RDS gives you access to the full capabilities of a familiar MySQL database. This means the code, applications, and tools you already use today with your existing ...
- 4,196
13
votes
1
answer
3k
views
iOS5 convert project to ARC fails due to "Error in format of file" How to fix?
I got a project with 49 source files that I'm trying to convert to ARC using edit>refactor>convert to arc. I click "pre-check", there are no errors, and the target compiles.
Xcode goes through "...
- 47.1k
12
votes
4
answers
12k
views
return database_name == ':memory:' or 'mode=memory' in database_name TypeError: argument of type 'WindowsPath' is not iterable
I am practicing Django but when I command python manage.py makemigration and python manage.py migrate then I got an error as show in the title. the full error is mentioned below:
C:\Users\Manan\python ...
- 156
12
votes
2
answers
29k
views
How to migrate from Gallery to HorizontalScrollView & ViewPager?
I need simple control for icon choosing on Android 2.2 and higher.
Gallery was a better solution for me, but it is deprecated and I have to use HorizontalScrollView and ViewPager instead.
But how to ...
- 4,194
12
votes
3
answers
24k
views
Relation already exists during rake migration
I have installed a blog engine to refinerycms which is working perfectly.
Now I have generated a migration with some table fields changes (of course not refinerycms or blog tables), but I'm getting ...
- 189
11
votes
1
answer
17k
views
Renaming models(tables) in Django
so I've already created models in Django for my db, but now want to rename the model. I've change the names in the Meta class and then make migrations/migrate but that just creates brand new tables.
...
- 111
10
votes
4
answers
12k
views
Migrating a Gerrit project into a different instance of Gerrit
I have MainGerritServer which hosts many projects.
Also, I have RogueGerritServer which also hosts many projects.
I'm looking for a way to move a ProjectA from RogueGerritServer to MainGerritServer ...
- 642
10
votes
2
answers
32k
views
Laravel: Base table or view not found: 1146 Table 'database.pages doesn't exist
I'm working on a CMS and I have a little problem with my migrations. I added a new migration file and I wanted to add that one. That didn't work so I ran this bit:
php artisan migrate:reset
After ...
- 1,013
10
votes
8
answers
11k
views
KeyError: ('profiles', 'talk') - How do I resolve?
Newbie here.
Trying to build an app using Django and Postgres db. I am struggling to migrate at the moment getting this error "KeyError: ('profiles', 'talk')"
Here is my error from my command line ...
- 113
9
votes
2
answers
9k
views
AppBarLayout inflating error after migrating to AndroidX
When migrating to AndroidX I faced this problem:
Java.lang.RuntimeException: Unable to start activity
ComponentInfo{com.mandarine.android/com.mandarine.android.features.root.RootActivity}:
android....
- 5,160
9
votes
5
answers
4k
views
How to replace $*=1 with an alternative now $* is no longer supported
I'm a complete perl novice, am running a perl script using perl 5.10 and getting this warning:
$* is no longer supported at migrate.pl line 380.
Can anyone describe what $* did and what the ...
- 41.4k
9
votes
10
answers
45k
views
mysql server has gone away error during installing migration (laravel)
So I am using my cmd on my laravel folder and I tried to do (php artisan migrate:install). 2 errors came up.
[PDOException] SQLSTATE[HY000] [2006] MySQL server has gone away
[ErrorException] PDO:...
- 107
9
votes
2
answers
13k
views
Saving external JSON to DB with Rails
I'm making a GET call to an external source using the gem 'httparty'; here's my Controller.rb:
def show
response = HTTParty.get('URI')
user = JSON.parse(response)
user.each {|line| puts line['...
- 385
9
votes
3
answers
30k
views
Migrating MySQL UTF8 to UTF8MB4 problems and questions
Im trying to convert my UTF8 MySQL 5.5.30 database to UTF8MB4. I have looked at this article https://mathiasbynens.be/notes/mysql-utf8mb4 but have some questions.
I have done these
ALTER DATABASE ...
- 15.7k
9
votes
1
answer
5k
views
Migration from maven-jaxb2-plugin 0.14.0 to jaxb2-maven-plugin 2.5.0
Sharing my experience about migrating from
<plugin>
<groupId>org.jvnet.jaxb2.maven2</groupId>
<artifactId>maven-jaxb2-plugin</artifactId>
<version>0.14.0&...
8
votes
6
answers
14k
views
Unable to install golang migrate library on Ubuntu 20.4
Steps followed as in the documentation
$ curl -L https://packagecloud.io/golang-migrate/migrate/gpgkey | apt-key add -
$ echo "deb https://packagecloud.io/golang-migrate/migrate/ubuntu/ $(...
- 475
8
votes
4
answers
31k
views
Php artisan migrate no such file or directory
I created a make:migration when I try to run the migration I get the following error
No such file or directory (SQL: select * from
information_schema.tables where table_schema = homestead and
...
- 4,460