February 26, 2016 at 10:59 am
Which version of Management studio is preferred to migrate a SQL 2014 db to SQL Azure.
The SQL instance is on SQL 2014, SP1.
Microsoft suggests to use the latest SSMS. Should I use SSMS 2016. My concern is that this is still on preview. Should I install the preview on the db server?
Many thanks!
February 29, 2016 at 3:49 am
You want to migrate a database to Azure?
Why not upload it via the azure portal?
SSMS will allow you to connect to the database in the cloud and administer it. 2014 is sufficient for this.
Try this article: https://azure.microsoft.com/en-us/documentation/articles/sql-database-cloud-migrate/
February 29, 2016 at 6:28 am
Thanks.
The following article says to use the latest version of ssms to deploy the db to azure.
February 29, 2016 at 7:01 am
Then 2014 is the latest. 2016 is not officially released yet
February 29, 2016 at 7:27 am
There are a bunch of ways to move a database into Azure and you don't have to use Management Studio for all of them. The method within SSMS is to create a BACPAC which is a DACPAC plus an extract of all your data. You can then use that to recreate your database in Azure. Just make sure you're not using any functionality that's not yet supported in Azure v12. Also, be aware, a DACPAC is not encrypted, regardless of the state of your database, so treat it accordingly.
If you do want to use SSMS, I'd strongly suggest getting the new, independent, SSMS install. It has more functionality specific to Azure and will make your work easier. It is a preview release though. Something to be aware of.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 1, 2016 at 4:33 am
Or if moving to a VM in Azure I have done backup / restore via a storage container too.
March 29, 2016 at 10:54 am
You can script your bacpac/dacpac deployments via sqlpackage.exe and run them via cmd line.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply