New answers tagged

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,509
0 votes

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

DBA TOOLS! https://dbatools.io/commands/ (specifically those under Migration)
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
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
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
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
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 ...
user avatar

Top 50 recent answers are included