I want to do the - should be simple - task of copying a database from local to live... 

I have all the data and table structure I want in my local database.

I have a currently running database live database that has all the backup stuff assigned to it etc so I don't just want to create a brand new database (not that I can find how to do this either)... 

I just want to remove all tables from that database and then copy all my data and tables from the local into the live azure sql database.

**How do I do this???**