I would like to know if it is possible to decrease the total size of the NF Database. We have some notebook-users who replicate over a phone-line. The notebooks have limited storage-capacity. The current size of the database is about 1 Gb. Most users need only part of the database. The database consists of multiple companies, of which for most notebook-users only one or two companies are needed. My idea was to copy the complete database to the notebook, delete the companies that are not needed, and then compact the database so it’s size would decrease. Only problem is, how to decrease the size…
Will your laptop users be using the data in a “read only” capacity? Navision databases (even the SQL versions) don’t replicate.
You can’t decrase database size directly. But you can’t use following metodology: A) copy fdb, delete all redundant data. Make backup. Create new smaller fdb and restore data. B) Make smaller fdb replicate all needed data to this fdb.
The notebook-users will be replicating. The implementer has provided a dos-utility with which a user can replicate the changes to the database, and he receives the changes that have been made in-house… They can read and write to their copy of the database.