John,

To be brutally honest, I've never done anything like this before. I hadn't expected to be going so far down the road with it, but that's usually the case when offering to do something for your local non-profit. Ouch! In a nutshell, I really have no idea how to answer any of your questions as it's a foreign language for me :-).

Being a newb, I simply used the "Publish to Provider" function on Visual Studio to create a script from my local DB and then used SSMS to run the script against the DB at my host. Probably quite naïve expecting that just to work, but that's about the sum total of my knowledge.

Thanks for your time!

Cheers,

Martin