Is there a way to reset an Ultralite database to make it a "new", clean database? I accomplish this in an SQL Anywhere database by dropping the synchronization user and recreating it, but I have not been successful with accomplishing this in Ultralite.
The reason I want to do this is to be able to reset the database for a new set of data.
asked 13 Dec '13, 16:47
By dropping the MobiLink user in SQL Anywhere, you are essentially dropping the synchronization subscripton from that user to the publication. Since there aren't 'synchronization subscriptions' specifically in UltraLite, the only object that keeps track of data to be synchronized are the database publications. You could potentially drop those if you wanted to 'forget' the current set of data to be synchronized.
However, if you're talking about resetting an UltraLite database that has fallen out of synchronization due to "progress mismatch" messages, you may want to try the