Does not appear in SSMS 19 or 20 even manually copying into Extensions folder

Question

Does not appear in SSMS 19 or 20 even manually copying into Extensions folder

Closed this issue 5 months ago · 13 comments

The Compact Toolbox does not appear anywhere in SSMS - none of the functionality is available. Nothing appears in the Windows or Tools menus.

Steps to reproduce

Follow your own installation instructions. They do not work.

Further technical details

All files copied and extracted to C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions

SSMS 20

Answer 1 · 2024-11-07T06:22:32.000Z

@Greg90277 Did you look under the View menu?

Answer 2 · 2024-11-07T07:12:10.000Z

Hi Erik. Thanks for the quick response! There are no new menu items under the View menu or anywhere else. [daazzle_IB8-R] Greg Dobbs, Founder & President daazzle, LLC daazzle solutions<https://www.solutions.daazzle.com/> From: Erik Ejlskov Jensen ***@***.***> Sent: Wednesday, November 6, 2024 10:23 PM To: ErikEJ/SqlCeToolbox ***@***.***> Cc: Greg Dobbs ***@***.***>; Mention ***@***.***> Subject: Re: [ErikEJ/SqlCeToolbox] Does not appear in SSMS 19 or 20 even manually copying into Extensions folder (Issue #1004) @Greg90277<https://github.com/Greg90277> Did you look under the View menu? — Reply to this email directly, view it on GitHub<#1004 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AE5R7VWGEHYUSV3OPLR55ODZ7MBL3AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGQZDAMBYGU>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Answer 3 · 2024-11-07T07:45:28.000Z

Did you copy the vsix contents to: C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\SqlCeToolbox

Answer 4 · 2024-11-07T07:52:11.000Z

Make sure to use build .804, I think build .802 might have been broken

Answer 5 · 2024-11-07T07:53:52.000Z

Yup: ***@***.*** [daazzle_IB8-R] Greg Dobbs, Founder & President daazzle, LLC daazzle solutions<https://www.solutions.daazzle.com/> From: Erik Ejlskov Jensen ***@***.***> Sent: Wednesday, November 6, 2024 11:46 PM To: ErikEJ/SqlCeToolbox ***@***.***> Cc: Greg Dobbs ***@***.***>; Mention ***@***.***> Subject: Re: [ErikEJ/SqlCeToolbox] Does not appear in SSMS 19 or 20 even manually copying into Extensions folder (Issue #1004) Did you copy the vsix contents to: C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\SqlCeToolbox — Reply to this email directly, view it on GitHub<#1004 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AE5R7VSAILSXZNN6AXIIXFTZ7MLC3AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGUZTENRYGA>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Answer 6 · 2024-11-07T07:56:58.000Z

Using 4.8.803: ***@***.*** [daazzle_IB8-R] Greg Dobbs, Founder & President daazzle, LLC daazzle solutions<https://www.solutions.daazzle.com/> From: Erik Ejlskov Jensen ***@***.***> Sent: Wednesday, November 6, 2024 11:53 PM To: ErikEJ/SqlCeToolbox ***@***.***> Cc: Greg Dobbs ***@***.***>; Mention ***@***.***> Subject: Re: [ErikEJ/SqlCeToolbox] Does not appear in SSMS 19 or 20 even manually copying into Extensions folder (Issue #1004) Make sure to use build .804, I think build .802 might have been broken — Reply to this email directly, view it on GitHub<#1004 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AE5R7VUSK5UXIUWSTOBEGQ3Z7ML4BAVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU2DIMJZGE>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Answer 7 · 2024-11-07T07:57:46.000Z

Please use .804 - publishing of .803 was broken

Answer 8 · 2024-11-07T08:08:11.000Z

