SQL Azure Backups
azure-sql-database, database-backups
Solution
I spent some time with BCP and got it working acceptably. It's a bit annoying to have to do the backup/restore table-by-table but I'll script it and that will do until Microsoft bring in a proper SQL Azure backup feature which is supposedly going to be the first half of 2010.
Backup:
bcp mydb.dbo.customers out customers.dat -n -U user@azureserver -P pass -S tcp:azureserver.database.windows.net
Restore:
bcp mydb.dbo.customers in customers.dat -n -U user@azureserver -P pass -S tcp:azureserver.database.windows.net
Problem
Has anyone come up with a good way to do backups of SQL Azure databases? The two approaches seem to be SSIS or BCP. SSIS looks like it requires a local install of MS SQL 2008 which I don't have. BCP looks a bit more promising but I haven't managed to find any examples of using it with SQL Azure as of yet.