Change the resource based on production and development?

Can I use a development copy of the database for development and easily swap the resources over to the production database for staging and release?