CODEWITHSUNDEEP
sql-serversqlite
irisadaf
irisadaf

Reputation: 101

SQL Server 2008 Express to SQLite

Can I convert a SQL Server Express 2008 database to SQLite?

My database is simple and only has 1 table but it has about 1000 rows and it's hard for me to make a new SQLite database and add these 1000 records.

thanks...

Upvotes: 2

Views: 4374

Answers (2)

DavidEG
DavidEG

Reputation: 5957

There are many software that can generate the inserts code. For example:

Sql Workbench (free)

Aqua Data Studio (non free but you can evaluate)

Both can generate inserts from many different databases including SQL Server.

Upvotes: 0

jdavies
jdavies

Reputation: 12894

Try this: Convert SQL Server DB to SQLite DB

It is a free .net converter on CodeProject, the poster stated:

I needed to convert the existing SQL server databases to SQLite databases as part of a DB migration program and did not find any decent free converter to do the job.

So I assume he has spent some time looking for what you seek and did not have any luck either.

The source code is available and well documented (according to the poster).

Upvotes: 4

Related Questions