List of table in AX 2012 should be backuped while restoring the database

List of table in AX 2012 should be taken backup while restoring the database

Table Names:

How to restore the DB Form Source to 

Destination in Microsoft Dynamics AX 2012 R3

Objective: Main Objective is to save the system tables/settings

Like EP, BI, SSRS, User Info and Etc…

Step 1: Open Source Environment Database via SSMS

Step 2: Create a Local folder to store the DB files

Step 3: Backup Source Environment Database

• ·         Stop AOS (Backup can also be taken without stopping the AOS)
• ·         Perform full database backup via SQL

Step 4: Backup Destination Environment Database

• ·         Stop AOS (Backup can also be taken without stopping the AOS)
• ·         Perform full database backup via SQL

Step 5: Backup System Configuration Tables in the destination environment

Select the database MicrosoftDynamicsAX

Select > Tasks > Export data

Follow this:

Select the Server Name here in our case LocalServer

 Choose Destination Database (create new database) click New>

Type database name and click OK.

This database will contain the backup of the tables which are needed to be backed up for the destination environment.

Click OK>

Click Next>

Click Next>

Select all the tables needed> Use Page down Key from your keyboard.

Select all the system tables from the list below and then click Next>

Full list of system tables for AX2012 R3 (include or exclude user-related tables – marked as Optional – depending on whether you want to keep the user setup or not):

Click Next and Finish

Note: 11 Total may not be as per your need.

Step 6: Restore source database backup to the destination database

Database restore from a backup (WITH REPLACE)

Note: ensure data and log file names are correct.

Step 7: Import data from the new database created in Step 5

Select the database MicrosoftDynamicsAX and click Tasks > Import data

Select the Server Name as LocalServer.

Select System Parameter form the Database Drop down and click Next>

Choose destination (select destination environment database) and click Next>

Click Next>

Just Check the Database Name is correct or not.

Next>

Select the Tables from top> all will be selected automatically>

Select Edit Mappings> Check Delete option> Click Ok.

Click Next> Next> Finish!

Click Close

Step 8: Start and synchronise

·         Start the AOS

·         Open the AOT Synchronise dictionary in the destination environment.

Happy DAX Infra!