Can't import northwind sql file onto DB Browser for SQLite

Question

I seem to get this error message.

[Error importing data: Error in statement #1: near "S":syntax error. Aborting execution and rolling back.] (https://i.sstatic.net/IzRvb.png)

I looked into the SQL file. These are the first few lines:

Select * from Shippers /*

MS SQL Server Setup script for SQL Practice Problems Database: Northwind_SPP

*/

Set nocount on

GO /****** Object: Table [dbo].[Categories] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Categories]( ...

Can't seem to find the "Syntax error" especially in line 1.

Answer 1

The Northwind SQL examples are for sql-server, which may have a slightly different syntax than sqlite. You won't be able to use them with an RDBMS they were not intended for.

Answer 2

Using https://github.com/jpwhite3/northwind-SQLite3 to download.

Started DBeaver.

Created connection to the download and :-