Jump to content

move a copy of all my notes into a SQL DB


Recommended Posts

Hi everyone,


I would like to know how to export(if possible) all my notes into a SQL DB, so that I can do all sorts of things with the data.


What i would like to do, instead of manually inputting all the date. a way to code via vs2013 to input the date via a program that i can make. 



Link to comment
  • 4 weeks later...

well i coped my evernote Db and renamed the extension to .db


then i used DB browser for sqlite


and used the following statements


SELECT `_rowid_`,* FROM `notebook_attr`  ORDER BY `_rowid_` ASC;
select '_rowid_',* from 'note_attr' ;
the first one got me a list of all the notebooks
the second one got me a list of all the notes and what notebooks they were in.
I have not yet been able to get a listing of a single note and it contents.
Link to comment


This topic is now archived and is closed to further replies.

  • Create New...