Question Can software in different cities uses the same database to store data?

[msaaaddev]

Hello Friends,
I want to ask that can software in different cities uses the same database to store data.
I am new to c#. I want to know if I develop software in c# and then install it in different cities(branches) of same company can I use the same database for all running software in different cities(branches).
Thanks.

 

[Skydiver]

As long as you have a way to access that common database from both locations this will work. It does not really matter what programming language that you use. Put careful thought in how you will make the database accessible, though. Gone are the days when it was relatively safe to have a database exposed directly to the Internet. Nowadays, responsible database use would expose a web service that uses robust authentication and authorization and only exposed the minimally necessary APIs to update a database. If your company already has some connectivity between the two cities and has a private network, that would be a safer situation. You would just have to be aware of the bandwidth supported by that connection and plan accordingly. If the bandwidth is two slow for your needs, then you will need a database in each city and some way to do the synchronization between the two. Most modern database engines will have some kind of replication or synchronization solution either built-in or provided by a third party.

 

[msaaaddev]

As long as you have a way to access that common database from both locations this will work. It does not really matter what programming language that you use. Put careful thought in how you will make the database accessible, though. Gone are the days when it was relatively safe to have a database exposed directly to the Internet. Nowadays, responsible database use would expose a web service that uses robust authentication and authorization and only exposed the minimally necessary APIs to update a database. If your company already has some connectivity between the two cities and has a private network, that would be a safer situation. You would just have to be aware of the bandwidth supported by that connection and plan accordingly. If the bandwidth is two slow for your needs, then you will need a database in each city and some way to do the synchronization between the two. Most modern database engines will have some kind of replication or synchronization solution either built-in or provided by a third party.

Thanks For your help.
Can we use any online database for software or run software online which makes it easier for us.