0

How to make a smaller save size with an archived database?

I needed to split tables off of an original database, so to do this I took the original database, made a backup, and then imported the archive using a different name and then deleted the tables I didn't want in both of the databases. The only problem with this is the save file is way too big to be split from the original database. So how do I reset the databases to make the save/backup files smaller?

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • I already tried the "Clear History" and "Rebuild Index" tools with no luck.

    Like
    • Sean
    • Sean
    • 3 yrs ago
    • Reported - view

    In the home screen of your database file you can choose "Export data". You'll see a popup dialog that lets you choose from CSV export, Excel export and Ninox. Choose Ninox and you can select which tables you want to export to a new database.

    Like
  • I'm not sure if i'm missing something, but all it has is new table and import data.

    Like
  • And i do have the permissions to export

    Like
    • Sean
    • Sean
    • 3 yrs ago
    • Reported - view

    Which platform are you using Ninox on? I'm using it on macOS.

     

    Screen Shot 2019-02-05 at 9.43.58 AM

     

    Screen Shot 2019-02-05 at 9.44.48 AM

    Like
    • wstarnes
    • wstarnes
    • 3 yrs ago
    • Reported - view

    I want to export an ENTIRE TABLE, but I cannot figure out how to navigate to this "Export data" screen with all these option to export each table.  I can, however, export a "view" from a table.  I'm using the web-based edition, if that matters.  Thank you in advance for your help!

    Like
  • I think the above screen only applies to the IOS stand alone version for Mac. You can however make a backup of the entire database by clicking next to the database-icon (on the top-right of it). There you can chose to make a backup...

    Like
    • wstarnes
    • wstarnes
    • 3 yrs ago
    • Reported - view

    Thanks.  That is what i suspected.  I am familiar with backing up and downloading a backup, but was hoping to get a complete table into Excel WITHOUT having to make a view with all of the fields.  Hopefully this function will be added to the online version at some point soon.  Cheers!

    Like
    • Mconneen
    • Mconneen
    • 3 yrs ago
    • Reported - view

    Well.. depending on your level of expertise.. Looks like you can consume a JSON feed within Excel / PowerQuery.. 

    https://support.office.com/en-us/article/connect-to-a-json-file-f65207ab-d957-4bf0-bec3-a08bb53cd4c0

    I have not tried it.. but seems plausable. 

    Like
Like Follow
  • 3 yrs agoLast active
  • 9Replies
  • 2437Views