Stack Overflow
Stack Overflow

Questions tagged [data-migration]

Data Migration is the movement of data from one location to another and can happen in many forms and many systems. One example of data migration is copying data from one database to another.

Data Migration is the movement of data from one location to another and can happen in many forms and many systems.

One example of data migration is copying data from one database to another.

1297 questions
43
votes
10 answers

What is the exact location of MySQL database tables in XAMPP folder?

I have a MySQL database and I want to know the exact location where this data actually stored in the XAMPP folder, I went to this file location to try to get the information: xampp -> mysql -> data -> Here I found a separate folder for each of my…
Arif
  • 1,222
  • 6
  • 29
  • 60
36
votes
6 answers

Exporting from SQLite to SQL Server

Is there a tool to migrate an SQLite database to SQL Server (both the structure and data)?
Geoff Appleford
  • 18,538
  • 4
  • 62
  • 85
34
votes
7 answers

How do I move a column (with contents) to another table in a Rails migration?

I need to move some columns from one existing table to another. How do I do it using a rails migration? class AddPropertyToUser < ActiveRecord::Migration def self.up add_column :users, :someprop, :string remove_column :profiles,…
Eero
  • 4,704
  • 4
  • 37
  • 40
32
votes
7 answers

Django: What are the best practices to migrate a project from sqlite to PostgreSQL

I need to migrate a complex project from sqlite to PostgreSQL. A lot of people seems to have problem with foreign keys, data truncature and so on... Is there a full automated utility ? Do I need to check some data or schema before the migration…
Pierre-Jean Coudert
  • 9,109
  • 10
  • 50
  • 59
31
votes
6 answers

What is the best way to migrate data in django

After making some changes in my models (eg. new field in a model and a new model) what is the best way of reflecting these changes to my populated database? PS: I wanted to see many solutions in one place rated. Apparently more solutions are…
hamdiakoguz
  • 15,795
  • 9
  • 33
  • 27
29
votes
8 answers

What is your favorite solution for managing database migrations in django?

I quite like Rails' database migration management system. It is not 100% perfect, but it does the trick. Django does not ship with such a database migration system (yet?) but there are a number of open source projects to do just that, such as…
MiniQuark
  • 46,633
  • 36
  • 147
  • 183
27
votes
3 answers

Data Migration from Legacy Data Structure to New Data Structure

Ok So here is the problem we are facing. Currently: We have a ton of Legacy Applications that have direct database access The data structure in the database is not normalized The current process / structure is used by almost all applications What…
Phill Pafford
  • 83,471
  • 91
  • 263
  • 383
26
votes
5 answers

Execute FluentMigrator migrations from code

Are there any tutorials or example code for executing FluentMigrator migrations from within code? Some "Getting Started..." tutorial would be just awesome. All I was able to find was FluentMigrator.Tests (unit tests), inside FluentMigrator source,…
Paya
  • 5,124
  • 4
  • 45
  • 71
25
votes
2 answers

Error while upgrading Mongodb from 3.2 to 3.6

I needed to upgrade mongodb from 3.2 to 3.6 in my environment. For the process i first migrated from 3.2 to 3.4 as recommended. After successful migration to 3.4, i started migration to 3.6 i am not able to start mongod. When checked log file i…
Himanshu
  • 835
  • 1
  • 13
  • 22
25
votes
5 answers

How can I transfer data between 2 MySQL databases?

I want to do that using a code and not using a tool like "MySQL Migration Toolkit". The easiest way I know is to open a connection (using MySQL connectors) to DB1 and read its data. Open connection to DB2 and write the data to it. Is there a…
Morano88
  • 2,047
  • 4
  • 25
  • 44
24
votes
4 answers

Can't execute queries until end of atomic block in my data migration on django 1.7

I have a pretty long data migration that I'm doing to correct an earlier bad migration where some rows were created incorrectly. I'm trying to assign values to a new column based upon old ones, however, sometimes this leads to integrity errors. …
sedavidw
  • 11,116
  • 13
  • 61
  • 95
23
votes
11 answers

mysqldump equivalent for SQL Server

Is there an equivalent schema & data export/dumping tool for SQL Server as there is for MySQL with mysqldump. Trying to relocate a legacy ASP site and I am way out of happy place with working on a windows server. Note: The DTS export utility own…
David
  • 17,673
  • 10
  • 68
  • 97
22
votes
4 answers

How to copy database in use to other database in django?

I have developed a simple django application using sqlite3. At first, I wanted to keep it simple using sqlite3 but, things are beginning to scale up (Yes, I actually started using that application with sqlite3! Shame on me...) so I want to migrate…
yasar
  • 13,158
  • 28
  • 95
  • 160
22
votes
2 answers

How to make field enum migration yii2

I make field ENUM and the result is error when I use yii migrate/up on CMD windows. public function up() { $tableOptions = null; if ($this->db->driverName === 'mysql') { $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci…
CrashBurn
  • 345
  • 1
  • 3
  • 20
21
votes
3 answers

Realm migrations in Swift

I have a Realm Object modeled as so class WorkoutSet: Object { // Schema 0 dynamic var exerciseName: String = "" dynamic var reps: Int = 0 // Schema 0 + 1 dynamic var setCount: Int = 0 } I am trying to perform a…
Cody Weaver
  • 4,756
  • 11
  • 33
  • 51
1
2
3
…
86 87