If you are receiving error like:

Failed to add rule 'xxx.xxx.xxx.xxx to xxx.xxx.xxx.xxx' to firewall. Please add it manually.

Then first go to SQL databases, like on the picture:

After go to servers, and click on the server which you want to configure:

Then click configure:

And here you can add your rule:


How to check locks in Azure SQL?


SELECT * FROM sys.dm_db_wait_stats
ORDER BY wait_time_ms desc

Table where we can see logs from Windows Azure.

Use "CREATE DATABASE destination_database_name AS COPY OF [source_server_name.] source_database_name" to make a copy of database on the Azure SQL.

There is also possibility to check progress of DB copy, but at this moment I don't have that code.