Talk With an Expert
    February 24, 2017

    Microsoft Dynamics 365 for Operations Technical Series: Indexing

    Index Synchronization Issue Resolution

    Post #2: Trailing is a guide on how to resolve a Microsoft Dynamics 365 for Operations index synchronization issue. The issue is that once a developer has modified any table indexes without changing any field, the modifications will not be synchronized to SQL server, while Visual Studio synchronization procedure will not throw any error.

    For example, a new Table1 table with FiledString1 and FiledString2 was created and synchronized to SQL:

    After creating an index to the table, it will not be synchronized by Visual Studio with default settings. The interesting thing is that Visual Studio throws no error, it just ignores index modifications during synchronization regardless of the way the synchronization process was executed – project, model or full synchronization:

     

    Proper Way to Execute an Index Synchronization

    Visual Studio should be opened with FallbackToNativeSync = true. To change the FallbackToNativeSync parameter, go to following folder/file:

    In this file, locate the FallbackToNativeSync parameter and change it to true:

    After that, run Visual Studio once again and synchronize the table. Now the index should be synchronized properly:

     

    Enavate Recent Posts

    March 27, 2024

    The Costs and Benefits of Microsoft Dynamics 365 Business Central

    Microsoft Dynamics 365 Business Central is an agile ERP platform that allows small to medium-sized businesses (SMB) to enhance, grow, and scale their operations, allowing for... Read More
    March 15, 2024

    How to Reduce Warehouse Management Costs with Automation

    Way back in 2015, Supply Chain Management Review claimed that warehouse automation is one of the few remaining areas where companies can still significantly reduce their... Read More
    March 13, 2024

    How Business Central Helps You Stay on Task

    Anyone who has ever traveled by plane knows how stressful it can be to have a connecting flight. You must wait your turn to get off the first plane, figure out where your... Read More

    Subscribe to Receive Email Updates