Thanks a lot Grant. That was really helpful. A followup question to this is
Once the developers create content on the dev server(functions/ stored procedures)which is currently integerated with the website running on the same machine under admin privileges, I need to migrate this to a production machine where the website will not be running under admin privileges.
What credentials should I provide for such a website such that it is able to execute the stored procedures/view tables etc in the database.
Second question
What is the best strategy to move newly created content over. By content I mean mostly tables, stored procedures, functions and data stored in the tables.
Since we will be updating the database monthly(the users will be entering data as well) I am not sure if we can overwrite the whole database from dev machine to production machine.