asked on

Deploy vb.net with SQL Server database to many different single machines

Is there a way to write a script that will add a SQl database to another machine automatically without a hard wired connection string. I have a vb.net program that has a SQL Server database that will be installed via download to 10 different independent computers in 10 different homes with 10 different users. They will have different machines with different windows versions etc.... They will also have different info on each database with no connection to each other.

I would like to keep the database independent so that if i update the UI they can download it and run the install(setup) and find the database.

I know this can be done with a local DB but then i would not be able to do UI updates.
Can someone steer me with this.

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

williamj67

ASKER

Scott, Would it make sense for me to set up a machine with SQL Express(say) 2008 make the database with that so when i compile, it would run on any later versions of SQL? The INNO Installer i use has all the windows versions from XP to 10 and checks which version is on the machine. Is there a better way to go than SQL for this small application?

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial