Is it possible to save an empty copy of a database?
I'm using FM14 Pro - Do I need to upgrade to advanced to do this?
no, just "save a copy as" - clone (no records).
Beware though that you will lose the values stored in global fields. Probably not a problem for you. If it should be a problem, just import one record from the original database, then delete it.
siplus is right,
You do not need FM Pro Advance for this, but you can only save a clone (no records) of a database that is stored locally (meaning, you can't save a clone from a hosted file).
I have it hosted....does that mean I'll have to download a local copy then perform the "Save as" clone?
Or is there an alternative?
You can only save a copy if you have access to the server computer that is hosting the database. If you do, you can create a clone copy there, otherwise, the Save as... option is greyed out.
The other option, as you point out, would be downloading a copy from the server, in which case, you would be able to save as a clone., but this download may take a lot longer if you have a lot of records.
if it's hosted on a server, you should have backups made by the server. Since you only need a clone, grab any backup file and copy it locally, open it and save a clone.
Ok thank you, I don't have full access only a control panel which allows me to download a copy. I guess I'll download it, open it locally then save as.
Thanks for the replies
ricardocpa: it isn't clear how you suggest that this be done in the case of a hosted database. If you're suggesting that somehow you can open the file, on the server, with FileMaker, while not using open remote then - no, don't do that.
What you can do, if hosted AND if you have access to the server admin console:
Set up a backup schedule and select the option for it to create clones instead of backups. When setting up a backup schedule, you can choose which file(s) are to be backed up this way. You can also do this through the command line interface if you are comfortable with that.
Otherwise, yes, download a copy and locally do save as clone.
I concur with BruceRobertson and MarkBanin, if you can create the clone from a recent backup copy, all the better.
You can set up a server schedule to generate a clone back up.
Thanks for all the replies :-)
Retrieving data ...