How to fetch data stored by SQL?

Question

I am trying to establish a connection between SQL server and SQLite C interface. SQL stores data in .MDF and .LOG file-extension.

Is there any possiblility to fetch schema, data from above file extension?

Take a look at [**SQLite Schema Information Metadata**](http://stackoverflow.com/questions/6460671/sqlite-schema-information-metadata) — David C. Rankin, Jul 12 '16 at 07:09

score 2 · Answer 1 · answered Jul 12 '16 at 07:18

2

"We all know that SQLite is In memory database" is not true. At the opposite is based on files. anyway to get a nice example You can see at:

http://www.tutorialspoint.com/sqlite/sqlite_c_cpp.htm

answered Jul 12 '16 at 07:18

ingconti

10,876
3
61
48

score 1 · Accepted Answer · answered Jul 12 '16 at 07:27

1

No, you cannot import SQL Server data files into SQLite, as those are totally unrelated products and store data in different formats.

You can, however, export your database as SQL and import that into SQLite. Note, however, that both databases use slightly different SQL dialects, so you may have to correct generated SQL files by hand before thay can be imported into SQLite.

answered Jul 12 '16 at 07:27

el.pescado - нет войне

18,889
4
46
89

Do you mean exporting SQL database schema or data? – kvk30 Jul 12 '16 at 07:34
You have to export both: http://stackoverflow.com/questions/1515969/exporting-data-in-sql-server-as-insert-into – el.pescado - нет войне Jul 12 '16 at 07:49

How to fetch data stored by SQL?

2 Answers2