Topic "How to open Sqlite database using WINSCP."

Author Message
khansam
[View user's profile]

Joined: 2011-12-17
Posts: 1
Location: Coimbatore
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.
Freitag
[View user's profile]

Joined: 2007-10-25
Posts: 51
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 describes 3 different servers (not all in one place) that have the functionality you are describing.
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License