Installing a database in SQL Express during VB app setup

[Aussie Rules]

Hi,
I have a vb.net application that uses a SQL Express database.

The end user already has SQL Express setup on there server, but they have no
skills at using it.

Is there a way I can have my VB.net Setup program install the database onto
this server? Executing a massive SQL Script I guess would work, or perhaps
just restoring a backup of the database would work as well.

Also happy to do a dedicated SQL setup program if this is the best option.

 

[Mr. Arnold]

Hi,
I have a vb.net application that uses a SQL Express database.

The end user already has SQL Express setup on there server, but they have
no skills at using it.

Is there a way I can have my VB.net Setup program install the database
onto this server? Executing a massive SQL Script I guess would work, or
perhaps just restoring a backup of the database would work as well.

Also happy to do a dedicated SQL setup program if this is the best option.

Yeah, you can do it.

I talked with C# developer that tired to do the same thing, but he ran into
the problem of user authentication on the user's machine with the database.
It seems that the database would only accept Windows authentication, not
Mixed mode or SQL authentication, which was a problem, since he was giving
the user-id and psw in a connection string.

I don't know if he ever got it to work, but I pointed him to a MS SQL Server
NG where he might get his answers as to what the problem may be.

I also think you need to search Google on how to deploy a MS SQL Express
database solution with in the setup of a .Net solution deployment. The
articles are out there on Google.

 

[Earl]

The easiest way is to use an install program called InstallAware. It's a bit
pricey ($200 - 500 depending on version), but you can add in the kitchen
sink, including SQLExpress.