SSMS 20

Answers

• JonHillyer Posts: 5 New member

  March 20, 2024 2:14PM

  Many thanks David. Is there any estimate timescales on SSMS 20 support?

  0 · Share on Twitter
• David Atkinson Redgate › Posts: 1,457 Rose Gold 2

  March 20, 2024 3:55PM

  This is being assessed right now, so I can't provide an ETA just yet. 

  David Atkinson
  Product Manager
  Redgate Software

  2 · Share on Twitter
• JonHillyer Posts: 5 New member

  March 20, 2024 5:25PM

  Thanks David

  0 · Share on Twitter
• MikeHodgson Posts: 2 New member

  March 22, 2024 6:52AM

  I'm keen to know the answer to the ETA (no pressure).  Just installed SSMS 20 today (and reinstalled SQL Toolbelt), but no red-gate menus or tools appearing in SSMS 20, which is fair enough.  I'm getting so used to the red-gate tools (especially SQL Prompt) that I'll just continue to use SSMS 19.3 until they work with SSMS 20.

  0 · Share on Twitter
• David Atkinson Redgate › Posts: 1,457 Rose Gold 2

  March 29, 2024 2:35PM

  This work should be complete now. Run Check for Updates from the tool or update via the Toolbelt installer.

  David Atkinson
  Product Manager
  Redgate Software

  1 · Share on Twitter
• JonHillyer Posts: 5 New member

  March 29, 2024 3:01PM

  Hi David, I can see SQL Prompt is now woring in SSMS 20 (which is great).
  Any ideas on timescales for SQL Source Control?
  
  

  0 · Share on Twitter
• David Atkinson Redgate › Posts: 1,457 Rose Gold 2

  March 29, 2024 3:03PM edited March 29, 2024 3:06PM

  SQL Source Control 7.7.9 should have support for SSMS 20. See release notes.  (note - in SQL Source Control you'll have to have enabled "Configure Frequent Updates" to see this update appear via Check for Updates)

  David Atkinson
  Product Manager
  Redgate Software

  1 · Share on Twitter
• JonHillyer Posts: 5 New member

  March 29, 2024 3:19PM

  Many thanks David, I was missing the latest update. Everything looks to now be working perfectly.

  0 · Share on Twitter
• scosovic Posts: 1 New member

  April 1, 2024 2:37AM edited April 1, 2024 1:04PM

  Hi David,
  It looks like we cannot install SQL Source Control 7.7 if we only have SSMS 20 installed. No SSMS 19 installed. The Toolbelt installer mentions that SQL Source Control 7.7 can only be installed for SSMS 19 and older.
  
  How do we install the latest version of SQL Source Control (7.7.9) for SSMS 20 only? Thanks.
  
  P.S. I cannot use Flyway yet as you suggest. Everybody in the team is using SQL Source Control. I have to stick with it for the time being.

  1 · Share on Twitter
• BrunoPimenta Posts: 2 Bronze 1

  April 1, 2024 5:53PM

  Hi David,
  
  I am also facing the same issue as @scosovic and I also cannot install Flyway at the moment.
  
  Do we require to keep the SSMS 19 in order to make Source Control work with SSMS v20 ?

  0 · Share on Twitter
• David Atkinson Redgate › Posts: 1,457 Rose Gold 2

  April 1, 2024 7:50PM

  Apologies - this is an oversight in the Toolbelt installer. Please use this direct download link for the SQL Source Control installer instead.

  David Atkinson
  Product Manager
  Redgate Software

  2 · Share on Twitter
• MikeHodgson Posts: 2 New member

  April 1, 2024 11:05PM

  Thanks David.  I can confirm the SSC (7.7.9) installer from the direct link you provided works for me in SSMS 20.
  
  (Now, if only Microsoft will fix the saving of the Trust Server Certificate property for server registrations within a Central Management Server, then I'll be happy with SSMS v20.  )

  1 · Share on Twitter