I have been asked to help a client take control of a database designed by a volunteer who built a this solution rather 'organically' over a several years. It was last built on FM10 but is a multiifile solution. One file has many tables but it still references about ten other files, each with only one table.
The client wants to host the file on a shared server and in order to control costs of hosting wants to limit the number of databases being hosted.
Is there any guide to how best to get this multi-file database into one-file (or many fewer files) database? An application that would assist? Good advice?
I would appreciate any guidance you all can offer.