SQL server Import and Export Wizard missing/disabled SSMS 18.0
SQL Server import and export is disabled in SSMS 18.0, is this temporary and available in later versions of 18 or we wouldn't have import export going forward?
This is indeed an unintended removal. It only affected SQLEXPRESS.
Thanks for the reporting it.
We’ll fix it in a future release of SSMS 18.×.
I have the same problem, Import and Export Data are blocked, when i put the cursor on them, it shows the message: "This feature is not currently available in this version or the database is not available"
I'm using SSMS v18.1
I have the same problem, where Import data and Export data is greyed out (see attached image).
Is there any reason for this? I had this feature in a earlier version, but since I have upgraded to this version I have lost it.
Bruce L. Scheffler commented
It seems that another function "copy database" is also missing in the new version. However the disabled/missing function only happen if you are trying to use the new version with sql express. If you have an actual sql server setup it is there and is enabled.
Are both Import Data and Export Data disabled? or just one of them?