Stretch Database from Developer Edition 2016 to SQL Azure

Hi Mates,

Today I would like to explore the functionality about Stretch Database

There are many articles that would help you in understanding what Stretch Database is all about.

As you can see I have 10 rows inside my test table & I would like to store initial 5 rows on to my cloud instance.

Right Click on the table & select Enable for stretch

Once we select Enable we will have option to select the tables we would like to continue for

Here we have an option to select entire table or query only few rows. In my case I selected 5 rows out of 10

Then sign in to your Subscription in my case it is free trial & select your Azure instance by providing the user name & the password

After this we need to enter credentials for Database Master key(DMK) which will get secured by the below password

As this is a test Machine I allowed the entire IP Address range

Unfortunately It got failed with below message. Sad part is we can't test stretch functionality with free trial accounts.

Hope Microsoft would allow this functionality to work even with free trial accounts.

Mar 11 2018 17:12:13 [Informational] TaskUpdates: Message:Task : 'Configure Stretch on the Database test' -- Status : 'Failed' -- Details : 'Task failed due to following error: Microsoft.SqlServer.Management.Smo.FailedOperationException: Alter failed for Database 'test'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: 'Free Trial subscriptions can provision Basic, Standard S0 through S3 databases, up to 100 eDTU Basic or Standard elastic pools and DW100 through DW400 data warehouses'
ALTER DATABASE statement failed.
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

Happy Reading