When will SQL Search support SSMS 19?

ronmichael

When will SQL Search support SSMS 19? I found notes that SQL Search 3.6 supported the preview but it doesn't seem to support the release.

Victoria W

Hi @ronmichael

We don't currently have a date for SQL Search supporting SSMS 19.

https://productsupport.red-gate.com/hc/en-us/articles/9104561754013-SSMS-19-does-not-yet-fully-support-the-Toolbelt-add-on-tools

mjbnpws

HI Redgate,

"We don't currently have a date for SQL Search supporting SSMS 19."

Is this really the best answer you can give?  Is there anywhere on your roadmap that you will support SQL Source Control or SQL Search in SSMS 19?  Redgate tools are not cheap and it is a bit of an inconvenience when they stop working because we upgrade Microsoft core components, such as SSMS.

Regards,

Michael

Victoria W

Hi @mjbnpws

We're working on it and it should be available very soon. I'll let you know as soon as we have a release date.

mjbnpws

HI @Victoria W,

Thanks so much for the response, can't wait for the fix.

Regards,

Mick

tapuleo

Anxiously awaiting SSMS 19 support.

Victoria W

Hi @ronmichael, @mjbnpws, @tapuleo

I'm happy to tell you that SQL Search for SSMS 19 is here:
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe 

tapuleo

That’s great news. Thank you. 

mjbnpws

Thanks @Victoria W  that's great,

Search is now working, any timelines on Source Control and SQL Test?

Regards,

Michael

Victoria W

Hi @mjbnpws

We're still working on this but it should be very soon. Again, as soon as they're available I'll let you know.

Victoria W

Hi @mjbnpws

Thank you for your patience on this issue, we now have a release which supports @mjbnpws

https://download.red-gate.com/installers/SQLToolbelt/2023-03-01/SQLToolbelt.exe

https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe 

Patch note 7.5.4.16994 - February 28th, 2023

Improvements

• VT-282 - Providing support for SSMS 2019 GA
• Updated SQL Compare Engine to 15.0.5.23167

mjbnpws

Thanks @Victoria W all seems to be working now, thanks so much.

Regards,

Michael

DavidB147

Whenever I try and use the SQL Search tool with SSMS 19.0.2 it just crashes SSMS.

Not sure if this has been reported yet.

Victoria W

Hi @DavidB147

Thanks for reporting this. We're working on a fix at the moment but in the meantime the workaround is to use SSMS 19.0.1. I'll let you know as soon as we have a fix.

Sorry for the inconvenience.

LarsSandahl

Whenever i try to use SQL Search tool (installed from the link https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe ) it just craches my SSMS the version that I am using is.

SQL Server Management Studio 19.0.20209.0+f9a9d8f6

SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973

Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e

Microsoft Analysis Services Client Tools 16.0.19993.0

Microsoft Data Access Components (MDAC) 10.0.22621.1265

Microsoft MSXML 3.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.22621

Victoria W

Hi @LarsSandahl

Please see my recent post above ^^

LarsSandahl

Whenever i try to use SQL Search tool (installed from the link https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe ) it just craches my SSMS the version that I am using is.

SQL Server Management Studio 19.0.20209.0+f9a9d8f6

SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973

Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e

Microsoft Analysis Services Client Tools 16.0.19993.0

Microsoft Data Access Components (MDAC) 10.0.22621.1265

Microsoft MSXML 3.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.22621

Victoria W

Hi all

I'm pleased to report that we've fixed this bug in the latest version of SQL Search:

https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe