Posts

Showing posts from December, 2012

A Simple example of migrating data using AX 2012 Data Migration Framework

Image
This topic explains in detail and illustrates a simple example of migration of data using the Ax 2012 Data migration framework. Before you begin, your environment must include the following components: A running version of Microsoft Dynamics AX 2012, along with Ax 2012 Data migration framework installed and running. Access to demo files which are copied to Program files during installation of Ax 2012 Data migration framework. (typically under path: "<root>/Program Files/Microsoft Dynamics AX 2012 Data Migration Framework Client Components (Beta)/DemoFiles") After the successful installation of Ax2012 DMF, there will be a new module 'Data migration framework' in the Ax module list with Area page as shown below. For an End-to-End scenario of Data Migration, the flow would be some thing like: Setup of Data migration framework Data migration framework parameters (form) --> to provide share folder path Source data fomats (form) -->...

Best Practises for use of Data Migration Framework

Image
Now that we have installed, troubleshooted and verified that installation of AX 2012 Data Migration Framework is completed successfully, lets move towards One Important best practise suggested by Microsoft. Microsoft states in DMFs user guide that: “Because the staging environment is highly normalized and may require significant processing bandwidth, we recommend that you increase the Maximum buffer size setting for your environment while you migrate data. Use the Server configuration utility to set the value.” If you want to take this advice of Microsoft, the below steps show how to do that. Launch the server configuration utility (Start menu > Administrative Tools > Microsoft Dynamics AX 2012 Server Configuration) , Click Manage > Create configuration... And in the opened dailog, fill Configuration name with any desired string as shown: And click ok. Now in the new configuraiton, Go to the database tuning tab, and change the buffer size from 48, to ...

Troubleshooting issues during an installation of the Data Migration Framework

#Issue 1: Error with Windows Installer package Setup will not install the Data Migration Framework service on a 64-bit computer without Microsoft Visual Studio 2010 installed and running. The installation fails with the error "There is a problem with this Windows Installer package. A program required for this installation to complete could not be run. Contact your support personnel or package vendor." Resolution Install the Microsoft Windows SDK for Windows 7 and .NET Framework 4 from http://www.microsoft.com/en-us/download/details.aspx?id=8279 . On the Installation Options page, select the following options, and then complete the installation. Under .NET Development, select Tools. Under Redistributable Packages, select Microsoft Visual C++ 2010. Open a command prompt with Run as administrator rights. Depending on which version of SQL Server is in your environment, run one of the following commands. For SQL Server 2012, run Command <System Drive>\Progra...

Step by Step installation procedure of Ax2012 Data Migration Framework (Beta 2)

Image
This topic describes how to install the Data Migration Framework for Microsoft Dynamics AX 2012, Beta 2 version. Before you begin, your environment must include the following components: A running version of Microsoft Dynamics AX 2012 that has been configured for your business. A running version of Microsoft SQL Server Integration Services that is running the same version of SQL Server that is hosting the Microsoft Dynamics AX business and model store database. Important: Because the staging environment is highly normalized and may require significant processing bandwidth, we recommend that you increase the Maximum buffer size setting for your environment while you migrate data. Use the Server configuration utility to set the value . Data Migration Framework components should be installed on: (You must run the installer locally on each computer) computers running Integration Services, on a computer running an Application Object Server (AOS) instance, and on a...

AX2012 Data Migration Framework

Image
What is AX2012 Data Migration Framework? It is an extension to AX 2012 that provides a way to migrate data from external sources to AX 2012. Data that you can migrate include master data, open stock and balances. Where can you download it from? The Data Migration Framework is available from the InformationSource services download page . (you will need an active Partner source ID to download this Beta 2 version) What are the advantages? The Beta 2 version of the DMF includes support for the following new features: ODBC connections as a data source. Microsoft Dynamics AX databases as a data source. You can now export and import Microsoft Dynamics AX, and copy company information by using Data Migration Framework entities. Direct table and composite entity types. A direct table entity enables you to migrate data from a source to a target Microsoft Dynamics AX table directly, without going through a staging table or applying any busin...