Very often when I publish my Umbraco site to Azure it will cause a 502 page to be returned when looking at the remote site. After reading some forum posts and following suggestions I believe it is the database that is the problem. When I delete it and reinstall from local it's fine, if I try to overwrite a running site it very often causes problems, if I stop the webserver it sometimes causes problems. It's pretty inconsistent.
Also the only reliable way to transfer files is Webmatrix as FTP won't show the files and Git doesn't do anything.
Does anybody know a full proof way of updating the database (.sdf file) without too much hassle?
Thanks