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.
113 questions
1
vote
2
answers
399
views
Migration pattern for logic too complex to cover it with SQL
When you create migration in EF Core you can spice it up with arbitrary SQL query. Yet there is a limit to it -- maybe the migration is too complex in technical sense (i.e the SQL cannot handle it) or ...
- 1,533
0
votes
1
answer
105
views
Referencing objects created during seeding by ID
I'm building a software that allows users to extract analytics from a data source. A subset of data periodically is extracted from the data source and stored in a separate database for ease of access (...
- 111
1
vote
2
answers
582
views
Synchronize data between old on premise application and new cloud system
Scenario/Context
There is an old monolithic desktop application (running locally) which uses ODBC to connect to SQL database (on premise). This desktop application should be replaced with a new web ...
- 119
3
votes
1
answer
196
views
Strategies for Adapting SQL-Based Data Retrieval to a Newly Introduced REST API in a Short Timeline
I'm in a pickle following a recent executive decision by our parent company. They have elected to abstract away our SQL data warehouse, transitioning to a REST API for data retrieval. The purported ...
- 61
0
votes
1
answer
93
views
sql migration - decoupling deployment from execution
We have a .NET c# solution that uses AliaSQL to run database migrations / to build the backend. I have a situation where we need to write some SQL Server logic that will
copy records from Table A to ...
- 581
0
votes
2
answers
466
views
Workflow for Writing Database Migrations for a Team
I am wondering what some possible workflows are for writing database migrations for a team of developers. We seem to run into a problem where one person writes a migration, names it and gives it a ...
- 109
0
votes
1
answer
322
views
Decoupling modules of a monolith
As part of an migration from .NET Framework to .NET Core we're looking to decouple elements of our monolith into more manageable modules. Ideally following a clean architecture/DDD/microservice ...
- 103
-1
votes
1
answer
199
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 ...
- 1
1
vote
1
answer
334
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 ...
- 144
0
votes
1
answer
256
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 ...
- 2,063
-4
votes
1
answer
55
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?
- 169
1
vote
1
answer
156
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 ...
- 127
21
votes
5
answers
2k
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 ...
- 319
-1
votes
1
answer
255
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 ...
- 59
0
votes
0
answers
90
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 ...
- 109