Questions tagged [migration]

For questions about migration of data from one source to another (e.g. a database migration from MySQL to SQL Server), or the migration of code from one language (version) to another, e.g. from Java 7 to Java 8 or from Java to Python.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
88 views

Microservice decomposition into reusable microservice from a set of monolithic applications

So for my Masterthesis i have to decompose a set of monolithic industrial applications into microservices. The aim is to decompose the monoliths in to services that are as much reusable as possible. I ...
user avatar
  • 1
1 vote
1 answer
71 views

An effective database migration pattern for many instances of the same app over a long period of time

How do you handle migrations to your database after a long period of time? I'm using fluent migrator, and after some months or years, the number of migrations could be (and has been in previous ...
user avatar
0 votes
1 answer
227 views

A bug was found in my code. Should I migrate the application as planned, or focus on patching the bug?

While testing my iOS application against the latest version, I've discovered a bug. For the purpose of this question, I am omitting the details of the bug. I was planning to migrate the application to ...
user avatar
  • 2,001
-4 votes
1 answer
41 views

Create the database using schema migration for the first time? [closed]

what is the best practice when creating a database schema for the first time? Do I need to write schema migrations, or create it from the DBMS tools?
user avatar
  • 169
1 vote
1 answer
119 views

Dealing with queries on versioned data

I have a dataset stored in ElasticSearch, only for searching purposes (the source of truth is external). Each index has an associated schema and there are associated queries. From time to time, the ...
user avatar
21 votes
5 answers
1k views

How can there be so much "business logic" for a company that they cannot drop their old COBOL/mainframe code? [closed]

Something which has always confused me is this. I keep hearing about how these big, old corporations which were around in the 1950s (for example) and early on started using COBOL-coded business logic ...
user avatar
-1 votes
1 answer
160 views

New frontend for legacy code

How would you engineer this: You have a legacy application that is a big ball of mud and a monolith. This application is "impossible" to change to look good on mobile devices. The management ...
user avatar
  • 59
0 votes
0 answers
68 views

To merge software solutions or not?

Software A is a Node/Express application using a MongoDB database. It is accessed mostly via RESTful endpoint by a mobile app built in RN and an admin dashboard via React web app. It also has a ...
user avatar
  • 109
6 votes
3 answers
344 views

Rebuilding a legacy application : What about the data model?

I am currently rebuilding from scratch a product catalogue (to feed a shopping website). The existing legacy system is heterogenous, Long story short : The some products are stored in a FileMaker ...
user avatar
0 votes
1 answer
63 views

Best way to migrate to new versions of librairies with breaking changes

(I orignally posted my question on StackOverflow and figured maybe this would be a better place to ask) I provide details on the librairies I'm working with because it helps understand my issue but it ...
user avatar
2 votes
1 answer
335 views

Is it considered as best practice to use migration scripts for one-off large data manipulation over a table?

I have inherited a project via laravel that uses its database migration mechanism coming from the framework. The application has the following table named actions: action_log_id SERIAL PK user_id INT ...
user avatar
2 votes
2 answers
262 views

Isn't data migration a major benefit of MongoDB compared to the commonly used relational databases?

I was reading an old answer which was recently updated, and noticed that the author doesn't quote the simplicity of data migration as a benefit of MongoDB. I always thought that the major benefit of a ...
user avatar
-3 votes
1 answer
63 views

Strategies in cloud migration [closed]

A few months ago I found a presentation with slides about the benefits of migrating to the cloud. I think that the presentation was maybe quite old but I think that it started with arguing that ...
user avatar
1 vote
2 answers
426 views

Live data migration - double read vs double write

Pretty often I have a need to migrate the location where some data is stored - to a new column, a new table, or even a new data store. And usually this needs to be done with no down-time. I can see ...
user avatar
  • 139
-4 votes
2 answers
41 views

Partially Automated Migration of Monolith to MicroService

I am struggling to find some methods / concepts or even implementations of partially automated processes to split a monolith into microservices. Of cause I do not expect any solution that will make ...
user avatar
  • 1
3 votes
1 answer
121 views

Front-end migration in an Agile process

In our organisation, we're planning on migrating a Single-Page Application (with a complex back-end) to another Front-end technology (Angular to React). We'd like to procede with an Agile mindset by ...
user avatar
  • 139
0 votes
1 answer
87 views

Should I skip some migrations on production in case of migrating a legacy database that has not been generated via migration script?

