• 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.