I need to run a patch to upgrade my scripts in my custom Fmp 8 software. In this patch, I need to revise scripts in multiple linked databases. I can not find a way to AUTOMATE the EXPORT of my updated scripts into the existing scripts of the existing databases.

While this would be very neat, I do not think it is possible. The separation model would help you in an area like this but its probably to late for that.

How does anyone upgrade their software to their users without having to import data all the time? (Especially when they are small fixes)

As Zero tolerance said, you can use the seperation model to some extent. This way when small changes to scripts and layouts are created, we can just push that interface file out. However, you have to keep in mind that if fields are added / changed etc then you will have to push out those files as well in conjunction to any updates to the interface file that occurs from it.

What about if the users add or modify layouts? This method will not work for this case will it?

Well D. Madans,

You will have to determine where the security level will be and also who will have what kind of role. For the most part IMO, users should not have to add or modify layouts, scripts, table structures, etc. There can be those that act as superusers that can modify user accounts, update critical value lists, etc. but for the most part, I personally leave all the major modification to the developer role. Sometimes I will give some limited access to the superuser to modify some of the reports layouts but that is about it.