index > ClickOnce and Setup & Deployment Projects > attach Sql Server DataBase with Setup

attach Sql Server DataBase with Setup

Hi All

I have a VB.NET 2008 WinForm app that use Sql Server 2005DataBase

i create Setup App to that WinForm app

how can Attach DataBase during setup

Moved byYiChun ChenMSFTMonday, June 08, 2009 8:29 AMDeployment issue (From:Visual Studio Setup and Installation)
Edited byOra-dbaabode Monday, June 08, 2009 9:19 PM

Ora-dbaabode Friday, June 05, 2009 12:04 AM

Hi Ora-dbaabode,

What feature does it needed for your application? Sql Server 2005 Express Edition won't have all feature that enterprise have. And the prerequisites will install the basic feature. If your application need more feature, you'd better create a custom prerequisite using BMG.
http://www.codeproject.com/KB/aspnet/Add_Custom_Prerequisite.aspx

The article works for ClickOnce and MSI both. After you add your own downloaded sql server 2005 express, set that as prerequisite to your project.

Sincerely,
Kira Qian

Please mark the replies as answers if they help and unmark if they don't.

Marked As Answer byOra-dbaabode Wednesday, June 10, 2009 12:19 PM

Kira Qian Wednesday, June 10, 2009 2:02 AM

Hi Ora-dbaabode,

I am moving this thread from Base "Visual Studio Setup and Installation" forum to the "ClickOnce and Setup & Deployment Projects" forum, since the issue is related to deployment. There are more deployment experts in the "ClickOnce and Setup & Deployment Projects" forum.

Thanks

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

YiChun Chen Monday, June 08, 2009 8:29 AM

Hi Ora-dbaabode,

What's the meaning of "Attach DataBase"? Do you use file based database(Sql Server Express DB file)?

If so, you can add this file to the MSI package. In the "File System" view window, you can right click "Application Folder" -> "Add" -> "File...". Select the DB file so it can be copied to the target folder when install.

If I misunderstood you, please feel free to tell me.

Sincerely,
Kira Qian

Please mark the replies as answers if they help and unmark if they don't.

Kira Qian Monday, June 08, 2009 8:55 AM

Hiii Kira

I have vb 2008 app using Sql Server 2005 Interprise Edition

I want to create Setup app to install that vb app ,and I want to attach DataBaseusing setup

Note : Setup app install Sql Server 2005Express edition

how install SQL Server InterpriseDatabase Engine Instead express edition

Edited byOra-dbaabode Monday, June 08, 2009 11:05 PM

Ora-dbaabode Monday, June 08, 2009 8:46 PM

Hi Ora-dbaabode,

You client pc which running your application just a consumer of the database. It doesn't need to install database server side component. So install the sql server 2005 express edition is enough. It includes necessary components to connect to remote sql server.

Here is some information of Sql server 2005 Express Edition
http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

Sincerely,
Kira Qian

Please mark the replies as answers if they help and unmark if they don't.

Kira Qian Tuesday, June 09, 2009 2:18 AM

Thank you Kira

I reinstall Sql Server Express Edition Manually with all features it worked successfully

but I need Install Sql Server Express Edition with all features during setup operation

Ora-dbaabode Tuesday, June 09, 2009 8:47 AM

Hi Ora-dbaabode,

You can right click the setup project and choose "Properties", click the "Prerequisites..." button on the popup dialog. Check the Sql Server 2005 Express Edition checkbox. Then it will be installed during installation process.

Sincerely,
Kira Qian

Please mark the replies as answers if they help and unmark if they don't.

Kira Qian Tuesday, June 09, 2009 8:54 AM

I am very sorryKira

I did this steps ,and the Sql Server 2005 Express Edition was installed but not all features and attach database not worked but when reinstall Sql Server Express Edition Manually with all features the attach databaseworkedsuccessfully

Ora-dbaabode Tuesday, June 09, 2009 3:27 PM

Hi Ora-dbaabode,

The article works for ClickOnce and MSI both. After you add your own downloaded sql server 2005 express, set that as prerequisite to your project.

Sincerely,
Kira Qian

Please mark the replies as answers if they help and unmark if they don't.