Access Files Over Internet

[dip_991]

What is the best method for access files over the internet? or allow a computer to access an inventory database from a remote location, but has to be secure.

[Thias.TG]

VPN

[dip_991]

1 minute ago, MathiasVN said:

VPN

is it the built in windows VPN service?

if yes, is there a tutorial on how to set it up on both PCs?

 

Note: Both are running Windows 10

[mariushm]

vpn

for file transfers only encrypted ftp would also work

[Thias.TG]

3 minutes ago, Dipesh429 said:

if yes, is there a tutorial on how to set it up on both PCs?

 

Note: Both are running Windows 10

 

Well, since it sounds like it's not a server i would Recommend using an FTP Server instead...
 

3 minutes ago, mariushm said:

ftp would also work

1

You can easily install an Filezilla server:

https://filezilla-project.org/download.php?type=server
https://www.howtogeek.com/140352/how-to-host-an-ftp-server-on-windows-with-filezilla/

[dip_991]

3 minutes ago, mariushm said:

vpn

for file transfers only encrypted ftp would also work

there wont be any file transfers but sharing the file for read and write permissions (similar to a LAN but over the internet) so the remote users can edit, add or update existing data.

[The Benjamins]

Can you describe what kinda of files you will be accessing, how you want to access/use it, what is the average size of the files, internet speed of both locations?

[dip_991]

54 minutes ago, The Benjamins said:

Can you describe what kinda of files you will be accessing, how you want to access/use it, what is the average size of the files, internet speed of both locations?

Its a program similar to tally erp, since there are 3 warehouse on different locations a shared database would save alot of hassle and time.

basically the software allows you to locate the database(../xx/xx - file path) same as tally, so if it can be access remotely (with read and write permissions) it would make purchases/stocks more easier to look up 

[The Benjamins]

3 minutes ago, Dipesh429 said:

Its a program similar to tally erp, since there are 3 warehouse on different locations a shared database would save alot of hassle and time.

basically the software allows you to locate the database(../xx/xx - file path) same as tally, so if it can be access remotely (with read and write permissions) it would make purchases/stocks more easier to look up 

how big is the database, are these locations connected with a high speed link or standard business class internet.

 

if it is a slow connection (standard internet) I would look into a Database solution that is web based so your users can connect though a web portal verse connecting direct. some database application can get flaky over slower internet like connections.

 

Does your ERP vendor provide a solution?

[dip_991]

15 hours ago, The Benjamins said:

how big is the database, are these locations connected with a high speed link or standard business class internet.

 

if it is a slow connection (standard internet) I would look into a Database solution that is web based so your users can connect though a web portal verse connecting direct. some database application can get flaky over slower internet like connections.

 

Does your ERP vendor provide a solution?

its standard business class internet, unfortunately ERP vendor does not

[The Benjamins]

6 hours ago, Dipesh429 said:

its standard business class internet, unfortunately ERP vendor does not

you have a few options, and with out knowing your software and setup more I can't say which is the best option.

Option 1

If your ERP client is a thin client then it should work fine over a VPN connection between locations. Thin client as in the client never interacts with the DB but sends commands to the central server to execute.

Option 2

If your ERP client is NOT a thin client and your software is well optimized and your DB is small you MAY be able to use it over a VPN. (if things go wrong the DB might get corrupt) (HEAVILY effected by internet speed

Option 3

Set up a remote desktop server for the other location to remote into so they can access the ERP "Locally". This wound be easy to implement and should work fine. it is not a elegant solution but it works. (requires half decent internet)(not the best if many people need access due to the need of a big better Remote desktop server)

 

With out knowing your ERP software and use of it, Option 3 is the best I can recommend. IF you can Option 1 is the best, it will scale nicely.

 

I am no expert so other people may have better answers and I don't know too much about databases based systems.