How to open Sqlite database using WINSCP.

Hi.

I access linux based handheld terminals from a windows pc using winscp, to support remote users.
I often need to copy sqlite database on windows PC to make any changes, and need to repush the same to remote linux Handheld terminals.Can somebody share the method of acessing sqlite database directly from winscp window. Rather than copying it on Windows PC and opening it.

khansam wrote:

Hi.

I access linux based handheld terminals from a windows pc using winscp, to support remote users.
I often need to copy sqlite database on windows PC to make any changes, and need to repush the same to remote linux Handheld terminals.Can somebody share the method of acessing sqlite database directly from winscp window. Rather than copying it on Windows PC and opening it.

You may have a local sqllite editor that you can use, but even if you set up WinSCP to open the editor for you, in teh background it will copy the file to a local temporary directory and then upload it back to the server when it sees the file changed.

In order to be able to edit locally without bringin the file over you'd have to have some kind of server running on the remote side that understands sqllite file format and presents a user interface (like phpMyAdmin does for MySQL via a web page)

This link (<invalid hyperlink removed by admin>) describes 3 different servers (not all in one place) that have the functionality you are describing.