How can I make use of a .db file in SQL server 2008?

Question

I have access to a .db file that I would like to query somehow to pull data from it for my other database. So far I have been unable to do this through an ODBC or SQL server directly. I would think that this is possible but I can't seem to find any ideas how.

Solution 1

.db files are standalone files, so cannot be Opened through SSMS. Use SQLITE DB BROWSER to work on those files. Thanks :)

Solution 2

.db files are standalone files, which means they don't need server to work, which also means you can't open it with SQL Server 2008.
More more info check THIS LINK

Solution 3

If this is a one time load, the easiest option would be using the SQL Server Import and Export wizard from SSMS. You'll need a Sqlite ODBC driver. The one here should work.

Another option is to create a linked server to SQLite database from SQL Server. See this article for instructions.

Here are a couple of StackOverflow posts on loading data from Sqlite to SQL Server which might be helpful.

• Bulk load tables in SQLite db files into SQL Server

• Import data from SQLite to SQL Server with SqlBulkCopy class

Comments

[harshita]

So if SQL Server can't open a .db file, then how can we open it, I also have a .db file that I would like to open. Please help me, how can i view its structure?