deploying database files - .NET Framework

lord.zoltar

Hi,
I'm wondering how I deploy a database with an application.
I know that I can require SQLServer Express to be installed, using the
ClickOnce deployment system, but I also need to know how I can include
the database files and have them installed into SQLServer Express as a
part of the installation process.
I'm running VBExpress, SQLServer Express (but I also have access to SQL
Server 2000, full version).

thanks.

Aug 21 '06 #1

Subscribe Reply

1350

Dave Sexton

Hi,

I'm not too familiar with the Sql Server Express edition, but aren't the databases .MDF files?

If your using an installation project, add the .MDF file to the Application folder. I assume that Sql Server 2005 Express has a
merge module or redistributable file that you can include in your installation.

If your using ClickOnce (as it sounds), go to the publish tab of your project's properties window and click the "Prerequisites. .."
button. Check the "Create a setup program to install prerequisite components" checkbox and check Sql Server 2005 Express Edition in
the list. OK that dialog and click the "Applicatio n Files..." button. If your .MDF is not included already, include it (you might
have to check "Show all files").

HTH

--
Dave Sexton

<lo*********@gm ail.comwrote in message news:11******** *************@i 3g2000cwc.googl egroups.com...

Hi,
I'm wondering how I deploy a database with an application.
I know that I can require SQLServer Express to be installed, using the
ClickOnce deployment system, but I also need to know how I can include
the database files and have them installed into SQLServer Express as a
part of the installation process.
I'm running VBExpress, SQLServer Express (but I also have access to SQL
Server 2000, full version).

thanks.

Aug 22 '06 #2

Similar topics

1780

Deploying a winforms app via CD - MDAC and framework etc

by: Terry H | last post by:

Hi I am deploying a winforms app via the windows installer and a VS.Net 2003 setup and deploymnet project. At the moment, I am adding launch conditions for the .Net Framework 1.1 and MDAC 2.7 or higher, and am prompting the user to run the relevant setup files if they're missing. I'm including these setup files on the CD. I can't work out from the Data Access downloads page, which MDAC file I need

.NET Framework

1288

Deploying a SQL Server App

by: Skully | last post by:

If I have created my Web Application on my PC using command and connection objects (dragging them onto the forms from the Server Explorer window) how do I make it work when I deploy the application (and presumably the dB) to the Host server? The connection objects all refer to my PC not the server the app will eventually end up on? I guess my question is general. Where do I find out how to deploy a SQL Server/ASP.NET app to a...

ASP.NET

1417

Deploying an Application with Crystal Reports Support

by: John R. Dougherty | last post by:

I have a VB.NET 2003 application which is using the built-in Crystal Reports control for viewing an .RPT file. The .RPT files reside on the server, and the data pulled by these reports is in a SQL Server database. On any client PC, I can create an ODBC connection to the SQL Server database - and the DSN name for this connection is what I reference in code when setting up a user-selected report for viewing. I have created a deployment...

Visual Basic .NET

1159

Deploying .NET

by: Adam Knight | last post by:

Hi all, I have started using VS as opposed to Web Matrix, thus benefiting from the ability to precompile my app. With VS I know all my app code is compiled in the bin directory, so all functionality is available from the resulting library. I am just wondering how i go about deploying my app without the associated source files (.vb, .cs).

ASP.NET

2611

Deploying VS 2003 Application w/Access Database

by: pooba53 | last post by:

I have a VB .NET 2003 application that communicates with an Access db. I am deploying the application using the Wizard that creates an install package and it IS properly grabbing the Access db and putting it in the Program Files directory along with the application executable, no problem. The problem is this... The OleDbConnection knows of the database in an absolute location (i.e. C:\Documents and Settings\ApplicationDB\data.mdb

Visual Basic .NET

1816

Deploying a WinForms app on Vista

by: David Jackson | last post by:

Hello, I'm looking for some best practice advice on deploying a 32-bit WinForms app on 32-bit Vista as regards file locations. The app will be written in Visual Studio.NET 2005 and will be compiled into a single executable with some values stored in the app.config file - the user needs to be able to update these values. The app also will use a Jet database.

C# / C Sharp

6390

Deploying Access 2007 Runtime / developer extensions / basic MSI installer questions

by: ARC | last post by:

I'm currently looking at the access developer extensions for creating an MSI installer package for a 2007 runtime app. Couple of observations and questions. 1) Doesn't look like we have the ability to set a packaged file to always overwrite, or never overwrite, unless I'm missing something. This could be a sticking point, as I would always want the program to overwrite on re-installing, but NEVER the back end database. I have a few more...

Microsoft Access / VBA

4143

Deploying Microsoft ReportViewer DLL files by copying

by: jimmarq | last post by:

I need reporting functionality in my app, but for several reasons, I don't want to have to package any DLL files in a setup. I want to deploy my application straight to a shared network drive with the DLL files it needs. Is there any problem with deploying the 3 Microsoft ReportViewer DLL files to a networked drive and having users access them there? Microsoft.ReportViewer.Common.dll Microsoft.ReportViewer.WinForms.dll...

.NET Framework

2764

Deploying a database

by: kitemad69 | last post by:

How i can i deploy and attach a database from a C# project. I created the database in sql manager now i want to deploy it using a C# project is this possible

C# / C Sharp

8394

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8605

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6164

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4152

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4304

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1955

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP