Loading...
Copy specific tables and sequences from prod to dev. Best for refreshing a single application's data without affecting other teams.
Most CommonCopy an entire schema (all tables, sequences, views, etc.). Use this when you need everything from a schema, not just specific tables.
LargeReplace the entire dev database with a copy of prod. This deletes all existing dev data. Requires team lead approval.
DestructiveSCHEMA.TYPE.NAME — TYPE is TABLE, VIEW, SEQUENCE, or MATERIALIZED_VIEW. If filled, this overrides the schema/tables above and lets you mix schemas and object types in a single refresh. Example: BACKEND_OWNER.TABLE.SHOWPROGRAM, MSDE_OWNER.SEQUENCE.HIVE_REQUEST_KEY| Job ID | Type | Mode | App Group | Status | Size (MB) | Duration | Date |
|---|