You can work and manage the system or branches remotely through the main system or use the special web version so that the system and the web version can work together at the same time on a cloud or remote-controlled database through the following methods or options:
1- Local connectivity and remote device sharing: One of your devices can be transformed into a local or global server so that it can be accessed and dealt with with the database remotely, relying on (static IP) and this service is provided by your telecommunications authority or Internet service provider. So the service is installed on your routers, allowing for remote communications with the database.
Disadvantages:
-
You must have a static IP.
-
The device must be secure and working in order for other devices to work with it.
-
Some countries do not support the Static IP service.
Features:
-
high speed
-
In the event of an Internet outage, the main store will not be affected and will continue to operate within the local network
2- Cloud connectivity: Here you must search for a provider or host of a database server of the SQL Server type (third party) so that you can subscribe with the provider and then upload the database to your cloud account and give you connection information with the database and you can deal with it from the system or the web version.
Disadvantages:
-
Hosting prices vary, and some may be slow if you choose a weak plan.
-
If the Internet is cut off in the store, you will not be able to work.
-
Features:
-
You do not need to have a server that is always running.
Here are some examples of companies that provide cloud hosting services for databases, as they differ from each other in terms of speed, database size, and the amount of connections allowed. Their prices vary according to the layer and teams of services they provide. You can also search for more companies and not necessarily be restricted to a specific company. Examples:
-
https://www.smarterasp.net - Highly rated by customer experiences
-
https://microsoft.com
-
https://google.com
-
http://godaddy.com
-
https://www.myasp.net
-
https://somee.com
-
You can search for more ....