[SSMS] Scripting Schema and Data to SQLite from SQL Server fails

Question

Closed this issue 5 months ago · 8 comments

The following error happens attempting to script database schema and data to SQLite:

Answer 1 · 2024-11-07T09:00:46.000Z

Oh. Why not use the VS extension instead??

Answer 2 · 2024-11-07T09:04:55.000Z

I was hoping that the SSMS version would allow me to script Views as well...

Answer 3 · 2024-11-07T09:13:16.000Z

There is no difference in functionality between the VS and SSMS extensions. Is this really a feature request?

Answer 4 · 2024-11-07T09:14:27.000Z

Oh yeah it would be extremely valuable to be able to script all views also.

Answer 5 · 2024-11-07T09:24:02.000Z

Lack of view support is by design (based on experience): #858

Answer 6 · 2024-11-07T09:26:29.000Z

Fixing bugs in the SSMS extension is quite low on my priorities, you should be able to use the VS extension

Answer 7 · 2024-11-07T19:43:43.000Z

@Greg90277 Fixed in latest daily build

Answer 8 · 2024-11-07T19:43:51.000Z

If you like my free tools, I would be very grateful for a rating/review on Visual Studio Marketplace and/or a one-time or monthly sponsorship