Friday, March 23, 2012

MSDE Question

Hope MSDE questions ok here. I would like to distribute a MSDE
application on CD ROM. I don't have any of the packaging solutions i.e.
Visual Studio, Office Developer or VB Pro. I'm using MS Web Matrix to
build an ASP.Net front for MSDE.

How distributable is MSDE without the additional distribution products?

Would I need to load up MSDE from the CD Rom then execute some long
scripts to build my tables and stored procs I use in the application?
Should I just get one of the professional development products listed
above and use the distribution tools?

Help / Input appreciated.
Steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Steve Bishop" <steveb@.viper.com> wrote in message
news:407d352f$0$197$75868355@.news.frii.net...
> Hope MSDE questions ok here. I would like to distribute a MSDE
> application on CD ROM. I don't have any of the packaging solutions i.e.
> Visual Studio, Office Developer or VB Pro. I'm using MS Web Matrix to
> build an ASP.Net front for MSDE.
> How distributable is MSDE without the additional distribution products?
> Would I need to load up MSDE from the CD Rom then execute some long
> scripts to build my tables and stored procs I use in the application?
> Should I just get one of the professional development products listed
> above and use the distribution tools?
> Help / Input appreciated.
> Steve
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You can install MSDE using just a command line - check the readme for the
latest MSDE download, which lists all the parameters to setup.exe.

After you install it, you can run your object creation scripts with
osql.exe, or possibly include a database backup and simply restore it, which
is quick and easy, although of course you have no flexibility to create
objects conditionally.

I'm not familiar with the packaging tools you mention - you might get better
information in a .NET or ASP forum.

Simon

No comments:

Post a Comment