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 ...
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 ...
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.
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 ...
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 ...
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 ...
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 ...
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&...
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, ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
migration × 846sql-server × 336
mysql × 169
postgresql × 149
oracle × 102
sql-server-2012 × 51
sql-server-2008-r2 × 41
sql-server-2008 × 37
backup × 31
sql-server-2016 × 30
replication × 29
restore × 24
sql-server-2005 × 23
mongodb × 22
schema × 22
mysqldump × 22
mysql-workbench × 21
database-design × 19
mariadb × 19
oracle-11g-r2 × 18
amazon-rds × 18
upgrade × 18
sql-server-2014 × 16
innodb × 16
performance × 15