I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more complex queries all over the application, and I need to perform a replicate per project , but the the replicates would be heavy for a one database containing multiple projects.
In this application I'm using multiple arcpy geoprocessing scripts, so if I will opt for multiple databases the SDE database would be a parameter.
But multiple databases would be easier to backup and to archive.
I tried to make a picture about the context of the question:
Is there any risk in adopting multiple geodatabases in one application?
Any advice or experiences are welcome.