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

How can I use MVC4 Migrations without using Entity Frameworks?

How can I use MVC4 Migrations without using Entity Frameworks? I would really like to use data migrations but I am not using Entity Frameworks. I am using dapper-dot-net.
Jamey McElveen
  • 18,135
  • 25
  • 89
  • 129
7
votes
7 answers

Migrate rows for import into existing Database, taking care of changing ids etc

The purpose of this is to copy some rows from one environment to another without overwriting existing rows. Sample DB: INSERT INTO `school` (school_id,name) VALUES (15,'Middle'); INSERT INTO `class` (class_id,school_id,name) VALUES…
St. John Johnson
  • 6,590
  • 7
  • 35
  • 56
6
votes
2 answers

Visual Server Database Project data motion scripts run on databases at different versions

We have been using Visual Studio Database projects to maintain the current schema of the project which has worked well for us in regards to getting the database schema onto new development machines but we have not used it to upgrade environments.…
Bronumski
  • 14,009
  • 6
  • 49
  • 77
6
votes
1 answer

Migrate data from one Model to another with Django South

I currently have a structure that needs to be rewritten in order to cope with Django-CMS Currently the setup is as follows class Video(models.Model): #embed_code_or_url = models.CharField(max_length=2000) permalink =…
ApPeL
  • 4,801
  • 9
  • 47
  • 84
6
votes
1 answer

Unable to use model in migration in Yii 1.x

Using migration to insert or change the table structure is no problem for me. But, I have a problems to to change the data inside a table using model. My idea is to do something like that: public function up() { $models =…
zonky
  • 1,058
  • 9
  • 11
6
votes
4 answers

Programmatically check whether there are django south migrations that need to be deployed

My deployment strategy looks like this (using Fabric): create a new virtualenv deploy new code in new virtualenv show a maintenance page copy the current db to new db migrate new db point new code to new db symlink current virtualenv to new…
Sander Smits
  • 2,051
  • 3
  • 18
  • 16
6
votes
2 answers

Oracle date corruption during update

I'm migrating some data from one oracle schema/table to a new schema/table on the same database. The migration script does the following: create table newtable as select ... cast(ACTIVITYDATE as date) as ACTIVITY_DATE, ... FROM oldtable where…
chris
  • 36,094
  • 53
  • 157
  • 237
6
votes
1 answer

Disable foreign key constrains in AWS DMS Migration not working for Postgres

Hi I want to migrate my data from one Postgres RDS instance to another. However my database contains tables that have foreign key constraints. As per official Migration documentation provided, AWS DMS migrates only required schema and does not…
Neha Awasthi
  • 61
  • 7
6
votes
2 answers

How to migrate Drupal data to Django?

I want to migrate part of a Drupal 6 site to a Django application, specifically a Drupal based questions and answers section that I think would work better with OSQA. I've already created another question related to the authentication part of this…
Mentakatz
  • 715
  • 1
  • 5
  • 13
6
votes
2 answers

Strategies for handling updates in existing JPA persistence classes

We are doing a project in which we have planned to use JPA Persistence. We think that once the project goes live, there is a small chance that changes in the data model might be required. My query is that what are the different strategies available…
RKSinha
  • 61
  • 4
6
votes
2 answers

SSIS ISNULL to empty string

So I am currently working on a migration from an old Advantage database server to SQL 2005 using SSIS 2008. One of the columns in the old Advantage database is a MEMO type. By default this translates to a DT_TEXT column. Well in the new database I…
Justin Rassier
  • 898
  • 12
  • 26
6
votes
2 answers

Achieving zero downtime Cassandra/DataStax migrations

I've got a Cassandra cluster (3 nodes, all nodes deployed to AWS) that I am trying to migrate over to a DataStax cluster. It's simply time to stop managing these nodes myself. I have multiple producers and consumers all reading/writing data, all day…
smeeb
  • 27,777
  • 57
  • 250
  • 447
6
votes
1 answer

Where can I find good examples or tutorials for sqlalchemy-migrate

In this thread someone pointed me to use sqlalchemy-migrate to help with a fast-changing web application using sqlalchemy. However a Do It Yourself method was also recommended consisting in manually writing CSV columns for the new database schema,…
ascobol
  • 7,554
  • 7
  • 49
  • 70
6
votes
2 answers

Port field from NULLABLE to REQUIRED in BigQuery

I am trying to move a BigQuery table to a new schema that has some additional new NULLABLE fields and in which a field f has become REQUIRED (they were NULLABLE in the old schema.) I tried to update the table with the new schema through the…
Alessandro Cosentino
  • 2,268
  • 1
  • 21
  • 30
6
votes
2 answers

What is the most efficient way to restore multiple databases in SQL 2008

I'm in the process of doing a large scale server migration, as such I have to move 50+ SQL 2005 databases to a new SQL 2008 server installation. The DB guys have only given me a backup of each database, so I have a directory with some 50 .bak files…
Jeremy Cade
  • 1,351
  • 2
  • 17
  • 28
1 2 3
…
86 87