What are the challenges you face when working across database platforms? Take the survey
Options

No support for xmla, dax, mdx, dmx scripts?

JoelgJoelg Posts: 11 Bronze 1
One of the best feats of Sql Prompt is the tab state: I close SSMS at night and back at work the day after with all tabs, saved or not. 
I discovered today that my SSAS troubleshooting scripts did not open. These tabs were excluded.
Also in History search none of them are indexed.

I guess this is by design, but shouldn't it be easy to just allow any extension used by SSMS to be saved the same way. Maybe there's a hidden setting to allow this?

Best regards
Joel 

Answers

  • Options
    Hi @Joelg

    Thank you for reaching out on the Redgate forums regarding your alternate script formatting inquiry.

    Unfortunately, as you have mentioned, SQL Prompt does not support these formats and as an extension would not recognise tabs using these formats to be saved. 

    I believe MDX support was previously investigated, but not part of the product roadmap at that point in time.
    Having said that, I would certainly recommend posting this on our UserVoice feature request site in case there has been a change in direction in the time since it was last brought up.

    Our SQL Prompt request site can be accessed here: 
    https://redgate.uservoice.com/forums/94413-sql-prompt

    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.