Reputation: 3697
Post has been Updated 03-05-2017
People were talking about this problem here:
Currently in 2017 the issue is still affecting Visual Studio and SQL Server Management Studio. Below is Import Export Dialog Status for my two setups:
Details:
As soon as I click "Next' button here:
window disappears without any message.
I am really sick of this problem, because I got my environment highly customised and microsoft loves to make pointless things like: "hey, lets default text output in ssms to font size 7, why not?" or "lets make dark theme but only for selected apps" or even "what would you guys say if we remove python from installer of 2017, it would be so much fun! Users would be forced to install instances from multiple release channels".
As some of you already mentioned and I am grateful for it I can (as workaround) use Command window:
Tools.ImportandExportSettings [/export:filename | /import:filename | /reset]
But is it even possible in SQL Server Management Studio? If it is, I didn't find it, if it isn't, then how any of us is supposed to import settings?
I will ONLY mark as an answer post that actually prevents window from disappearing and allows me to import options successfully, however I will upvote effective workarounds, especially for SQL Server Management Studio
Upvotes: 18
Views: 7061
Reputation: 21769
The links you provide actually contain a walkaround. Check the answer
https://stackoverflow.com/a/31300971/635654
To summarize:
Ctrl+Alt+A
to open VS command windowManually type the command to import settings from filename
as:
Tools.ImportandExportSettings /import:"<filename>"
Upvotes: 7