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
9
votes
4 answers

How do I convert Microsoft Access file into SQL Server database?

I want to know how to convert an Access database file into a SQL Server (.mdf file) database?
Arun Thankur
  • 129
  • 1
  • 1
  • 5
8
votes
2 answers

Upgrade / Increase AWS Lightsail virtual machine's memory for better performance

I have a AWS Lightsail VM with the following configuration 512MB RAM 1 vCPU 20GB SSD Ubuntu 20.04 The main problem is the RAM which is not enough for my current work and facing out of memory issues. I want to increase RAM to at least 2GB or…
Muhammad Tariq
  • 3,318
  • 5
  • 38
  • 42
8
votes
1 answer

Plone: collective.transmogrifier.sections.constructor doesn't write objects while importing

I'm almost successful in my efforts to transfer an excerpt of my ZODB (a small subset of folders, including resources taken from other folders) to another Plone instance; the showstopper is: during import, my objects are not written. Here is my…
Tobias
  • 2,481
  • 3
  • 26
  • 38
8
votes
1 answer

How to include custom data migrations and static/reference data in an SSDT project?

We have a moderately-sized SSDT project (~100 tables) that's deployed to dozens of different database instances. As part of our build process we generate a .dacpac file and then when we're ready to upgrade a database we generate a publish script and…
Rory
  • 40,559
  • 52
  • 175
  • 261
8
votes
3 answers

Synchronizing databases between a local and remote development environment

I've being working on a local project recently, and have been synchronising it with an online server. The problem is, now it involves database functionality. What this means is that whenever I make a database change locally, I have to access the…
Lucas
  • 16,930
  • 31
  • 110
  • 182
8
votes
7 answers

Transfer MySQL to SQLite

I want to start using Core Date on iPhone with pre-existing MySQL databases. What's the easiest way to transfer a MySQL database to SQLite? I've tried using SQLite Migrator, but I don't know where to find the ODBC drivers for Mac (Snow Leopard). I…
nevan king
  • 112,709
  • 45
  • 203
  • 241
8
votes
1 answer

Steps to migrate Core Data databases for shipped iPhone apps

What are the recommended steps to be done for migrating Core Data DB changes for updated iPhone apps already shipped? Is there any prior step one need (should) have done before shipping a Core Data app?
epatel
  • 45,805
  • 17
  • 110
  • 144
7
votes
4 answers

In Django/South HOWTO create an instance of a model from a different app during DataMigration

I need to perform a datamigration of a model Answer in app Question. In that script there is a dependency such that I need to create an instance of a model Chapter which is in the app Journal. So, I coded it as follows: def forwards(self, orm): …
Chantz
  • 5,883
  • 10
  • 56
  • 79
7
votes
1 answer

Doing huge data migrations in rails

I am experiencing big time and computing power challenges when doing big data migration (several 100.000 rows). I am developing a service that handles a lot of data in rails. Our models are constantly changing as we get more and more cleaver about…
Niels Kristian
  • 8,661
  • 11
  • 59
  • 117
7
votes
3 answers

A simple pg/plsql loop example

We are redesigning table schema in postgres. It used to have a linker table to the two tables partner and advertiser of the name partner_advertiser since we were assuming a many-many relationship between partner and advertiser. A change is made such…
ivanceras
  • 1,415
  • 3
  • 17
  • 28
7
votes
1 answer

alter multiple mysql databases at once (SAAS database changes)

We are running a PHP (zend framework) app that creates a database per user (for security/backup/and others reasons). All these databases have exactly the same structure and that will always be the case. When we deploy new features we'll need to…
Jorre
  • 17,273
  • 32
  • 100
  • 145
7
votes
1 answer

Django - Datamigration for external app

Is there any way to properly create data-migrations for third party Django apps? Running python manage.py makemigrations --empty works, but creates the migrations in the app's directory (which is inside the virtual environment...…
stett
  • 1,351
  • 1
  • 11
  • 24
7
votes
2 answers

What is the best way to collapse all existing Entity Framework migrations

The project I am working on is using Entity Framework 4.3 and data migrations to keep the schema up to date. Over the course of the project the migrations folder has grown and now has over 600 files. This is huge. We now have a binary which is over…
Keith Bloom
  • 2,391
  • 3
  • 18
  • 30
7
votes
7 answers

How to get Guid from SqlDataReader uniqueidentifier

SQL Server 2008 (version 10.50.2550). I have a select query to return a single column of type uniqueidentifier. I want to get this into a C# variable of type Guid. All of the following methods result in exceptions. reader is of type…
cja
  • 9,512
  • 21
  • 75
  • 129
7
votes
2 answers

Migrating products data from opencart to magento

I have a opencart based shopping cart site.. Now I would like to convert it into a magento site.. I've done a fresh magento installation. Now i need to migrate the data from my opencart database to new magento database So can anyone give me the…
Giri
  • 4,849
  • 11
  • 39
  • 48
1 2 3
…
86 87