0

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?

Improve this question
1

2 Answers 2

Reset to default
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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

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.

Improve this answer

2 Comments

Do you mean exporting SQL database schema or data?
You have to export both: stackoverflow.com/questions/1515969/…

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.