Get & Put

I've recently migrated from Macromedia Dreamweaver / MS Access to Visual Studio
2005 / SQL Server 2005.

I develop my site code on a local server and upload it to a production server.

In Dreamweaver I'd always did that with put/get options.

In Visual Studio it's much more difficult. Right now I'm copying the code files
manually from the site's directory to the server.

To copy a database it's even a bigger trouble : I have to bring the db offline,
than copy the mdf file  and bring it online on the server .

Is there a simpler way to do all that?

Thanks.