Could it be a good idea to share the cloud database and tables with multiple companies to reduce the cost of acquiring cloud databases. The only challenge is supposing the client demand to have a copy of their database what to do then?
You have to calculate both the cost of the database and the cost of managing the data of multiple organizations securely in a shared database. That's not trivial.Could it be a good idea to share the cloud database and tables with multiple companies to reduce the cost of acquiring cloud databases. The only challenge is supposing the client demand to have a copy of their database what to do then?
I use WinHost. I can vouch for their service and response to problems. The few times I've ever called on them, I had almost immediate responses and always resolution to problems.You slipped a topic in here that needs to have the obligatory warning: Access doesn't like clouds.
Here am talking about MS SQL Server provided by win Host which has a total space of 30 GB, now I was thinking of sharing this database in 5 GB for medium enterprises, but for security reasons I have backed off instead I will be offering them the one with 5 GB and bigger companies with 30 GB.
Ms Access will be used as front end, the backend will be the one offered by win host,I have tested their products they are excellent especially for developing countries you cannot go wrong.
Did you know that the tables from their cloud database can be downloaded back to MS Access and back normally either stand alone or local area network backend.
The clients can even backup the actual tables in MS Access database normally.
There is no reason, therefore, to consider using a single MS SQL Server database for multiple clients; neither cost, nor performance or nor security would benefit.Winhost's Basic ASP.NET hosting plan includes a single MS SQL database. Winhost's Max, Ultimate and Power ASP.NET hosting plans offer unlimited MS SQL databases.
That's really interesting, and glad you shared here.I use WinHost. I can vouch for their service and response to problems. The few times I've ever called on them, I had almost immediate responses and always resolution to problems.
Depending on which of their plans you purchase, you can have as many MS SQL Server databases as you need.
There is no reason, therefore, to consider using a single MS SQL Server database for multiple clients; neither cost, nor performance or nor security would benefit.
That leaves the question raised about overall performance. Appropriate design in the Access interface is the primary factor there. And that's entirely in the developer's hands.
You can configure your connections as required for your application, including encryption.That's really interesting, and glad you shared here.
To connect to WinHost, does it come with encrypted traffic, or do you need a VPN or something like cloudflare ?
Regarding overall performance in the developers hand I agree. Like doing most of the processing on the SQL server using stored procedures and pass through queries. Any other techniques you recommend?
What version of Access do you use to connect to SQL Server ? Office 365 or non cloud office ?
Many thanks