[Ultralite] Order of sync upload

[Former Member]

Hello everyone,

How the order of Ultralite sync upload is determined? I mean, if I have two tables, A and B, not refering each other, which table is synced first? The first one declared in the database schema xml (which I use to generated the UDB)? The order of the publication definition?

I'm asking this because as parte of some techincal decisions, we didn't create a FK in which A refers to B, and we want to understand this to avoid A being synced before B.

Ps: Please, let's not discuss why we're doing in this way, we're already having this discussion internally for days =p

[chris_keating]

We do not have a documented table order but we do try to ensure that child records come before parent records.

You can use the TableOrder synchronization parameter to ensure a specific table order.

[former_SQLA_member1694876]

The table sync order is the order from the internal schema representation (after ensuring order for foreign keys). This probably matches your xml order and is stable (perhaps aside from DDL statements), but if you have a requirement you must use the TableOrder parameter. As Chris said we don't guarantee the order and it could change (aside from restrictions from foreign keys).

[Former Member]

Tks Tim by your comment!

[VolkerBarth · Accepted solution]

Have you had a look at that topic from the v12 doc set?

Table order in UltraLite

It does not really answer your question (i.e. how the default order is determined when there are NO FK relationships) but it does tell a way to specify the order by yourself by using the "TableOrder" parameter.

[Former Member · Accepted solution]

This seems to be a solution to our problem, but what about the default? is it random?