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
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
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
Comments