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

How to create rows from a running number?

I'm trying write code of running numbers from document numbers, with the following values Data in mind : document_types records : {:document_type_code => 'PR', :running_no => 2, ...} {:document_type_code => 'SO', :running_no => 1,…
-1
votes
0 answers

Issues migrating from Oracle to Sql server 2008

We are migrating a Oracle database to SQL Server 2008 In Oracle I got a number column for identitying boolean types, eg col name is IsInd In the C# code I have defined a property like public int IsInd{ get; set; } I have used SSMA tool to…
user804401
  • 1,990
  • 9
  • 38
  • 71
-1
votes
0 answers

Migrating system-versioned tables to Azure

I'm trying to migrate a SQL Server 2017 database to an Azure SQL database. The Microsoft Data Migration Assistant, the schema, stored procedures, tables and even the versioning is created properly. However, none of the data is able to be copied…
-1
votes
2 answers

SQL Server migration from denormalized to normalized table causing performance issues

We have a denormalized table in our SQL Server data model that we want to migrate to a normalized format. However, the query we have created for this migration is causing a significant delay. We have checked the actual execution plan and found that…
-1
votes
1 answer

Cassandra 3 - Import and Exporting Blobs Fail with "'str' object has no attribute 'decode'" Error

I'm trying to test copying a table into a csv, and then importing the data int he csv into a table. Table: CREATE TABLE keyspace_n.collection_n ( id1 text, id2 int, id3 text, appname text, coll blob, PRIMARY KEY ((id1, id2), id)..... "COPY to"…
-1
votes
2 answers

Migrate data from Dynamics CRM 4.0 to 365

I have a client with an old CRM, Dynamics 4.0 on-premise and I want to migrate data from his CRM to a new instance Dynamics 365. Is there any way to migrate his data?
-1
votes
1 answer

WP full site migration (to another host with different domain) 403 error

I received a request to completely move a wordpress site from one host to another and change the domain name to it as well. I downloaded the database and the files and folders, uploaded to the other host. Everything works well except for 2…
-1
votes
1 answer

Migrate Data from one Riak cluster to another

I have a situation where we need to migrate data from one Riak cluster to another and then remove the old cluster. The ring size will be same, even the region will be the same. We need to do this to upgrade the instances to AL2. Is there a clean…
-1
votes
1 answer

Azure DevOps server 2019 Migration to Azure DevOps services using Data Migration tool

following the document for migration .... but in our case all user identities are maintained in Azure active directory and Azure ADDS(no on-premise AD is used).... so can i ignore the status of users in identityMap.csv file and go ahead with…
-1
votes
1 answer

How can I export data from cosmosdb to .json file

how can I export data from cosmosdb in json file, in safe way, without locking table? and preferred to have ability to download only some properties from document with query.
TamKap
  • 139
  • 3
  • 9
-1
votes
1 answer

Which file type is better for importing data into SQL Server: CSV or JSON?

I am taking part in a project where a third-party company will provide us with an export of our customer data so that we can import them into our in-house system. Each customer record has about twenty fields. The data-types are strings, booleans,…
Extranomical
  • 385
  • 1
  • 3
  • 13
-1
votes
1 answer

data migration takes long time

I have been written an c# console app for migrate data; count of records not so more; each table has almost 100 hundred records. but the structure of data and the businesses logic is so complicated with almost 200 tables. my data migration has…
KoKo
  • 421
  • 1
  • 5
  • 21
-1
votes
1 answer

I have 2 different Azure subscription, Which needs to be transferred to Single Azure account

For E.g I have two Azure Subscriptions. Subscription A and Subscription B and I need to Transfer the Subscription B to Subscription A. Is that possible to do the same? What approach do I need to use for this? Do I need to Add Subscription B to A via…
-1
votes
1 answer

How can I load large amount of data into oracle database from .csv -file without risking to drop och mismatch data?

I’m in the middle of trying to migrate a large amount of data into a oracle database from existing excel-files. Due to the large amount of rows loaded (10 000 and more) every time, it is not possible to use SQL Developer for this tasks. In every…