[dba-VB] One Click publish

Hmm....

I am looking at building an application in .Net.  This application will be used by my users but will 
also possibly be sold to companies.  Thus the application install has to somehow do an initial setup 
of a database.  As changes are made, any database changes have to be pushed along with the 
application changes.

The application will "start small and expand" so I am expecting the application and it's database to 
grow over the years.

Perhaps Click-Once is not the method for this kind of situation?

John W. Colby
www.ColbyConsulting.com


Shamil Salakhetdinov wrote:
> Hi John and Gustav,
> 
> I must say, I have spent some time trying to figure out how to setup some
> data(base) locally with Click-Once setup - and I just gave up because that
> wasn't a work paid by a customer urging that setup and having a money to pay
> for it: I mean this is a very advanced subject IMO - "Click-Once setup with
> local data(base). For myself I decided to use Click-Once setup only talking
> to (external) web-services or to local preinstalled MS SQL database, which
> connection string is known for Click-Once app (although I didn't test how it
> works) - Click-Once apps are usually having very limited access rights to
> the host system they run on - IOW they run in "sandbox" - one can try to
> bypass these limitations by using Code Access Security (CAS) manipulation on
> runtime but again that's is an advanced subject...
> 
> ...IOW Click-Once setup of apps with unlimited permissions is as dangerous
> as ActiveXes setup - not recommended(?)...
> 
> "There is no free cheese in this world"
> 
> Thank you.
> 
> --
> Shamil
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Monday, August 24, 2009 10:37 PM
> To: dba-vb at databaseadvisors.com
> Subject: Re: [dba-VB] One Click publish
> 
> Hi John
> 
> Yes, at least for SQL Server. Some explanation here:
> 
> http://www.databasejournal.com/features/mssql/article.php/3714536/SQL-Server
> -2005-Express-Edition---Part-12---ClickOnce-Deployment-and-Updates.htm 
> 
> /gustav
> 
>>>> jwcolby at colbyconsulting.com 24-08-2009 20:15 >>>
> Does the One Click thing publish the database as well for a database app?
> If not, is there such a 
> thing for publishing the database?
>