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
5
votes
2 answers

Copy tables with different column name MySQL

I need to copy all rows from table1 matching specific columns into table2 with different columns name. For example: table1 name = oldAddressBook , table1's columns name = Name,Surname,Number table2 name = newAddressBook , table2's columns name =…
user626415
  • 71
  • 3
  • 6
5
votes
1 answer

How can I initialize a database table with Flask / SQLalchemy / Alembic?

I have a database table of languages with relatively static content: from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy() class Language(db.Model): __tablename__ = 'languages' # Fields code = db.Column(db.String(2),…
Martin Thoma
  • 124,992
  • 159
  • 614
  • 958
5
votes
2 answers

How do I move data from RDS of one AWS account to another account

We have our web services and database set up on AWS a while back and application is now in production. For some reason, we need to terminate the old AWS and move everything under a newly created AWS account. Application and all the infrastructure…
ddd
  • 4,665
  • 14
  • 69
  • 125
5
votes
2 answers

Transfer binary data (image etc) in a CSV file

I have some binary data to transfer in addition to some other metadata information stored as string, number etc. The binary data I have is image files stored as a blob column in the database, I want to include the blob column in the csv file and…
mcvkr
  • 3,209
  • 6
  • 38
  • 63
5
votes
1 answer

South django table already exists

I'm experiencing the same problem as with: django - "manage.py test" fails "table already exists" The schemamigration / migration worked fine (although did have some problems that required me to --fake, but all subsequent migrations with south…
null
  • 1,137
  • 2
  • 11
  • 29
5
votes
1 answer

aws DMS replicate-changes-only error

I have prod aws Aurora DB and I want to replicate changes to test mysql DB (schema is same - Aurora is based on mysql) I am using aws DMS for this. When performing full replication for certain tables the replication works fine, When I want to…
Amits
  • 181
  • 2
  • 8
5
votes
0 answers

What is common data migration strategy for Core Data in iOS development?

If data model changes,and need be backward compatible to use old data source,we must consider data migration for database application. What is the common strategy for core data in iOS dev ? Is there any mature open source project to handle this…
Forrest
  • 122,703
  • 20
  • 73
  • 107
5
votes
1 answer

Mysql data migration - wbcopytables charset

I am trying to move some data from MSSQL to MySQL. When I'm running wbcopytables.exe the charset on mysql connection seems to be wrong, I'm getting an error when the data contain emoji icons…
andy250
  • 19,284
  • 2
  • 11
  • 26
5
votes
1 answer

Copy Selected items from AWS dyanmoDB table to another table

I want to copy the data from one Amazon dynamodb table to another amazon dynamodb table(of same region).. 1]I have table called MUSIC which has 20 items 2] I have another table MUSIC_ST (with same schema as table MUSIC). Now I want to migrate…
Tedd
  • 53
  • 1
  • 4
5
votes
2 answers

Why GenericRelation fields does not work in Data Migrations(Django)

I want to make data migration in order to add user read post in database. There is such code: def user_read_posts(apps, schema_editor): User = apps.get_model("main", "User") Post = apps.get_model("main", "Post") Comment =…
Q-bart
  • 1,503
  • 4
  • 22
  • 41
5
votes
1 answer

Migrating Maintenance Plan from One Sql Server 2008 Instance to Another

I have an extensive maintenence plan on one sql server 2008 instance that I wish to move to 4 other instances. What is the best way to do this other than rebuilding it on each server? Thanks
Josh
  • 16,286
  • 25
  • 113
  • 158
5
votes
4 answers

INSERT Data From One Table Into Multiple Tables

I'm using SQL Server 2005. I am migrating data over from a current database (single table) to a new database (normalized - many tables). In the new database, I have a base table (let's call it "BaseTable"), and multiple other tables (let's call them…
jchapa
  • 3,876
  • 2
  • 25
  • 38
5
votes
2 answers

How to update/migrate data when using CQRS and an EventStore?

So I'm currently diving the CQRS architecture along with the EventStore "pattern". It opens applications to a new dimension of scalability and flexibility as well as testing. However I'm still stuck on how to properly handle data migration. Here is…
Trent
  • 5,785
  • 6
  • 32
  • 43
5
votes
4 answers

Does anyone have a sample data migration script (Oracle 10g to Oracle 10g, but different schemas)?

I am trying to write a data migration pl/sql script to transfer some of the data in one schema to a different schema on another server. The second database started as a subset of the original database, but we have modified the schema. So I can't…
Theresa
  • 3,515
  • 10
  • 42
  • 47
5
votes
2 answers

MemoryError while loading huge initial data

I have the initial data from my old database which takes around 6GB. I could "dumpdata" my old database without any problem. But when I attempted to restore them to the new database, I got the MemoryError: python manage.py loaddata…
cem
  • 1,535
  • 19
  • 25
1 2 3
…
86 87