UltraLite User's Guide
Developing UltraLite Applications
Designing your UltraLite database
By default, all tables in an UltraLite database are synchronized to the consolidated database. You can include tables in your UltraLite database that are excluded from synchronization, but you must explicitly identify these tables when you create your reference database.
Tables with names ending in nosync are excluded from synchronization. You can use these tables for persistent data that is not related to the consolidated database. Other than being excluded from synchronization, you can use these tables in exactly the same way as other tables in the UltraLite database.
You can alternatively use publications to achieve the same effect. For more information, see Designing sets of data to synchronize separately.