Duplicating the database is probably most often used. OS level copy or Save As Clone within FMP.
The Data Separation Model is advocated by some.
Convert to Seperation Model
Data Separation Model Best Practices
There is a free FMP Developer forum here
Deployed solution meaning a Runtime? This is one main argument for Data Separation.