I think I am suffering from paralysis by analysis in deciding whether to use domain access or multisite.
I am working on a school board's development of a new Drupal configured website. The main school board website has been developed and launched, and now I am working on the school sites. There are around 30 subdomains that will be used for these school sites.
I was initially attracted to domain access because of the ease of administration. There is the ability to share content & users as required. Having said that, there will not be that much shared content; only board level content displayed at all the schools. For the most part, each school will have unique content.
Therefore, I started to lean towards having a multisite setup for each of the schools with each having a separate database. Any updates would be able to be done across all the schools, which would have to be down during school breaks. One major concern in terms of using the multisite setup is how to I capture shared content; from a separate database. From what I understand one must build a module to access a different database. I am reluctant to write this amount, or type, of code with my current level of Drupal experience.
Can anyone who has any experience in making this type of decision share some of their insights and experiences? Is there another avenue I could be pursuing?