Restore the database to the development VM using the.bacpac file

Step by step, as below:


1. Take a Backup of AxDB database from LCS and push it into Development VM


2. Open Command Prompt (Run as Administrator)

Run - cd "C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin"


3. Command to Execute


SqlPackage.exe /a:import /sf:C:\TEMP\YourDBBackupFile.bacpac /tsn:localhost /tdn:AxDB_DDMMYYYY /p:CommandTimeout=1200


Note: The process will take some more time


4. Open SQL and run the below script


CREATE USER axdeployuser FROM LOGIN axdeployuser EXEC sp_addrolemember 'db_owner', 'axdeployuser' 


CREATE USER axdbadmin FROM LOGIN axdbadmin EXEC sp_addrolemember 'db_owner', 'axdbadmin' 


CREATE USER axmrruntimeuser FROM LOGIN axmrruntimeuser EXEC sp_addrolemember 'db_datareader', 'axmrruntimeuser' EXEC sp_addrolemember 'db_datawriter', 'axmrruntimeuser' 


CREATE USER axretaildatasyncuser FROM LOGIN axretaildatasyncuser EXEC sp_addrolemember 'DataSyncUsersRole', 'axretaildatasyncuser' 


CREATE USER axretailruntimeuser FROM LOGIN axretailruntimeuser EXEC sp_addrolemember 'UsersRole', 'axretailruntimeuser' EXEC sp_addrolemember 'ReportUsersRole', 'axretailruntimeuser' 


CREATE USER axdeployextuser FROM LOGIN axdeployextuser EXEC sp_addrolemember 'DeployExtensibilityRole', 'axdeployextuser' 


CREATE USER [NT AUTHORITY\NETWORK SERVICE] FROM LOGIN [NT AUTHORITY\NETWORK SERVICE] EXEC sp_addrolemember 'db_owner', 'NT AUTHORITY\NETWORK SERVICE' UPDATE T1 SET T1.storageproviderid = 0 , T1.accessinformation = '' , T1.modifiedby = 'Admin' , T1.modifieddatetime = getdate() FROM docuvalue T1 WHERE T1.storageproviderid = 1 --Azure storage DROP PROCEDURE IF EXISTS SP_ConfigureTablesForChangeTracking DROP PROCEDURE IF EXISTS SP_ConfigureTablesForChangeTracking_V2 GO -- Begin Refresh Retail FullText Catalogs DECLARE @RFTXNAME NVARCHAR(MAX); DECLARE @RFTXSQL NVARCHAR(MAX); DECLARE retail_ftx CURSOR FOR SELECT OBJECT_SCHEMA_NAME(object_id) + '.' + OBJECT_NAME(object_id) fullname FROM SYS.FULLTEXT_INDEXES WHERE FULLTEXT_CATALOG_ID = (SELECT TOP 1 FULLTEXT_CATALOG_ID FROM SYS.FULLTEXT_CATALOGS WHERE NAME = 'COMMERCEFULLTEXTCATALOG'); OPEN retail_ftx; FETCH NEXT FROM retail_ftx INTO @RFTXNAME; BEGIN TRY WHILE @@FETCH_STATUS = 0 BEGIN PRINT 'Refreshing Full Text Index ' + @RFTXNAME; EXEC SP_FULLTEXT_TABLE @RFTXNAME, 'activate'; SET @RFTXSQL = 'ALTER FULLTEXT INDEX ON ' + @RFTXNAME + ' START FULL POPULATION'; EXEC SP_EXECUTESQL @RFTXSQL; FETCH NEXT FROM retail_ftx INTO @RFTXNAME; END END TRY BEGIN CATCH PRINT error_message() END CATCH CLOSE retail_ftx; DEALLOCATE retail_ftx; 


-- End Refresh Retail FullText Catalogs


ALTER DATABASE [<YOUR AX DB NAME>] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 6 DAYS, AUTO_CLEANUP = ON) GO


5. Stop following services

  • Management Reporter 2012 Process Service
  • Microsoft Dynamics 365 Unified Operations: Batch Management Service
  • World Wide Web Publishing Service


