I’m pleased to announce the release of version 4.0.0 of SQL 4 CDS. This release introduces SQL 4 CDS – SSMS Edition, bringing many of the SQL 4 CDS features directly into SQL Server Management Studio! If you’re using the TDS endpoint this plugin expands your options directly in SSMS without having to switch to XrmToolBox.
Although the TDS endpoint gives you flexibility to run more complex
SELECT queries than SQL 4 CDS can convert to FetchXML, it does not support DML queries such as
With the new SQL 4 CDS – SSMS Edition you can now write & run those queries in exactly the same way. The TDS endpoint will still run
SELECT queries, but SQL 4 CDS will handle the
Turn on the SQL 4 CDS toolbar in SSMS by right-clicking on the visible toolbars and selecting the SQL 4 CDS option.
When you have a SQL query window connected to a Dataverse instance the FetchXML button converts your selected query to FetchXML, or open an XML document and select a Dataverse instance in Object Explorer and click the SQL button to convert it back to SQL.
The installer is available to download from the GitHub releases page. When you run the installer you may receive a SmartScreen page:
Click the “More info” link, then “Run anyway”. Windows displays this error because as a new app it hasn’t been installed enough times to gain the reputation to bypass this.
As my first foray into SSMS plugins, please do let me know if you encounter any problems!