Why there is no option to import data to Azure database using ssms?

Viewed 3358



I have created a SQL database on Azure portal. I logged in to SSMS using required credentials, but some options to import/export data to database are missing, so I can't open SSMS Import/export wizard.

This issue doesn't occur when I using Amazon RDS databases.

Am I missing any database configuration?

Screenshot of a Azure SQL database on SSMS

4 Answers

You can see it by right clicking on the "Databases" not individual database.

Image

If you are using SSMS v18 or above, you should right-click on the Databases and you can see that option there.

For the best user experience with Azure SQL Database please use the latest SSMS version. Download it from here.

You can also try to add the Import/Export Wizard manually as explained on this DBA StackExchange thread.

Related