6. Rename DB


  • AxDB to AxDB_Orig
  • AxDB_DDMMYYYY (New Restored DB) to AxDB


Use Master run the scripts


GO 

ALTER DATABASE AxDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE AxDB MODIFY NAME = AxDB_orig ;

GO 

ALTER DATABASE AxDB_orig SET MULTI_USER

GO



GO 

ALTER DATABASE <Restore DB name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE <Restore DB name> MODIFY NAME = AxDB ;

GO 

ALTER DATABASE AxDB SET MULTI_USER

GO


7. Start the following services:


  • Management Reporter 2012 Process Service
  • Microsoft Dynamics 365 Unified Operations: Batch Management Service
  • World Wide Web Publishing Service


Build Model and Sync Database


Open the development environment URL and check once 

Comments

Post a Comment

Popular posts from this blog

How to customize electronic reporting in D365

Image
1. Overview This  Article  provides an overview of how to customize electronic reporting (ER) from scratch. 2. Basic customize.      2.1 Custom reporting configurations  Overview configurations Data Model Data Mapping configurations Format      2.2 Data Contract Extends ERFormatMappingRunBaseContract Specifies the data contract that should be used to run the configured ER format.      2.3 UI builder class Extends SysOperationAutomaticUIBuilder The provided code looks up only ER formats that contain a data source of the Data model type that refers to the data model by using the Root definition. Notes: ERCustomerModel = name of the data model. ERCustomerDataContainer = name of definition in Model to data source mapping (in image 2)      2.4 Data provider class           Used to run the configured ER format.      2.5 Report service class Extends SysOperationServiceBase Ca...
Read more

Build HTML and send email in D365 FO with X++

