4

I have developed an application in vb.net 4.5 with VS2015 and I am using InstallShield Limited Edition to create the MSI installation file.

Some of the final users don't have internet, so I need to include the SQLLocalDB.msi and install it silently.

I can't find a single sample for this, it should be a common scenario right?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
GeorgeArrays
  • 125
  • 11
  • More info but not a duplicate here: https://stackoverflow.com/questions/9655362/localdb-deployment-on-client-pc – Steve Jul 13 '19 at 20:32
  • There's an answer at [Can ClickOnce or InstallShield setup SQL Server or SQL Server Express?](https://stackoverflow.com/questions/34553647/can-clickonce-or-installshield-setup-sql-server-or-sql-server-express) that might help. – Ken White Jul 13 '19 at 20:49
  • I can't use ClickOnce since some of my clients don't have internet access – GeorgeArrays Jul 13 '19 at 21:42
  • 2
    Firstly, you shouldn't be looking to install LocalDB, which is intended for developers. You should be looking to install SQL Server Express. Secondly, the fact that your users don't have internet access is irrelevant to whether you use ClickOnce. You can provide a ClickOnce installer on a disk or flash drive, just like any other installer. Internet is an advantage for automatic updates but not essential. Also, Windows Installer and ClickOnce can use the exact same prerequisite packages to bootstrap third-party installers, so installing SQL Server Express is basically the same in both cases. – jmcilhinney Jul 14 '19 at 02:53
  • 1
    LocalDB also is intended to be distributed on light applications, SQL Express consumes much higher RAM than LocalDB.You are right about ClickOnce, but I would like to have all included in a single MSI. – GeorgeArrays Jul 14 '19 at 21:08

1 Answers1

4

Well, since I couldn't get an answer, I ended up including the SQLLocalDB.msi to the VS project and mark the file as "Required", so when my application starts, check if database is installed and if not, starts the msi installation in silent mode.

GeorgeArrays
  • 125
  • 11