Modifica

Database movement toolkit

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The Database movement toolkit is a ZIP file hosted in Microsoft Dynamics Lifecycle Services. You can download this toolkit. It contains a series of scripts that enhance the customer experience for moving data between developer environments and sandbox environments. This article explains the components of the toolkit, how to download it, and any recent changes.

Download the latest version

You can find the toolkit in the Lifecycle Services Shared Asset Library under the Models section. Search for the entry titled Database Movement Toolkit and then download it to your Tier1 DevTest environment.

Toolkit components

The toolkit contains the following primary components:

  • Sqlpackage.exe - This tool performs extract and publish actions against Microsoft Azure SQL databases, and SQL Server databases hosted on Tier1 DevTest environments.
  • PowerShell 7.0 - A self-contained version of PowerShell that includes capabilities for parallelism, which increases the performance of transferring data between environments.
  • PowerShell script - Several scripts provide an enhanced and more automated experience for scenarios such as AX 2012 data upgrade.

Supported scenarios

The toolkit currently supports the following scenarios. More scenarios will be added over time.

Versions

Version 5

Feature Details
Schema publish Added CleanupSource and CleanupTarget scripts.
Data transfer Added timer to capture transfer time.

Version 4

Feature Details
Schema publish Minor improvements.

Version 3

Feature Details
Schema publish Fixed the scripts to output errors in PublishDiag.log.

Version 2

Feature Details
Schema publish Fixed the scripts to use current directory reference to Sqlpackage directory.
Schema publish Fixed the scripts to delete local users from the source database, and tidy up environment-specific tables.
Data transfer Fixed the scripts to install missing PowerShell modules.

Version 1

Feature Details
Initial Toolkit uploaded to Lifecycle Services Shared Asset Library.