Duplicate

Duplicate Metadata Objects

The Duplicate function in AnalyticsCreator allows you to create a copy of an existing metadata object with all its configurations. This is particularly useful when defining similar roles or deployment settings across multiple domains or environments.

Duplicate Role

Duplicating a role allows you to quickly replicate row-level security definitions. This is useful when you need to define similar access rules across different user groups or business areas (e.g., Finance vs. Sales).

How to Duplicate

  1. In the Navigation Tree, go to Roles.
  2. Right-click the role you want to duplicate.
  3. Select Duplicate.
  4. Give the new role a name and modify filters or permissions as needed.

Use Cases

  • Apply similar security logic across departments
  • Create variations of a base role for testing
  • Standardize access models across galaxies or stars

Duplicate Deployment

Duplicating a deployment allows you to reuse an existing configuration — such as environment settings, DACPAC output paths, or schema mappings — for another deployment target (e.g., Dev, Test, Prod).

How to Duplicate

  1. In the Navigation Tree, go to Deployments.
  2. Right-click the deployment definition you want to duplicate.
  3. Select Duplicate.
  4. Rename the copy and adjust environment-specific settings.

Use Cases

  • Create deployment pipelines for different environments
  • Test changes in a sandbox without altering the main deployment
  • Set up backups or rollback configurations

The duplicate feature saves time, ensures consistency, and helps maintain governance by avoiding manual reconfiguration of similar objects.