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
488
votes
11 answers

Exporting data In SQL Server as INSERT INTO

I am using SQL Server 2008 Management Studio and have a table I want to migrate to a different db server. Is there any option to export the data as an insert into SQL script??
Jack Kada
  • 24,474
  • 29
  • 82
  • 106
248
votes
25 answers

SQL Server String or binary data would be truncated

I am involved in a data migration project. I am getting the following error when I try to insert data from one table into another table (SQL Server 2005): Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. The source…
Jim Evans
  • 6,285
  • 10
  • 37
  • 60
220
votes
13 answers

How do I move a redis database from one server to another?

I currently have a live redis server running on a cloud instance and I want to migrate this redis server to a new cloud instance and use that instance as my new redis server. If it were MySQL, I would export the DB from the old server and import it…
ErJab
  • 6,056
  • 10
  • 42
  • 54
182
votes
6 answers

How to move Jenkins from one PC to another

I am currently using Jenkins on my development PC. I installed it on my development PC, because I had limited knowledge on this tool; so I tested on it in my development PC. Now, I feel comfortable with Jenkins as my long term "partner" in the build…
huahsin68
  • 6,819
  • 20
  • 79
  • 113
115
votes
9 answers

How to group by week in MySQL?

Oracle's table server offers a built-in function, TRUNC(timestamp,'DY'). This function converts any timestamp to midnight on the previous Sunday. What's the best way to do this in MySQL? Oracle also offers TRUNC(timestamp,'MM') to convert a…
O. Jones
  • 103,626
  • 17
  • 118
  • 172
104
votes
8 answers

Loading initial data with Django 1.7+ and data migrations

I recently switched from Django 1.6 to 1.7, and I began using migrations (I never used South). Before 1.7, I used to load initial data with a fixture/initial_data.json file, which was loaded with the python manage.py syncdb command (when creating…
Mickaël
  • 3,763
  • 5
  • 26
  • 32
91
votes
7 answers

Completely copying a postgres table with SQL

DISCLAIMER: This question is similar to the stack overflow question here, but none of those answers work for my problem, as I will explain later. I'm trying to copy a large table (~40M rows, 100+ columns) in postgres where a lot of the columns are…
Erik
  • 6,470
  • 5
  • 36
  • 37
79
votes
3 answers

Dealing with schema changes in Mongoose

What's the best practice (or tool) for updating/migrating Mongoose schemas as the application evolves?
mahemoff
  • 44,526
  • 36
  • 160
  • 222
70
votes
5 answers

SVN copy between repositories with history

One of my teammates has asked if it is possible to export from one SVN to another, all while maintaining history. To me, this seems like it would be a common request. So: Is it possible to migrate between SVN repositories all while maintaining…
John Gietzen
  • 48,783
  • 32
  • 145
  • 190
65
votes
13 answers

How (and whether) to populate rails application with initial data

I've got a rails application where users have to log in. Therefore in order for the application to be usable, there must be one initial user in the system for the first person to log in with (they can then create subsequent users). Up to now I've…
Luke Halliwell
  • 7,312
  • 6
  • 31
  • 31
65
votes
4 answers

How to efficiently manage frequent schema changes using sqlalchemy?

I'm programming a web application using sqlalchemy. Everything was smooth during the first phase of development when the site was not in production. I could easily change the database schema by simply deleting the old sqlite database and creating a…
ascobol
  • 7,554
  • 7
  • 49
  • 70
56
votes
10 answers

What is the best approach to change primary keys in an existing Django app?

I have an application which is in BETA mode. The model of this app has some classes with an explicit primary_key. As a consequence Django use the fields and doesn't create an id automatically. class Something(models.Model): name =…
luc
  • 41,928
  • 25
  • 127
  • 172
51
votes
3 answers

Is it worth using sqlalchemy-migrate ?

I have a web application using sqlalchemy (within Pylons). I need to effiently change the schema to be able to change the production version at least on a daily basis, maybe more, without losing the data. I have played a little bit with…
ascobol
  • 7,554
  • 7
  • 49
  • 70
51
votes
2 answers

How to implement IDbContextFactory for use with Entity Framework data migrations

I am trying to use Entity Framework data migrations, as described in this post. However, when I try to execute the Enable-Migrations step, I receive the following error in Package Manager Console: The target context 'MyDataContext' is not…
Tim Coulter
  • 8,705
  • 11
  • 64
  • 95
50
votes
5 answers

Implementation of "Automatic Lightweight Migration" for Core Data (iPhone)

I would like to make my app able to do an automatic lightweight migration when I add new attributes to my core data model. In the guide from Apple this is the only info on the subject I could find: Automatic Lightweight Migration To request…
RickiG
  • 11,380
  • 13
  • 81
  • 120
1
2 3
…
86 87