Table synchronization errors

You can try following method to solve almost any table synchronization error:

- At SQL server rename table and append 2 at the name. Clustered index of table should also be renamed (table name -> Indexes node -> name (clustered) ).
- Synchronize table in AX. Which should create clear table at SQL server.
- Pull data from table with postfix 2 to newly created table using INSERT ... SELECT statement and make any data transformations if required.
You can use right click on table in SQL serve -> Script Table as -> INSERT to and SELECT to, to automatically create required statement.
INSERT .. SELECT should look like:

INSERT INTO [dbo].[INVENTITEMGROUP]
           ([ITEMGROUPID]
           ,[NAME]
           ,[STANDARDITEMALLOCATEID]
           ,[TAXITEMGROUPIDSALES]
           ,[TAXITEMGROUPIDPURCH]
           ,[DUEDATELIMITGROUPID_ES]
           ,[ASSETGROUP_IN]
           ,[LOADTEMPLATEID]
           ,[MODIFIEDDATETIME]
           ,[DATAAREAID]
           ,[RECVERSION]
           ,[PARTITION]
           ,[RECID])
SELECT [ITEMGROUPID]
      ,[NAME]
      ,[STANDARDITEMALLOCATEID]
      ,[TAXITEMGROUPIDSALES]
      ,[TAXITEMGROUPIDPURCH]
      ,[DUEDATELIMITGROUPID_ES]
      ,[ASSETGROUP_IN]
      ,[LOADTEMPLATEID]
      ,[MODIFIEDDATETIME]
      ,[DATAAREAID]
      ,[RECVERSION]
      ,[PARTITION]
      ,[RECID]
  FROM [dbo].[INVENTITEMGROUP2]
GO

---

Support The Author

 If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee