AX2012 – Interview with Kees Hertogh – Microsoft’s Dynamics AX Product Director

Here is excerpt from Questions and Answers about AX2012 with Kees Hertogh . The key points  of the discussion regarding AX2012

1.  Windows XP will not be supported as Client OS. Windows Vista and Windows 7 will be supported.
2.  The objects in AOT will be accessible through Visual Studio to provide more .NET Interoperability and will support full intellisense for AOT objects from Visual Studio.
3. More document detailing out the Chart of Account/New Dimensions strcuture will be available in Q2 of this calender year.
4. The CRM 2011 Beta Connector for AX2012 has been releasead and right now in premises and in the cloud.

Refer below link for more details

http://www.cognitive-group.com/35/news.html

SQL Database restore from 2000 to 2005

During my current assignment , I was working on SQL Server database restore from an old SQL Server DB to SQL 2005 . Here are few things you need to consider .

First of all plan what  additionals Service Packs for new version you need based on SQL 2005 Version. Use the following statement to get curent version of your SQL Server.                                                                                                                                

SELECT  SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

1. Consider Database  Collation in previous and new version.
2. Create a Back up (.dmp file) from source database.
3. Define the path of Database (.mdf file) and Log File ( .ldf) file under Database  Options (Properties) for database .
4. Restore the back up using “Add device”  and select the .dmp File .
5. Verify the data after restore .

As an alternative step you restore Database from Transact SQL also . But I personally prefer SQL Server Management Studio 🙂

Paging using QueryRun Class in AX

You can override the  method of Queryrun Class to enable paging for Queries in AX2009.

 public void applyValueBasedPaging(Common sourceCursor, [boolean isForward])

There is  another variant of this method for position paging.

 

 public void isPositionPagingEnabled(Common sourceCursor, [boolean isForward])