MS SQL – Install only SSMS to do an Azure Backup

If you need to install only the SQL Management Studio these days, you will need to go to maximum SQL 2014 !

In the later versions this is not possible anymore to separately selecting the SSMS

Solution :

Download the version INCLUDING the ADVANCED TOOLS

https://www.microsoft.com/en-us/download/details.aspx?id=42299

image

Use this option

image

Choose only “Management Tools – Basic and Management Tools – Complete” as shown below:

image

image

And you are ready to rock and roll … Smile

image

Tip : When you need to do an SQL Azure Backup to an onside server YOU NEED SSMS a the tool to do so !

image

image

It will save your SQL Backup as *.bacpac file

See here for more info :

https://mikhail.io/2016/10/azure-sql-databases-backups-disaster-recovery-import-export/

Export can also be triggered from Azure Portal and PowerShell scripts or using Command Line Tools :

Data-Tier Application Framework : https://www.microsoft.com/en-us/download/details.aspx?id=46898

SqlPackage.exe is part of the SSDT : https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

More info : https://msdn.microsoft.com/en-us/library/hh531248(v=vs.103).aspx

Enjoy !

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: