SA Developer .NET

Hi guys

I'm creating an install package and I need the package to run a SQL script to create a database on install.  Unfortunately, my knowledge on this subject is so limited, I don't even know what to google...  Please help.

Thanks,
A*

---

Someone once told me love makes the world go around and, well, I just had to laugh in their face because EVERYBODY knows what REALLY makes the world go around is a mutant gerbil on a treadmill.

Go have a look at the SQL2005 command line utility:

 

http://www.databasejournal.com/features/mssql/article.php/3654176

You are an angel!  Thank you so much!

---

Someone once told me love makes the world go around and, well, I just had to laugh in their face because EVERYBODY knows what REALLY makes the world go around is a mutant gerbil on a treadmill.

Cool. No problem.

Ah yes.

 

Well, you could blatantly assume the user has OSQL or SQLCMD living somewhere on their PC, but that may not always be the case.

 

HOW are you deploying?? You could write a custom action in C# to use SMO (SQL Management Objects) to execute the script; this will provide all sorts of SMO goodness that you could exploit. If you want some idea behind SMO and how it fits together, take a look Bill Graziano and my SQL scripting tool (http://www.codeplex.com/scriptio) - source code is there, obviously.

---

And so the kief looked and lo, it was kief.

riccardospagni:

Well, you could blatantly assume the user has OSQL or SQLCMD living somewhere on their PC, but that may not always be the case.

The client will always have MSSQL when they install our package.  It's a software requirement.  And the companies that use our software will have it installed for them by a technician.  Thankfully, it's not as complicated as all that .

---

Someone once told me love makes the world go around and, well, I just had to laugh in their face because EVERYBODY knows what REALLY makes the world go around is a mutant gerbil on a treadmill.

What are you using to create the install package?

Wix has some nice sql extensions that does most of this type of work for you. On the other hand you can create custom actions both with wix and most other installers that you can do pretty much what you like !

 

 

Niel

Yeah - I was going to point out that NSIS (Nullsoft Scriptable Installer System) has a stack of addons for this kind of thing, as well as checking the installed framework version and silently updating it if necessary etc. etc.

---

And so the kief looked and lo, it was kief.