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
-1
votes
1 answer

How to manage database sequences in case database is at two servers?

Data migration, if we are doing phase wise migration of database and DB replication we cannot go for. Then how do you think if we manually sync both the databases. How to manage sequences in this case so that both databases have Unique ID generated?
Nishant Malhotra
  • 19
  • 1
-1
votes
1 answer

Wordpress theme breaks when I migrate to live server

I have created my own theme which works just fine locally, but when I try to migrate it to a live server the links break. I've gone through the usual channels: permalink changes, database search & replace using new url, plugin deactivation etc etc,…
Gerry
  • 1
  • 1
-1
votes
1 answer

django/south : redundant add_column?

I made a change, adding a unique constraint to a model, within the abc application and did a ./manage.py schemamigration abc --auto That created a migration file but as well as the expected change the new migration file also contained a number of…
glaucon
  • 8,112
  • 9
  • 41
  • 63
-1
votes
3 answers

R remove quotation mark in column name of the data frame

I have SPSS data, which I have to migrate to R. The data is large with 202 columns and thousands of rows v1 v2 v3 v4 v5 1 USA Male 21 Married 2 INDIA Female 54 Single 3 CHILE Male 33 Divorced ...and so on... The data file contains…
Prabhu
  • 5,296
  • 4
  • 37
  • 45
-1
votes
2 answers

Migrating Oracle database based on a database mapping document using Talend Data Integration

my team has to do an Oracle database migration using Talend Open Studio Data Integration. There are many schema changes resulting in the target database and we have the new data model for the target database without data. All I have is the source…
asthiwanka
  • 437
  • 2
  • 6
  • 17
-1
votes
1 answer

Migrating a specific data to another table with same fields but different sizes and datatype

I am in a middle of migrating data from excel to a database in SQL by importing it, thus making physical tables with fields nvarchar(255) as its datatype, the elements inside the excel file came from the same copy of the database where it would be…
Albert Laure
  • 1,702
  • 5
  • 20
  • 49
-1
votes
4 answers

MySQL ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails

I am trying to move content from wordpress posts to mezzanine using: INSERT INTO mezdb.blog_blogpost (id, user_id, publish_date, content, title, description, slug, updated, status) SELECT DISTINCT ID, post_author, post_date, post_content,…
qliq
  • 11,695
  • 15
  • 54
  • 66
-1
votes
1 answer

Creating new User Routines in Talend Open Studio

I have created a new user routine in Talend Open Studio but I am not able to view the newly created user routine in any of the function lists.
siddhartha_haldar
  • 9
  • 2
-1
votes
1 answer

How to Make Critera for Data migration

Goal: Load the destination table c with data from table a and b. Problem: I have two tables, a and b with that need to be migrated into same table c. Need to load one table at a time. When loaded to table c, the criteria för table a need to…
HelloWorld1
  • 13,688
  • 28
  • 82
  • 145
-1
votes
1 answer

Upgrading SQL Server 2000 to MySQL 5.1 using DTS - How solve DateTime problem?

I'm trying to migrate from sql server 2000 to mysql by using DTS. That's the best tool I know yet. But one a sql server tables has a column with datetime type, the DTS suggest the following sql code: `StartDate` long varbinary NULL, `EndDate`…
Eduardo Xavier
  • 1,520
  • 21
  • 29
-2
votes
6 answers

Migrate and Merge several databases into one

In an update project i have to do the following: Move 3 databases from SQL2000 to SQL2005 and merge them at the same time. There are already quite a few cross database queries used in SP's and Views. The current plan is to move each of the old…
H H
  • 263,252
  • 30
  • 330
  • 514
-2
votes
2 answers

How to build 200 onprem databases in azure?

Currently I am using the DMS Service, which migrates the onprem SQL Databases to Azure, one thing this does not do is it doesnt create the Azure SQL Databases same used in onprem, we have to manually build this. I have 200 databases which needs to…
Anmol001
  • 35
  • 4
-2
votes
1 answer

Data Loss while transferring from Cassandra to SQL using Talend

We are using Talend open studio for Data Transfer from Cassandra to SQL. While reading data using Talend job, sometimes we face data loss. And we are unable to find any Error for the same. Even Cassandra System/ Debug Logs are showing very limited…
BjMangat
  • 21
  • 2
-2
votes
1 answer

migrate unidata database which is multivalue to sql using dotnet code

i want to migrate unidata database which is multivalue to sql using dotnet code.IS this possible,one of the possibility is through SSIS but this will consume lot of time becouse we have to do ETL process to all the tables in DB .So was looking for a…
Ayesha
  • 1
  • 1
-4
votes
1 answer

How to migrate DB2 z/OS data to MySQL?

As part of the data migration from DB2 z/OS (Mainframe) to Google cloud SQL, I don't see the direct service/connector provided by google or IBM. So, I am exploring the option to move the data to MySQL first and then to Cloud SQL. I could see the…
Sekhar
  • 627
  • 4
  • 14
  • 34
1 2 3
…
86
87