1 Reply Latest reply on Dec 5, 2013 6:27 AM by philmodjunk

    How do you update the design and not lose your data?

    Cadburys

      Title

      How do you update the design and not lose your data?

      Post

           Hi

           I am about to embark on the development of a solution (using Filemaker Pro 12) that will be used in different offices and a few users in each office.

           At present the idea is that a PC would be set up as the host in each office each user requiring access to the DB would have a FM12 licence.

           First of all is this a good idea?

           Now the big question..obviously there will be design changes/additions etc... how does one update the design but not lose the existing data?  

           Any advice would be appreciated.

            

           Thanks.

           Cadburys

        • 1. Re: How do you update the design and not lose your data?
          philmodjunk

               You use Import Records to import all the records from all the tables in the old version into the new. You also update the next serial value settings of any auto-entered serial numbers to prevent records added after the import from generating values that duplicate a record from the imported data.

               This can be scripted so that you can send out the new file, the users open it and click a button--producing a dialog box where they select the old copy of the database and the script takes it from there.

               You can also design your files using the Convert to Seperation Model model and thus greatly reduce the circumstances where such an import of the data is needed.