SQL Azure to SQL Server Express database migration

Initial screen shows you that Full Convert will automatically detect your database if you don"t know which one do you have. Of course, if you do know your database, do select it from the list on the left.

We will choose SQL Azure from the list of available source database engines, as SQL Azure is just a special version of SQL Server.

To connect to SQL Azure, you will need to use your server URL in the Server field, and the rest is standard (username, password, database name). Just make sure to connect using SQL Server authentication instead of Windows authentication.

List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.

We will choose SQL Server from the list of available source database engines. Depending on your SQL Server setup, you will need to connect using Windows or SQL Server authentication.

For SQL Express, we need to specify the server\instance name, like this: servername\SQLEXPRESS

We have Windows authentication here, so all we need to do is select our desired database from the drop-down list.

We will select all source tables for conversion by default. In case you only need some tables, simply deselect the ones you don"t need - or deselect all, then select just the tables you do need.

Here you can see how many tables will be converted. To start conversion right away, click on the Convert! button. To show contents of target database without converting, click on the Explore button. Use that to inspect target database prior to conversion, or to save the conversion project for later before even converting the first time.

Click the Convert! button to get started.