3 Replies Latest reply on Feb 24, 2015 3:20 PM by philmodjunk

    Moving database from local machine to server



      Moving database from local machine to server


      I am nearing completion of a long-term database build, and first wanted to say thanks to PhilModJunk and the others on this valuable forum. I have asked nearly 70 questions, each of them answered quickly and thoughtfully. Thank you!

      The database has thus far been only used on a single machine. In the next few days, I will be moving it over to a Mac Mini running Filemaker Server 13. Is there anything I should watch out for when making the move? Some questions I can think of:

      1) Do all fonts used need to reside on the server machine, or is being on the user machines enough?
      2) Do third party plug-ins run on the server or the client machines?
      3) I have several PDF creation scripts. They get written to Get(TemporaryPath), which I assume will still work fine, but also to the user’s desktop. I believe Get(DesktopPath) refers to the user’s desktop, so this should still work fine. Is that correct?
      4) PDFs are currently being stored in the database, but I would like them to be referenced once the database is on the server. Is that a simple matter of turning on “Store container data externally” in the container field options dialog?

      Anything else to be aware of?


        • 1. Re: Moving database from local machine to server

          1) just client side, you'll find that there is no option for installing fonts on the server.

          2) That depends on the plug in. Some need to be installed on the server, others on the client, I recommend researching/discussing each such plug in on the site of the developer who produced the plug in.

          3)  Both TemporaryPath and DesktopPath are get function parameters that refer to locations on the client's machine. Both could, however, refer to locations on the server machine as well if a script using them is run from a "server context". This can be done by using a server admin schedule to run a script or by using the Perform Script On Server script step.'

          4) If the files are currently embedded in their container fields, changing the storage option on the field to external will cause FileMaker to copy the images to the specified storage location and then update the container field to reference the copy stored at the external storage location. Don't try inserting new files with the "store a reference" check box selected as this is a different method not intended for use in a container field with external storage.

          • 2. Re: Moving database from local machine to server

            Thanks, Phil. Regarding answer 4, I don't see the "store a reference" checkbox (I'm using 13 Advanced). Are you saying if I change the storage option, and don't change anything else, I should be fine with existing and future documents?

            • 3. Re: Moving database from local machine to server

              Store a Reference is an option that can be selected from the Open File Dialog used to select and insert a given file into a container field. This is not a storage options specified for the field, but part of the insertion method used to insert the file.

              What you describe should work, but I'd try a small "test database" first.