Where would I find that? I downloaded from Visual Studio Marketplace… [daazzle_IB8-R] Greg Dobbs, Founder & President daazzle, LLC daazzle solutions<https://www.solutions.daazzle.com/> From: Erik Ejlskov Jensen ***@***.***> Sent: Wednesday, November 6, 2024 11:58 PM To: ErikEJ/SqlCeToolbox ***@***.***> Cc: Greg Dobbs ***@***.***>; Mention ***@***.***> Subject: Re: [ErikEJ/SqlCeToolbox] Does not appear in SSMS 19 or 20 even manually copying into Extensions folder (Issue #1004) Please use .804 - publishing of .803 was broken — Reply to this email directly, view it on GitHub<#1004 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AE5R7VVTDZTZ4O7YC4VWN3TZ7MMQ7AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU2TIMJZGE>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Answer 9 · 2024-11-07T08:10:14.000Z

@Greg90277 Ah - the extension from marketplace does not work with SSMS 20! Please consult the readme! https://github.com/ErikEJ/SqlCeToolbox?tab=readme-ov-file#sql-server-management-studio-ssms-20-and-17-extension

Answer 10 · 2024-11-07T08:23:04.000Z

So I copied the above and extracted it as below – still not working. Nothing in SSMS. ***@***.*** [daazzle_IB8-R] Greg Dobbs, Founder & President daazzle, LLC daazzle solutions<https://www.solutions.daazzle.com/> From: Erik Ejlskov Jensen ***@***.***> Sent: Thursday, November 7, 2024 12:11 AM To: ErikEJ/SqlCeToolbox ***@***.***> Cc: Greg Dobbs ***@***.***>; Mention ***@***.***> Subject: Re: [ErikEJ/SqlCeToolbox] Does not appear in SSMS 19 or 20 even manually copying into Extensions folder (Issue #1004) @Greg90277<https://github.com/Greg90277> Ah - the extension from marketplace does not work with SSMS 20! Please consult the readme! https://github.com/ErikEJ/SqlCeToolbox?tab=readme-ov-file#sql-server-management-studio-ssms-20-and-17-extension — Reply to this email directly, view it on GitHub<#1004 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AE5R7VVTJRLPSJRAYPP2OQ3Z7MN73AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU3TMOJUHE>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Answer 11 · 2024-11-07T08:46:35.000Z

Hi Erik. So this might be helpful: I solved the first issue; When the VSIX is downloaded from the web, the file gets a “Blocked” flag set by Windows assuming it’s malicious. So before extracting the VSIX files you must right-click the VSIX and then uncheck the Blocked flag indicator. Then you can unzip and copy to the C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\SqlCeToolbox folder. Doing the above gets the SqlCeToolbox to appear in SSMS. Now I’m getting the following error trying to script a SQL Server database to SQLite: ***@***.*** LOL – any thoughts? [daazzle_IB8-R] Greg Dobbs, Founder & President daazzle, LLC daazzle solutions<https://www.solutions.daazzle.com/> From: Erik Ejlskov Jensen ***@***.***> Sent: Thursday, November 7, 2024 12:11 AM To: ErikEJ/SqlCeToolbox ***@***.***> Cc: Greg Dobbs ***@***.***>; Mention ***@***.***> Subject: Re: [ErikEJ/SqlCeToolbox] Does not appear in SSMS 19 or 20 even manually copying into Extensions folder (Issue #1004) @Greg90277<https://github.com/Greg90277> Ah - the extension from marketplace does not work with SSMS 20! Please consult the readme! https://github.com/ErikEJ/SqlCeToolbox?tab=readme-ov-file#sql-server-management-studio-ssms-20-and-17-extension — Reply to this email directly, view it on GitHub<#1004 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AE5R7VVTJRLPSJRAYPP2OQ3Z7MN73AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU3TMOJUHE>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Answer 12 · 2024-11-07T08:47:40.000Z

Please post screen shots directly on GitHub, I cannot see them when you reply via email!

Answer 13 · 2024-11-07T08:48:03.000Z

I have updated the readme