Any tool to convert SQLite database to sql server? [closed]

Question

DBConvert is one such tool I know. Any open source or any other product?

Answer 1

You could try the SQLite Manager for Firefox add-on

It's got the ability to export your SQLite db to a .sql file which you could then run in SQL Server. Might not be perfect, but it is free.

Answer 2

For me it was n't that much complicated to convert in notepad++ by replacing:

number -> int

text -> [varchar] (1000)

GUID -> UNIQUEIDENTIFIER

Bool -> bit

autoincrement -> IDENTITY (1,1)

long -> int

double -> float

create table Delivery ( Id INT not null, primary key (Id) }

->

create table Delivery ( Id INT not null primary key clustered, -- primary key (Id) }

and at the end I checked constraints, pk, column type and size in a SQL diagram.