Hi Amir, I dont think that is what happened. Locally it creates an MDF file, and that same file has been uploaded to Azure too but the site is blank. I looked into the code too and umbraco.installer.js has a line where it seems to check the db:

$scope.dbs = [
        {
            name: 'Microsoft SQL Server Compact (SQL CE)',
            id: 0
        },
        {
            name: 'Microsoft SQL Server',
            id: 1
        },
        {
            name: 'Microsoft SQL Azure',
            id: 3
        },
        {
            name: 'Custom connection string',
            id: -1
        }

So this is all on Azure (i am no expert sorry). Very strange we cannot figure out where this SQL Azure is sitting. Thank you!!

So the SQL connection string in the web.config is actually empty? You should be getting an error on the front-end of the site at least if that's the case.

We figured it out. It created an SDF :D I didnt have access to see but just checked now. Guess it works with SQLCE on Azure! Thank you Amir!

is working on a reply...