Link to home
Start Free TrialLog in
Avatar of Member_2_7967119
Member_2_7967119

asked on

Web application Deployment Kit & process

I have an ASP.net web application that connects to the SQL server.

I wish to deploy the application along with the database for a customer. But I do not want them to see the procedures or table objects of the database. I do i restrict them.

I have seem some deployed database application where the procedure name are using some naming convention which seems like some auto program is converting them. I am not sure if my finding is correct.

I use the ASP.net web deployment kits for my ASP.net web application which work find that it compiled the web site. Only thing is that I need to deploy by copying the files.

So, I am looking for some one to share their experience in deploying web application with the database.

Thank you in advance.
Avatar of David Favor
David Favor
Flag of United States of America image

There's no way to cloak the structure of a database from admin users.

Typical way to do this is to deploy your App which then calls an API system where you maintain the database.

This way only the API calls are exposed. Database details are completely hidden.
Avatar of Member_2_7967119
Member_2_7967119

ASKER

Can you elaborate on the API system you are refering to. Thanks.
you have to create a service that interacts with the premises database in which you define the entry points i.e. function name, validation and data and return the data requested.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.