Thanks for the replies. I will look into SQL 2012 Local because that is exactly the type of thing I need. Will it work with a 2008 R2 data file or would we need to upgrade our development and server databases to 2012?

Next question: without the SSMS how do I configure Express or Local so it "knows about" the user database? I have always done a backup and restore to copy from one server to another.

Do I need to do everything with scripts run by code? Or can I set up a prototype of the remote and then copy the master db file along with the user db file to other remote computers?

Sorry I am mainly a developer having to do everything. If you can point me in the right direction that would be helpful.