Adding primary keys to tables in a SQL2K5 supporting Axapta
Posted on 2008-11-12
I'm attempting to set-up transactional replication in SQL2K5. When you attempt to create a publication and are creating articles, it is telling me that you cannot select tables that do not have a primary key.
This database is supporting Microsoft Axapta 3.0. I added a primary key to a table in SSMS. That part is easy. The problem is with Axapta, when you synchronize the database in the AOT Axapta removes the primary key.
Can someone tell me how to define a tables primary key in Axapta? I'm assuming you use the Data Dictionary in the AOT of Axapta.