Database operations

There are occasions when, instead of working on a particular data or configuration, you may need to work on the entire database. Such scenarios could come up while creating a environment and seeding it with the data from the golden environment, or while requesting Microsoft to use the database of the golden environment and populate production for the first time.

One must acknowledge the differences in the database platform when using Azure SQL and SQL on the premises. The process involves the following information flow when moving the database from Azure SQL to Microsoft SQL Server (on-premise):

As shown in the preceding image, there are some common steps in the database export and import process, and it leverages BACPAC (SQL backup files) files.

Note

For more details, refer to the following links:https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/copy-database-from-sql-server-to-azure-sqlhttps://docs.microsoft.com/en-us/dynamics365/unified...