SQL Server to SQL lite db

Question

Hi,

How can transfer records from sql server to sqlite db. I am ssis package to migrate tables. i have installed provider for sqlite. I am able to configure source that is sql server and destination i have selected .net provider\dotconnect for sql lite. After selecting i get a window connection manager. how can i connect configure my destination here

Answer 1

Hi @Praveen Channal ,

Is the reply helpful?

BR,
Mia

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

Answer 2

Hi @Praveen Channal ,

Please reference: Data Migration with SSIS and ODBC Driver for SQLite

And reply from this case: fastest-way-to-migrate-from-sql-server-to-sqlite-for-large-datasets may be helpful:

Convert-SQL-Server-DB-to-SQLite-DB

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Is that a one-time job? Then use the export feature of SQLite Toolbox: https://erikej.github.io/SqlCeToolbox/