D365 Export Database from LCS UAT Or Production and Restore in the Dev Environment
Export database UAT or Production over LCS: Login LCS with lcs.dynamics.com and enter your authorized credential for export UAT or Production database bacpac file. Follow these steps to export and restore database over development machine: Step I: Go to LCS. From sandbox Environment Details page, click the Maintain menu, and then select Move database. Select the Export Database option. Database will export as bacpac file to the Database backup option in the Asset Library. Step II: Check your Directory Path for SQLPackage.exe installer it may be over 150 or 140 folder it’s depends upon versions. Step III: Note: Restore Database File is your Backup File. SSProd your current name database you can change as per AXDBUAT Paste your Downloaded bacpac file to known folder which you will redirect through CMD. Run CMD as a administrator. Cd C:/ cd Program Files (x86)\Microsoft SQL Server\150\DAC\bin SqlPackage.exe /a:import /sf:J:\Exportedbacpac\RestoreDatabaseFile.bacpac /tsn:...