Click here to Skip to main content
15,897,371 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In my project, I cannot expect my user to install MySQL server and client on their machine. So without MySQL, is it possible to do direct query on the .sql file such as read and write. Now it's for single user only.

Note:
Initially, I used SQLite to do all these kind of work. But we have decided, later we may need to import the .sql file into MySQL server to read and write with multiple-user. That's why I need to use .sql file to store, retrieve and query directly.

Thanks in advance.
Posted
Comments
Sascha Lefèvre 8-Apr-15 12:44pm    
Well - of course you can read and write something from/to that file but if that should make some sense, you would obviously have to re-implement MySQL at least partially - what would be the use of MySQL otherwise?

I would suggest to use SQLite in that case and implement an export-function to be able to import it into MySQL.
kvchennai 8-Apr-15 12:54pm    
Yeah you are right, when write function done his job then I can use export function to make the SQLite database as a MySQL database.

If you don't mind, do you have any export solution from SQLite to MySQL programmatically c#.
Sascha Lefèvre 8-Apr-15 13:01pm    
No, sorry, I don't have anything ready for that. But maybe you find something useful here:
http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900