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

Data migration issue on live enviroment

I am planning to migrate data which resides in oracle database to a CMDB application database. Since the database is not visible for end users/Developers of CMDB, we use API to import data into CMDB. Currently my issues is , i cannot shutdown the…
SmartestVEGA
  • 8,415
  • 26
  • 86
  • 139
-1
votes
1 answer

Script to Migrate two tables on two different databases

I am new in my environment and Im asked to create scripts for a project. The scripts will migrate (essentially merge) two different tables with their data located on two different databases on two different servers. All together I have 4 tables.…
Black-Prince
  • 11
  • 3
-1
votes
1 answer

ORA-02298 - Parent keys not found when enable constraint

I have a migration script in between 2 different schema database. The script does 3 things: Disable constraint Insert record from old schema to new schema Enable constraint During enable constraint, it encouter ORA-02298 - Parent keys not found:…
user2102665
  • 429
  • 2
  • 11
  • 26
-1
votes
1 answer

Camel import data between two server

I integrate two systems and i have to insert data from one client table to another in another server, without any business logic or datamodification, onece per week. Every time when its run i have to inesrt all data. So i wrote camel configuration…
Kacper Stelmach
  • 11
-1
votes
1 answer

SQL file executes in MySQL workbench but not in python

I'm writing a python script to migrate data from one MySQL database to another. The script loads a sql file dumped by mysqldump and splits the commands similarly to this SO question. When I execute the script in python 2.7 using the python-mysql…
KareemElashmawy
  • 251
  • 5
  • 16
-1
votes
1 answer

Migrate data from one mount to another

In Azure Linux VM we have an LVM that holds the data(1.2TB) of a live application. For some reasons, we want to migrate the data of the application to another LVM and decommission the old one. We want to achieve this with minimal downtime. What…
A_K
  • 81
  • 8
-1
votes
2 answers

Upgrade database from sql server 2008 to sql server 2016

I have database created on SQL SERVER 2008. I want to upgrade it to SQL SERVER 2016. what is the best way to upgrade the whole database? Thanks in advance.
Jai
  • 416
  • 6
  • 20
-1
votes
1 answer

I converted my db as postgresql to mysql, but I can't able to convert trigger. How to change this trigger as mysql format?

I made a database migration from Postgres to MySQL, now I can't able to convert a trigger to this new database engine. Postgres trigger function below: CREATE OR REPLACE FUNCTION ins_stk_dt_in_lgr_frm_purchase_entry() RETURNS trigger AS $BODY$ …
Libin Manoharan
  • 56
  • 4
-1
votes
3 answers

How read large number of large files on NFS and dump to HDFS

I am working with some legacy systems in investment banking domain, which are very unfriendly in the sense that, only way to extract data from them is through a file export/import. Lots of trading takes place and large number of transactions are…
Apurva Singh
  • 4,534
  • 4
  • 33
  • 42
-1
votes
1 answer

How to avoid duplication while migrating data from DB2 to MongoDB

I am new to MongoDB and planning to migrate DB2 data (~6TB) to Mongodb. so we are planning to using Java utility to read the data from DB2 and insert the same in MongoDB. If any error occurs during the execution of Java utitity and I restart it…
Deepakgupta185
  • 19
  • 1
-1
votes
1 answer

Data Remodelling and transformation mysql to hdfs and mongodb

We are facing an issue of data migration. We have two heavily loaded tables. We used to make a join and fetch aggregated data from both tables in real time. Since due to increase in size we want to migrate it in mongodb with remodelling having a…
ravi ranjan
  • 5,920
  • 2
  • 19
  • 18
-1
votes
1 answer

Django 1.8 How Drop certain tables using manage.py?

I'm having a real bad time using manage.py to drop certain tables of the database, the project is already running. the only way I found is accessing the tables by: python manage.py dbshell but again, not sure how to drop the tables.
Alvaro Silvino
  • 9,441
  • 12
  • 52
  • 80
-1
votes
1 answer

Insert rows returned by stored procedure into a different table - different databases and servers

I have a local table in database Test like: CREATE TABLE [SavedData] ( [RowID] INT NOT NULL , [Category] INT NOT NULL , [X] DATETIME NOT NULL, [Y] DATETIME NOT NULL, PRIMARY KEY ([RowID]) ) I have a procedure in remote…
Mr. Boy
  • 60,845
  • 93
  • 320
  • 589
-1
votes
2 answers

SSIS migration to Dynamics CRM 2016 (Kingsway soft/visual studio)

I am currently migrating some data from a holding database to dynamics CRM using SSIS/SSDT with Kingswaysoft plug in example. I currently have a field which stores the value as one line however I require the fields to be split up and migrated to…
KCodeR
  • 121
  • 5
  • 19
-1
votes
1 answer

Data Migration : What way is the best way to Migrate?

I am doing data migration two database in MS SQL 2005. The records are more than 200000 nearly 300000. I need to query from source database using joins and insert 2 or 3 tables in destination databse. Which way is the best way to do so? Please…
RedsDevils
  • 1,413
  • 9
  • 26
  • 47
1 2 3
…
86 87