TABLE ISSUE IN AX 2009

Finance and Operations/AX Developer Forum
1

Hi All,

I have a table in SQL Server Database (SQL SERVER 2008 R2).

That table not exist in AOT—> Tables in ax 2009.

Now i need to get that table into AOT–>TABLES.

What are the possibles, please share with me.

Thanks in Advance.

2

Try to insert the table from AX 2012 database (table) to AX 2009 database(Table). Once you get the table in ax 2009, then automatically table would be available in your ax 2009 AOT.

3

Hi All,

I have a table in SQL Server Database (SQL SERVER 2008 R2).

That table not exist in AOT—> Tables in ax 2009.

Now i need to get that table into AOT–>TABLES.

What are the possibles, please share with me.

Thanks in Advance.

Hi Thanks for your reply,

First go through my problem, then give a reply.

Thanks.

4

Hi,

If u have AX 2012, try to figure out the table that u need. Because, SQL Server 2008 R2 will co-ordinate with AX 2012.

Then try to export that table from AX 2012 and import it back to AX 2009.

Hope this may helps u…!!!

Regards,

Zahir

5

Hello,

Please remember AX is the master and SQL server is the slave. Therefore when AX is synchronised, AX will overwrite existing schema in SQL database; and any objects that doesn’t exist in AX will get deleted.

I would suggest you to move the table existing in SQL server to inside AX.