So I'm in the process of switching to a new hosting service and I had a friend hook me up porting my data via an SSIS package to my new server.  Now I'm when most would call a retard when it comes to SQL.  I can design databases but I dread doing SQL.  That is why Joe ruled for doing this for me.

I did a few quick laps around the internet and can up with nothing.  SQL Server's tools are designed to back up the database locally only.  So if you don't have physical access, you're out of luck.

After asking around internally, one of my awesome coworkers pointed out there is a tool to do just this called the Microsoft SQL Server Database Publishing Wizard 1.1.  Another tool looks to be on CodePlex called SQL Host.