Creating SQLite Databases on a PC

[hdtvirl]

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]

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]

I'm using Navicat for SQLite. It's not free but powerful and reliable.

 

[tremara1]

Another alternative

I use this to create my sqlite dbs ....sqlite3 personal.
Download SQLite Expert Personal

 

[vb1992]

Just downloaded this:
Was pretty simple:

SQLite Database Browser | Free Development software downloads at SourceForge.net