How to deploy ASP.Net application with MySql Database?

[David Hastings]

Hello people, I have developed a web application with ASP.Net 2.0 (VB Code Behind) and I am using My SQL as database. I have an issue I need your help with:

I wish to sell the web application from my other website to multiple users. What would you suggest to be the best way to deliver this application? Fact is I can compile the front end script and provide the compiled version but I am not sure how to provide the associated MySQL database to them. I need to make sure that the buyers are not able to alter any code in the application or modify the preset data in the MySQL database. I do not wish to use the Setup Based deployment method as it will require the buyers to have administrative rights on the server, which may not be available on shared hosting.

But at the same time they must be able to get the web application up and running with minimal effort.
I must be honest with you that I have developed only HTML based static websites till now and this would the first time I am launching an ASP.Net application so your suggestions are highly applauded.

Thank you for your help.

- David

[PsychoCoder]

Well for starters there's really no way to prevent someone from modifying the code, even if you were to compile it into a DLL .Net is easily decompiled then they would have access to the code.

As far as the MySql database, you can create a script that when ran creates all the database objects needed for the application (Like Wordpress and others have done). You could package the installer with the application or require that it be downloaded when they purchase the application and then the run the page that contains the code for creating the database and all objects/users needed for the application.

[David Hastings]

Well for starters there's really no way to prevent someone from modifying the code, even if you were to compile it into a DLL .Net is easily decompiled then they would have access to the code.

As far as the MySql database, you can create a script that when ran creates all the database objects needed for the application (Like Wordpress and others have done). You could package the installer with the application or require that it be downloaded when they purchase the application and then the run the page that contains the code for creating the database and all objects/users needed for the application.

Hello Richard,

Thank you for your reply.

Could you please tell me a little more about the SQL part. I am confused about it because earlier when I enquired with my hosting provider they told that normally a person won't have Administrative rights on shared hosting. This will prevent them from runing any setup on the server.

Fact is I do not believe any of my buyers would have a local server or a dedicated web server to have instal rights. So would that mean I am out of option? Please reply.

Thank you.

[PsychoCoder]

I never thought about that. They would need a host that offered MySql as an option (Most do that I've ever used or seen), then have your install script create the needed database and all objects needed (tables, procedures, etc)

[Frinavale]

Interesting issue...how do other people host applications if they cannot run a script to create their databases?

Have you considered using an embedded database like VistaDB?

-Frinny