John11
Reputation: 61
Dev Environment creation from Prod for Azure SQL
I have a production server in Azure SQL. I have created a another empty server(dev) for development purpose. I need a copy of the tables, views, stored procedure in the dev server as well. Please suggest some way to transfer the data to dev server database
Upvotes: 2
Views: 222
Answers (1)
Pratik Somaiya
Reputation: 733
@John11 : You can take a backup of your Production Database and then simply restore on your Dev server
Ideally Production data restore to Dev is not advisable if it is a highly confidential data
If you just need to move the schema without data then you can use DevOps / CI-CD to deploy the artifacts to Dev
Upvotes: 1
Related Questions
- How to separate development and production environments in Azure?
- How to create a Dev/Test environment on Azure SQL Database?
- Azure SQL Database Development Environment
- Creating a test or stage database from a production database in Azure
- Azure SQL Database sandbox based on production
- Options or setting up a test environment in Azure
- Right way to create staging and Prod environment in Azure
- Setting up sharepoint dev environment on azure?
- Local DB for development and SQL Azure DB for production
- Setting Up Windows Azure End To End Development Environment