[dba-VB] One Click publish

Hi John and Shamil

It is not that complicated ... once you find out how. That took me quite some time because I had to both distribute the app (that's easy) and install a font (not so easy) at each workstation. Most of the bumps are due to security precautions.

I have previously posted about how to do this and the tool needed:

http://databaseadvisors.com/pipermail/dba-vb/2008-October/002037.html 

In your case you would prepare an SQL Server quiet install package and arrange that as a prerequisite for your app.

/gustav

>>> shamil at smsconsulting.spb.ru 24-08-2009 21:06 >>>
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?

-- 
John W. Colby
www.ColbyConsulting.com