How Do I: Deploy Local Data?

Visual Basic programmers will learn how to deploy local SQL-Server Express database files using ClickOnce Technology.

By: Beth Massi

Posted: May 31 2007, 07:18 AM by jaytayl | with 2 comment(s)

Comments

How did Beth get the SQL DB (.mdf) file in the Solutions Explorer structure?

I'm running a Forms project in VS2010 and if I try to Add | Existing Item... browse to my mdf file I get an Access Denied result.

How do I get the MDF file in the structure so it will be added to a Publish?

# June 14, 2011 3:07 PM

Okay, I found the solution...

(1) close VS2010

(2) close SQL Express Manager R2

(3) Open VS as Admin

(4) Open project in VS2010

(5) From Data folder Add | Existing Item... browse to SQL's .MDF file and select, press Ok

(6) file will now display in ..\Data\.. folder

Phill

# June 14, 2011 4:31 PM