I have a complex PostgreSQL database structure that is consisted with views, materialized views and foreign wrappers. The database schema is manually updated without any sort of migration script, ...
user avatar
3 votes
2 answers
188 views

For Evolutionary Database Tools like Flyway or LiquidBase, it is better to integrate the tool or left it as a stand alone step in the CI process?

Although I believe my question is language and DB agnostic, I will provide the specifics technologies in this case study because it might help understanding my question (sorry for my English). It's ...
user avatar
3 votes
0 answers
44 views

Moving application control flow from NiFi to code

We currently have an application that is nominally written in Java/Spring boot, but all of the control flow is in NiFi. For example, there are the following layers in the java application: ...
user avatar
  • 293
0 votes
0 answers
18 views

Should I do migration testing if the new library needs a different testing suite?

I'm using a pretty old library to make server requests which is not properly tested and it not really matching nowadays requirements, so the plan is to migrate to a new one over the next release. So ...
user avatar
0 votes
1 answer
161 views

Should we do data migration from Oracle via the microservices, or should we do direct data migration from Oracle to Azure SQL DBs?

We are replacing a legacy application that runs on a single Oracle DB, and the decision has been made to replace it with a microservices-based application running on Azure SQL. Do we do data ...
user avatar
6 votes
4 answers
625 views

Am I right in writing our own database migration/versioning software?

I have started work on writing a tool to version the database schemas we use at work and enable migrations under version control. My first research into existing tools turned out to be too cursory due ...
user avatar
0 votes
2 answers
306 views

Referencing Database Primary Keys from Codebase

I don't have a lot of experience with these kind of issues, but I feel I need to consult on this issue. The current codebase I'm working on is using what I consider to be a questionable technique to ...
user avatar
1 vote
1 answer
129 views

How to ease the pain of lack of diffs when using database migrations?

The pain that I've often felt when creating database migration files, is best described in this Speakerdeck: Sane Database Change Management with Sqitch. Paste entire function to new "up" ...
user avatar
1 vote
0 answers
51 views

dealing with state data in an incremental migration from large legacy application

I have a very large monolithic legacy application that I am tasked with breaking into many context-bounded applications on a different architecture. My management is pushing for the old and new ...
user avatar
0 votes
1 answer
346 views

Architecture for File migration from FTP to cloud service

We are building a new application for a client to manage their cases. They are already using their existing system in which they are storing files associated to the cases in an FTP folder. There is an ...
user avatar
  • 121
0 votes
1 answer
48 views

Descriptive short term for a field that has been set to read-only in anticipation of removal?

I'm currently writing a design to add the possibility to mark a field or attribute for an entity as read-only in preparation for imminent removal. The idea is that, once the field has been thus marked ...
user avatar
4 votes
3 answers
1k views

Should I merge database migrations together before release?

During the development process many migrations may appear. Is there any point to keep them instead of merging them all together? Let's take a look into a simple example. During development we ...
user avatar
  • 151
5 votes
1 answer
265 views

What to do with historical SVN branches after switching to GitFlow?

I am part of a team that has recently moved from an SVN repository to a Git repository, and have started using GitFlow. As I understand it, this means that in a perfect world, the minimum number of ...
user avatar
2 votes
2 answers
424 views

Migrating from legacy database schema, rewrite legacy or sync to new

We're currently in the process of designing our new version of an existing application. This new version will not reuse any existing code as the old code is over 10 years old and tightly coupled. ...
user avatar
2 votes
4 answers
1k views

What is the operational benefit to separating database migrations and code deployments?

Should Database migrations be in included in the same deployment project as the code? If they are not included in the same deployment, the Database deployment package and the Code deployment package ...
user avatar
0 votes
2 answers
578 views

Migrating an Application from SQL to NoSQL [closed]

I am faced with taking a mvce's for SQL which happens to be the WideWorldImporters Database from Microsoft and migrating it to a NoSQL on mongodb. The system in question may use certain fractions of ...
user avatar
2 votes
1 answer
203 views

Recommended methodologies for refactoring a large ISAM based DB structure to a RDBMS?

I'm meeting quite a challenge. We have an old grown software with mostly Delphi applications, and an underlying ISAM database server (ADS)1, used with a lot of free tables and manually programmed ...
user avatar
0 votes
1 answer
151 views

How to prepare test case for System Migration of legacy system while existing functionality is unclear?

