I have developed a website for small business owners. So, Is it possible to run a website on the client's machine without installing the MsSql Server? Is there any other tool that performs all operations that a published website requires.

Currently, I am installing MsSql on Clent's machine. But by this method, my Database design can be easily copied.

I would like to quickly install my web application on the Client's machine. and also hide the database if possible. So, Suggest all possible ways by which installation becomes quick.

1 Answers

0
pool pro On

Welcome to StackOverflow,

First, I should say that unless you own the computer or server you are installing on it will be very difficult to hide database design, Data can be encrypted but the design will be accessible by the administrator of the computer. If you own the computer or server you can install the MVC site in a Kiosk type situation where only you have access to the system.

SQL Server Compact might be a good fit for what you would like to do, you can encrypt it as a file. you can also place restrictions on permissions to the access. there is a lot you can do with it and research is required.

https://blogs.msdn.microsoft.com/stevelasker/2008/05/14/security-and-encryption-for-sql-server-compact/

Now you could build the MVC application to use Jason. You can encrypt the content of the JSON file using AES encryption. You will need to define a key that will be used for encryption and decryption.