3 votes

The term Database Migration

Personally, I understand database migration the same way as you. However, I am not sure whether there is a single formal definition. Possibly like many other computing jargon, every one has their own ...
user avatar
  • 131
2 votes

Does the DMA tool support an online migration for on-prem source and on-prem target?

By online I mean that the source db can be used while the migration is happening. Yes it would be accessible but make sure you do not do any write operation on it during migration. Read operation ...
user avatar
  • 18.3k
2 votes

What permission must the user have on source and target on-prem servers for DMA assessment and migrate to work correctly?

From the same document, it is mentioned as below: https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15#prerequisites Not sure, if you needed something else.
user avatar
2 votes

What is the implication at attempting an attach without detach?

However this migration link recommends an attach without any mention about detach. You are not reading it correctly, the attach here means any database for which mdf file is present. A classic case ...
user avatar
  • 18.3k
2 votes

The term Database Migration

The word migration can mean "movement from one part of something to another". What you describe (see the answer from Fat P) is a schema migration. Speaking from personal experience in the ...
user avatar
  • 346
1 vote

Postgres equivalent of Oracle's RMAN.VALIDATE_DATABASE

The procedure tries to ensure that the backup pieces available can be used to restore the database. I don't know if there's any equivalent for PostgreSQL. However, the only way to be absolutely ...
user avatar
  • 6,499
1 vote

Migrating SQL server to new hardware - restore msdb vs scripts job?

When migrating SQL server (same version) to new hardware, what are both options feasible? (that is restore of master/msdb or scripting)? As already stated on one of your questions, if the version and ...
user avatar
  • 18.3k
1 vote
Accepted

The term Database Migration

While the two sets of tools are generally distinct, I think it can be argued that they both mean the same thing by "migration". For application code, we generally talk about "deployment&...
user avatar
  • 395
1 vote

The term Database Migration

Not mentioned (yet) when talking about a 'migration' between different database products: (some level of) training of personnel in order to facilitate ... conversion of database-level SQL code (eg, ...
user avatar
  • 2,491

Only top scored, non community-wiki answers of a minimum length are eligible