Image
1. Generate HTML  Note: If you want to add an attribute to a tag, you must follow the below rule: Use addAttribute before Next use renderBeginTag Exp: htmlTxtWriter.addAttribute("colspan", "9"); htmlTxtWriter.renderBeginTag('th'); htmlTxtWriter.renderEndTag();   Result: <th colspan = 9>   public void runNotificationExPicking() {              Query q;          QueryRun qRun;              QueryBuildDataSource qbds,qbdsProdJournalBOM;             QueryBuildRange               qbr,qbrJournalName,qbrJournalJournal;              InventTable            inventTable;              ProdTable                prodTable;    ...
Read more

Batch parallelism or multithreading in Dynamics 365 for Finance and Operations

Image
1. Create a contract class to define the container of the item  Notes: Do not use a list. It may cause the error: “no metadata class defined for data contract object” when the function’s running. Code: [DataContractAttribute] public class ABC_MaterialBalanceContract {        container conItem;      [DataMemberAttribute, SysOperationControlVisibilityAttribute(false)]      public container parmConItem(container _conItem = conItem)      {              conItem = _conItem;                return conItem;      } }    2. Create a service class to process extends SysOperationServiceBase    3. Create a controller class to call the service class (step 2) extends SysOperationServiceController   Code: class ABC_MaterialbalanceController extends SysOperationServiceController {      protected void new() ...
Read more

How to Enable/Disable a Form Button with X++

Image
To enable or disable button in form based on current selected record status through event handlers. Create a button or choose a button to enable / disable in form. Go to Form/Datasource/Events/OnActivated, right click and select "Copy event handler for OnActivated method".   Create new class NNT_WHSWorkTableFormEventHandlers class NNT_WHSWorkTableFormEventHandlers {     [FormDataSourceEventHandler(formDataSourceStr(WHSWorkTableListPage, WHSWorkTable), FormDataSourceEventType::Activated)]     public static void WHSWorkTable_OnActivated(FormDataSource sender, FormDataSourceEventArgs e)     {         #define.BTNNAME('YourButtonName')         WHSWorkTable whsWorkTable = sender.cursor();         FormRun element = sender.formRun();         FormControl YourButton = element.design(0).controlName(#BTNNAME);         YourButton.enabled(w...
Read more

How to create and run the Runbase batch class in D365

Image
In this article, you will learn how to create and run a batch class that extends RunBaseBatch in D365. A batch class is a class that can be scheduled to run periodically or on demand on the Application Object Server (AOS) or a client. A batch class must extend the RunBaseBatch class, which provides the methods and properties that the system needs to run the class as a batch job. Steps to create a batch class: 1. Open the Application Object Tree (AOT) in a development workspace and create a new class under the Classes node. Give it a meaningful name, such as MyBatchClass. 2. In the class declaration, add extends RunBaseBatch to indicate that your class inherits from the RunBaseBatch class. 3. Override the run method of the RunBaseBatch class and write your business logic in it. This is the method that will be executed when the batch job runs. For example, you can write code to query and update some records in a table. 4. Override the pack and unpack methods of the RunBaseBatch class and...
Read more

How to create and run the Runbase class in D365

Image
In this article, you will learn how to create and run a class that extends RunBase in D365.  Step by step, please see the below code: Create a class and extend runbase. In this case, i create the class with name as "SumCustomerTransaction". For example:  Here is the code for extending the runbase class: You can copy the code here: public class SumCustomerTransaction extends RunBase  {       DialogField      dialogAccount;       DialogField      dialogFromDate;       DialogField      dialogToDate;       CustAccount    custAccount;       FromDate           fromDate;       ToDate                 toDate;       #DEFINE.CurrentVersion(1)       #LOCALMACRO.CurrentList     ...
Read more

Difference between InMemory and TempDB tables in D365 F&O

Image
The difference between InMemory and TempDB tables in D365 F&O is: • InMemory tables are stored in the active memory of the tier where the process is running, either the client or the server tier. TempDB tables are stored in the SQL Server database as physical tables. • InMemory tables are instantiated when the first record is inserted, and are de-allocated when the record buffer goes out of scope or is set to null. TempDB tables are instantiated when the table object is created, and are dropped when the record buffer goes out of scope. • InMemory tables can be created by setting the TableType property of the table to InMemory, or by using the setTmp method on a record variable, or by setting the SourceTableTemporary property of a page. TempDB tables can be created by setting the TableType property of the table to TempDB. • InMemory tables can be joined with regular tables, but cannot have foreign keys, indexes, or methods. TempDB tables can be joined with regular tables, and can ha...
Read more

Customize the standard excel template in D365FO

Image
1. Create extensions for data entities: LedgerJournalLineEntity and LedgerJournalHeaderEntity. 2. Create extensions for the staging table: LedgerJournalLineCDSStaging, LedgerJournalHeaderCDSStaging 3. If you want to add dimensions to Excel templates In Microsoft Visual Studio, click Dynamics 365 > Addins > Add financial dimensions for Odata. Type the name of the Financial dimension in the Dimension Name column. This should be the exact name of the financial dimension. Select the Model that has your extensions. It should be above the AppSuite layer. Click Apply Add 2 extensions, DataEntity into the project: DimensionSetEntity.DimensionIntegration, DimensionCombinationEntity.DimensionIntegration.   You must keep the extension name "DimensionIntegration" for the project to work properly. 4. Build and synchronize the project. 5. Open the standard Excel template, make modifications, and save it in a local path.  In our example, for the General Ledger Journal Excel template (...
Read more

How to create and run a batch class that extends RunBaseBatch in D365

Image
In this article, you will learn how to create and run a batch class that extends RunBaseBatch in D365. A batch class is a class that can be scheduled to run periodically or on demand on the Application Object Server (AOS) or a client. A batch class must extend the RunBaseBatch class, which provides the methods and properties that the system needs to run the class as a batch job. Steps to create a batch class: 1. Open the Application Object Tree (AOT) in a development workspace and create a new class under the Classes node. Give it a meaningful name, such as MyBatchClass. 2. In the class declaration, add extends RunBaseBatch to indicate that your class inherits from the RunBaseBatch class. 3. Override the run method of the RunBaseBatch class and write your business logic in it. This is the method that will be executed when the batch job runs. For example, you can write code to query and update some records in a table. 4. Override the pack and unpack methods of the RunBaseBatch class and...
Read more