Does anyone have any strategies for release management from a development to test to production environments?

Supporting an envinpronment where there will be multiple non technical users and want to be able to make changes and test in one version of the db and then promote changes to production version.  I have looked for suggestions and can't find any.  Help!