DATA/SCHEMA REPLICATION IN HYPERSCALE
Janice Chi
620
Reputation points
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
- 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?
- 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
Azure SQL Database
An Azure relational database service.
Sign in to answer