Modifier

Partager via

Align SQL table definitions

  • Article

For successful cloud migration and data upgrade, the on-premises source table objects and the corresponding online table objects must have the same definitions for the following properties:

  • Primary keys
  • Field names and data types

These properties are indicated by an asterisk * in the following code snippet:

table id **MyTable
{  
    fields
    {
        field(1;*MyField1; *Integer)
        {    
        }
        field(2;*MyField2; *Integer)
        {    
        }
    }
    
    keys
    {
        key(*Key1; *MyField1)
        {
            Clustered = true;
        }
        key(Key2; MyField2)
        {
        }
    }

Other properties of tables, like the following, are either not required to match or the difference can be handled by table mapping during cloud migration setup.

  • Different tables names can be handled by table mapping. In the previous code snippet, the table name is indicated by **.
  • Missing fields or extra fields in tables can be handled by table mapping
  • Different IDs aren't relevant and don't affect cloud migration
  • Different secondary keys aren't relevant and don't affect cloud migration

Note

These properties must match to upgrade Dynamics NAV to Business Central on-premises.

Next steps