H hdtvirl Active Member Licensed User Longtime User Sep 2, 2011 #1 Hi everybody, I am looking to find out some advise on which is the best tool to create sqlite Databases and tables on a PC. I wish to create on the PC populate from a SQL2008 Server using a small VB.net routine and then copying the entire sqlite Database onto a SDcard and putting it on to an Acer Iconia A500 Tablet. When the table has been updated by the tablet user I wish to copy the database back onto the PC and transfer the updated record back into the SQL 2008 server. I will at some stage create a webservice to do this process over the air but for the moment I just want to copy the databases between PC - Tablet - PC. I look forward to your helpful suggestions. Regards BOB
Hi everybody, I am looking to find out some advise on which is the best tool to create sqlite Databases and tables on a PC. I wish to create on the PC populate from a SQL2008 Server using a small VB.net routine and then copying the entire sqlite Database onto a SDcard and putting it on to an Acer Iconia A500 Tablet. When the table has been updated by the tablet user I wish to copy the database back onto the PC and transfer the updated record back into the SQL 2008 server. I will at some stage create a webservice to do this process over the air but for the moment I just want to copy the databases between PC - Tablet - PC. I look forward to your helpful suggestions. Regards BOB
canalrun Well-Known Member Licensed User Longtime User Sep 2, 2011 #2 For working with SQLite databases on a PC I use a free tool that works as an add-on to the Firefox browser: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ I have used this quite a few times. Works like a champ. Barry. Upvote 0
For working with SQLite databases on a PC I use a free tool that works as an add-on to the Firefox browser: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ I have used this quite a few times. Works like a champ. Barry.
Djembefola Active Member Licensed User Longtime User Sep 2, 2011 #3 I'm using Navicat for SQLite. It's not free but powerful and reliable. Upvote 0
tremara1 Active Member Licensed User Longtime User Sep 2, 2011 #4 Another alternative I use this to create my sqlite dbs ....sqlite3 personal. Download SQLite Expert Personal Upvote 0
Another alternative I use this to create my sqlite dbs ....sqlite3 personal. Download SQLite Expert Personal
vb1992 Well-Known Member Licensed User Longtime User Nov 5, 2011 #5 Just downloaded this: Was pretty simple: SQLite Database Browser | Free Development software downloads at SourceForge.net Upvote 0
Just downloaded this: Was pretty simple: SQLite Database Browser | Free Development software downloads at SourceForge.net