Copy a Finance and Operations database from Azure SQL Database to a SQL Server environment 2017-8-8 13 min to read Contributors This topic provides information about how to export a Microsoft Dynamics 365 for Finance and Operations database from an Azure-based environment, and then import it to a SQL Server-based environment. Overview Moving a database involves using the sqlpackage.exe command line tool to export a database from Azure SQL Database and then import the database to Microsoft SQL Server 2016. Because the file extension for the exported data is .bacpac, the process for moving a database is commonly referred to as the bacpac process . The high-level process for a database move is: Create a duplicate of the source database. Run a SQL Server script to prepare the database. Export the database from the Azure SQL database. Import the database to SQL Server 2016. Run a SQL script to update the database...
Posts
Showing posts from August, 2017