The following steps are used to transfer data from one transaction db to other. Generally it would be used when we need Production data in our Dev/Test environment.
Note: Data Transfer Tool should be installed
• Login to SQL server
• Restore Transaction & Model databases backup [Source]
• Open Command prompt as administrator and Navigate to C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta) folder [In the server DTT installed]
• Run following command to export data
DP.exe EXPORT C:\[FolderName] [RESTOREDDBNAME] [SQLSERVER]
[Data will be extracted as files in the mentioned folder]
• Stop AOS of the destination instance
• DP.exe IMPORT C:\[FolderName] [DESTINATIONDBNAME] [SQLSERVER]
• Start AOS
Note: You need to reset your SID after restored if two instances are running in different active domain directory.
Regards,
Arun S. Keerthi
Note: Data Transfer Tool should be installed
• Login to SQL server
• Restore Transaction & Model databases backup [Source]
• Open Command prompt as administrator and Navigate to C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta) folder [In the server DTT installed]
• Run following command to export data
DP.exe EXPORT C:\[FolderName] [RESTOREDDBNAME] [SQLSERVER]
[Data will be extracted as files in the mentioned folder]
• Stop AOS of the destination instance
• DP.exe IMPORT C:\[FolderName] [DESTINATIONDBNAME] [SQLSERVER]
• Start AOS
Note: You need to reset your SID after restored if two instances are running in different active domain directory.
Regards,
Arun S. Keerthi
No comments:
Post a Comment