Problem to import new data

Question

Hi all,

! At first I am sorry if this question doesnt belong here ... I didnt know where to put it ..

Till now I have used a SQLite and from today I start with SQL (SQLServer). First I did is export data from old database to file db_name.db.sql ... Now I am trying to import data in SQL Management Studio. So I mark my database, click on File -> Open -> File ... and ... after file is read ... I tried to execite it ... but there shows an error.

Code from that file begin with ...

BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "table_name" (
    "id"    INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
...

and that error is "syntax error at line ..... " Do you know how to export data to correct format.

Answer 1

Are you able to export data from SQLite to the excel or text file? If yes, you can import data from the excel or text file to the table in the SQL server database.

Answer 2

There are many syntax and functional differences between database engines. You are not going to be able to simply run your scripts from sqlite on SQL Server.

SQL Server does not support "IF NOT EXISTS" on CREATE TABLE. It also does not support "AUTOINCREMENT".

I suggest you look at something like this to help you with your conversion:
https://dbconvert.com/sqlite/mssql/

Answer 3

Unfortunately, MS SQL Server doesn't support 'CREATE TABLE IF NOT EXISTS...'
You can run find and replace for the 'IF NOT EXISTS' with empty string in your *.sql script file.

Answer 4

I know it doesnt support a lot of things like ... if not exists or boolean etc. ... but I want to know if ther is something like converter or other way of how to get data from sqlite database to sql server database ...

Answer 5

Hi @Shirase ,

...and that error is "syntax error at line ..... "

Do you use the syntax in English Environment?

And do you want to import data from SQLite?

Try this : creating-a-sql-server-linked-server-to-sqlite-to-import-data

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.