DATA/SCHEMA REPLICATION IN HYPERSCALE

Janice Chi 620 Reputation points
2025-08-29T08:49:34.93+00:00

We have an existing schema in our Azure SQL Database that contains several hundred tables. Some tables contain data while others are empty. Our requirement is

  1. to create a new schema in the same database that replicates the full structure of the existing schema. The new schema should include all tables, constraints, keys, indexes, and relationships, but without copying any of the data. Could you please advise on the most efficient and reliable way to achieve this using SSMS or supported Azure SQL tooling? please tell complete steps , any limitations etc?
  2. to create a new database altogether which replicates the full structure of the existing DB and all schema and data inside them?please tell complete steps , any limitations etc?
Azure SQL Database
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.