I am migrating a legacy system from Oracle Form to Web Application. The migration is conducted with code study and interview. As the requirement is to migrate the existing system to Web application ...
user avatar
  • 349
3 votes
2 answers
2k views

How to approach the understanding, documentation and validation of legacy code [duplicate]

I've been tasked with studying a Python code, which runs on an orchestrator, which schedule the launch of the code in correspondence of some events. The code imports some modules, and it's basically ...
user avatar
  • 221
2 votes
1 answer
166 views

Gap between Code base and Production application

Background I joined a company as a solutions architect less than a year ago, with a main task of consolidating, and modernizing legacy code resulting from 90+ company acquisitions over the past 20+ ...
user avatar
  • 584
5 votes
5 answers
651 views

Is it a fallacy to say that system migrations don't suit an agile methodology as the requirements are known up front?

I saw a project manager recently stand up at an Bank's internal staff meeting and say: We're running this system migration not using an agile methodology. We know the requirements up front so agile ...
user avatar
  • 4,761
-3 votes
1 answer
146 views

Should I rebuild to use latest tech?

I am a full stack developer in a very small company. It has a custom built ERP software using PHP 4 (no framework). Currently, it works fine from the business point of view except for some bugs here ...
user avatar
  • 11
0 votes
1 answer
82 views

Are there established techniques for incrementally migrating the data of an existing application to a new application?

I'm working on a project in which we are incrementally replacing an existing application. By incrementally I mean some features will be developed and shipped in the new application, and those features ...
user avatar
  • 305
3 votes
3 answers
454 views

Designing new system to replace legacy: Would you start with a new database and maintain both independently until the switch? [closed]

We have a legacy system which will eventually be deprecated, at which point we will switch to using a new system. What are the pros and cons of maintaining separate databases for the old and new ...
user avatar
3 votes
5 answers
2k views

Convert a team from VB.Net to C#.Net

I am currently running a team of 5 VB.Net developers and have decided to make a switch to C#. The team builds and maintains around 20 different applications that run our whole platform, so the code-...
user avatar
2 votes
1 answer
1k views

What are the best practices to ensure that Code Migrations work well in a team environment where there are multiple databases?

We're just starting off with using Entity Framework Code First approach and I'm playing with the Code Migrations system. So we were wondering, are the migration files intended to be treated as ...
user avatar
  • 2,684
13 votes
1 answer
977 views

Sharing parts of a monorepo

We currently have a complex and inefficient build system consisting of many SVN and Git repos (about 50% each), including one which is a git submodules repo. We also have homemade scripts that manage ...
user avatar
  • 239
4 votes
1 answer
100 views

Need help with system migration plan

I need to rewrite old ASP.NET web forms VB application to new ASP.net mvc in c#. Problem is that most of the old application logic for data inserting retrieval is written in stored procedures, which ...
user avatar
  • 525
1 vote
0 answers
107 views

Migrating to Java 8: How can I scan the project and report that an expression can be replaced with a lambda equivalent?

There is a current project which has many lines of code and written for Java 6-7. I want to migrate it to Java 8 and use lambda expressions wherever I can. How can i scan the project and report that ...
user avatar
  • 159
2 votes
2 answers
208 views

How to improve version control on database structure when migrations take long?

I am working with a team of web developers. We are already using Git for version control of our code and it works well. However, while we are changing our code, it is also common to change the ...
user avatar
  • 607
0 votes
1 answer
594 views

Using DB migration tools within a Virtual Machine with Vagrant

I am setting up Vagrant with multiple developers using ScotchBox (v2.5) in our workplace, I have got the initial vagrantfile working ok however I'm unsure of how best to handle Database migrations. ...
user avatar
  • 167
-1 votes
1 answer
63 views

Defining a DB schema and having existing schema conform to it? [closed]

I see a lot of DB migration tools that have up/down functions that deploy/revert DB schema changes. I have never seen a migration tool where you simply define the schema and it modifies your current ...
user avatar
  • 101
11 votes
4 answers
2k views

Should we use a monorepo?

My team is planning a migration from subversion to git. We support 3 applications... 1 is primarily for internal users, 1 is for corporate "partners" and 1 is for end users. These applications share ...
user avatar
  • 6,917
3 votes
1 answer
323 views

Django Migrations: Binds data to code?

If you have custom code for models (custom validators and custom fields are examples), Django Migrations will import them directly into the migration files. An example: file web/models.py def ...
user avatar
  • 415