search

ErikEJ / SqlCeToolbox

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
Other
847 stars 174 forks source link

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

Closed Greg90277 closed 1 week ago

Greg90277 commented 1 week ago

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

ErikEJ commented 1 week ago

@Greg90277 Did you look under the View menu?

Greg90277 commented 1 week ago

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 solutionshttps://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)

@Greg90277https://github.com/Greg90277 Did you look under the View menu?

— Reply to this email directly, view it on GitHubhttps://github.com/ErikEJ/SqlCeToolbox/issues/1004#issuecomment-2461420085, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AE5R7VWGEHYUSV3OPLR55ODZ7MBL3AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGQZDAMBYGU. You are receiving this because you were mentioned.Message ID: @.**@.>>

ErikEJ commented 1 week ago

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

ErikEJ commented 1 week ago

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

Greg90277 commented 1 week ago

Yup:

@.***

[daazzle_IB8-R]

Greg Dobbs, Founder & President daazzle, LLC

daazzle solutionshttps://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 GitHubhttps://github.com/ErikEJ/SqlCeToolbox/issues/1004#issuecomment-2461532680, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AE5R7VSAILSXZNN6AXIIXFTZ7MLC3AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGUZTENRYGA. You are receiving this because you were mentioned.Message ID: @.**@.>>

Greg90277 commented 1 week ago

Using 4.8.803:

@.***

[daazzle_IB8-R]

Greg Dobbs, Founder & President daazzle, LLC

daazzle solutionshttps://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 GitHubhttps://github.com/ErikEJ/SqlCeToolbox/issues/1004#issuecomment-2461544191, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AE5R7VUSK5UXIUWSTOBEGQ3Z7ML4BAVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU2DIMJZGE. You are receiving this because you were mentioned.Message ID: @.**@.>>

ErikEJ commented 1 week ago

Please use .804 - publishing of .803 was broken

Greg90277 commented 1 week ago

Where would I find that? I downloaded from Visual Studio Marketplace…

[daazzle_IB8-R]

Greg Dobbs, Founder & President daazzle, LLC

daazzle solutionshttps://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 GitHubhttps://github.com/ErikEJ/SqlCeToolbox/issues/1004#issuecomment-2461554191, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AE5R7VVTDZTZ4O7YC4VWN3TZ7MMQ7AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU2TIMJZGE. You are receiving this because you were mentioned.Message ID: @.**@.>>

ErikEJ commented 1 week ago

@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

Greg90277 commented 1 week ago

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 solutionshttps://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)

@Greg90277https://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 GitHubhttps://github.com/ErikEJ/SqlCeToolbox/issues/1004#issuecomment-2461576949, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AE5R7VVTJRLPSJRAYPP2OQ3Z7MN73AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU3TMOJUHE. You are receiving this because you were mentioned.Message ID: @.**@.>>

Greg90277 commented 1 week ago

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 solutionshttps://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)

@Greg90277https://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 GitHubhttps://github.com/ErikEJ/SqlCeToolbox/issues/1004#issuecomment-2461576949, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AE5R7VVTJRLPSJRAYPP2OQ3Z7MN73AVCNFSM6AAAAABRKMV3USVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGU3TMOJUHE. You are receiving this because you were mentioned.Message ID: @.**@.>>

ErikEJ commented 1 week ago

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

ErikEJ commented 1 week ago

I have updated the readme