Ax 2012 Contoso Demo Data Download
CLICK HERE https://cinurl.com/2tzeDZ
How to Download and Import Contoso Demo Data for Microsoft Dynamics AX 2012 R3
If you are looking for a way to test and demonstrate the features and capabilities of Microsoft Dynamics AX 2012 R3, you might want to use the Contoso demo data that is available for download from Microsoft. The Contoso demo data is a set of sample data that represents a fictional company that sells bicycles and bicycle components. The demo data includes customers, vendors, products, transactions, and more.
In this article, we will show you how to download and import the Contoso demo data for Microsoft Dynamics AX 2012 R3 by using the Test Data Transfer Tool (beta). This tool is a command-line utility that lets you transfer data between Microsoft SQL Server databases.
Prerequisites
Before you start, make sure you have the following prerequisites:
A development, test, or demo environment of Microsoft Dynamics AX 2012 R3. Do not perform this procedure in a production environment.
A database server that hosts the AX 2012 R3 business database for your environment.
Read access to the location where the Contoso demo data is stored.
Permission to execute SELECT and BULK INSERT statements in SQL Server Management Studio.
The Test Data Transfer Tool (beta) installed on the database server. You can download it from the Downloadable tools section of Microsoft Dynamics Lifecycle Services.
Download the Contoso demo data
The Contoso demo data for Microsoft Dynamics AX 2012 R3 is available as a package that you can download from Microsoft Learn[^1^]. The package contains a folder named demodata that contains several subfolders with XML files. Each subfolder represents a table group in AX 2012 R3.
To download the Contoso demo data, follow these steps:
Go to Microsoft Dynamics AX 2012 Solution Demos Microsoft Learn.
Scroll down to the Demo Data Download section and click on Demo Data for Microsoft Dynamics AX 2012 R3 CU8 Solution Demo Package V1.0 (EXE) 282 MB.
Save the file to your computer and extract it to the database server that hosts the AX 2012 R3 business database for your environment.
Import the Contoso demo data
To import the Contoso demo data into your AX 2012 R3 business database, you need to use the Test Data Transfer Tool (beta). This tool reads the XML files from the demodata folder and inserts them into the corresponding tables in the database.
To import the Contoso demo data, follow these steps:
Go to Control Panel > Services and stop the AOS instance associated with your environment.
Using Windows Explorer, browse to the Test Data Transfer Tool (beta) folder. By default, it is located at C:\\Program Files (x86)\\Microsoft Dynamics AX Test Data Transfer Tool (Beta).
On the File menu in Windows Explorer, click Open command prompt as administrator.
At the command prompt, enter the following command to import the Contoso demo data: dp.exe import \\\\location_of_demo_data \\\\Name_of_AX_business_database \\\\ServernameInstanceName
Replace \\\\location_of_demo_data with the path to the demodata folder, \\\\Name_of_AX_business_database with the name of your AX 2012 R3 business database, and \\\\ServernameInstanceName with the name of your SQL Server instance. For example: dp.exe import e:demodata MicrosoftDynamicsAX localhostSQLExpress
Wait for the import process to complete. It may take over 30 minutes depending on your system configuration and network speed.
If you encounter any issues during the import, you can open the log file DPLog.xml that will be created in the folder where you ran the 061ffe29dd