I have been looking at database replication which there is quite alot of information but i dont know if it is what i am looking for so dont want to read into it too much at the moment.
A single (parent) database that holds all the objects required and initial necessary data is propagated. I know i can copy this database to create duplicate identical independent databases.
Is there such a thing as then when the parent database is changed e.g. a procedure is tweaked or an extra column added to a table this change is replicated in the child databases copied from it - without affecting the data users have in the meantime put into the database?
In other words i would like a template database that i only need to make the changes in and not have to duplicate the changes in each database clone manually.