MSDE Question - Microsoft SQL Server

Steve Bishop

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!

Jul 20 '05 #1

Subscribe Post Reply

1737

Simon Hayes

"Steve Bishop" <st****@viper.com> wrote in message
news:40*********************@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

Jul 20 '05 #2

Similar topics

Replication with MSDE

by: Craig HB | last post by:

I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server...

Microsoft SQL Server

MSDE Question

by: Steve Bishop | last post by:

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...

Microsoft SQL Server

MSDE 2000 Release A won't talk

by: noname | last post by:

MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install...

Microsoft SQL Server

msde

by: JIMMIE WHITAKER | last post by:

Can MSDE be used on computer in different cities? Say the server in Dallas and the client computer in Houston. Or is the full SQL Server required?

Microsoft SQL Server

Converting database to MSDE

by: Rosy Moss | last post by:

I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...

Microsoft Access / VBA

Jet or MSDE

by: NB | last post by:

Hi I have been developing on MS Access / Jet / VBA platform for about 2 years. The current project I am working on for a small business is built on Access 2002. It has about 53 tables in 2...

Microsoft Access / VBA

Considerations for packaging MSDE app

by: Paul Aspinall | last post by:

Hi I have a C# Winform app which runs using SQL Server. I want to package up the app, so that it deploys with MSDE. Can anyone offer any pointers or references to help?? Thanks

C# / C Sharp

MSDE Authentication

by: Anthony P. Mancini | last post by:

Does anyone know how to make the MSDE do SQL authentication ? It appears to authenticate using Windows at all times. Thanks, Anthony

ASP.NET

Problem: Performance difference between MSDE and SQL Express 2005

by: HC | last post by:

Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...

Microsoft SQL Server

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice