New answers tagged migration
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 ...
- 6,509
0
votes
Migrating SQL server to new hardware - restore msdb vs scripts job?
DBA TOOLS!
https://dbatools.io/commands/ (specifically those under Migration)
- 31
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 ...
- 18.3k
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 ...
- 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&...
- 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, ...
- 2,491
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 ...
- 346
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 ...
- 131
0
votes
What exactly does `GRANT, REVOKE, and DENY Permissions on System Objects` mean?
That script will transfer the Server level logins (#1), but not the database permissions (#2). It's done that way because the database may not exist on the destination server. System Objects ...
- 149
Top 50 recent answers are included