2

I want to create a Windows Application in VS 2012 with database in MS SQL server 2008. How can I create a setup which creates this database?

I don't want to install SQL Server on the target PC. I just want to install my application and create the database. How can I do this?

Izzy
  • 1,764
  • 1
  • 17
  • 31
Rahul Kumar
  • 21
  • 1
  • 7
  • possible duplicate of [Quick deployment of Visual Studio 2010 app with SQL database](http://stackoverflow.com/questions/9734816/quick-deployment-of-visual-studio-2010-app-with-sql-database) – CodeCaster Jul 02 '13 at 11:32
  • have you tried ClickOnce solution ? – Mingebag Jul 02 '13 at 11:32
  • hi Mingebag.. No i am not try this. How i can use it? – Rahul Kumar Jul 02 '13 at 11:36
  • But if you don't want to install SQL Server on target PC, how are you then going to use the database you want to create? or do you want to create the database on a remote server during your application's setup? – StackTrace Jul 02 '13 at 12:04
  • @SQL.NETWarrior even if he did package a version of sql with his application, his question is about how to put a database onto the server instance. – Izzy Jul 02 '13 at 12:07

1 Answers1

0

I'd use WindowsInstallerXML (WiX) to create the installation package; with WiX there is native support to handle database creation and hopefully this should be suitable to help you with what you need.

However, WiX can be incredibly difficult to just pick up and learn (especially if you need help with English) so this might not be the best option for you.

Izzy
  • 1,764
  • 1
  • 17
  • 31