Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
suspend6
Starting Member
3 Posts |
 Posted - 2010-08-11 : 20:57:38
|
| Hi, first post.We have a vertical market application that runs a native, flat-file database. We want to convert to MSSQL. We have almost 300 sites around the country using our application. Some of those site are also using other complimentary applications that use SQL. Many have no SQL components at all. Is it possible to prepare a script of some sort which can set up all the SQL stuff with no user interaction ?Thanks, Phil |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-12 : 03:18:15
|
| It depends. You can automate everything, the depending part is how much time you're willing to spend on it and how good control you have over the remote environments. We have a fully automated install (with a bunch of parameters of course) of SQL 2008 Enterprise here with security policies and maintenance jobs and the works...but it took a serious amount of time to develop! The only user interaction you'd need is for someone to set the parameters in the beginning.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
suspend6
Starting Member
3 Posts |
Posted - 2010-08-12 : 03:39:19
|
| Many thanks for your prompt reply. May I ask what language you wrote your installer in, and what would you recommend as a good reference to all the parameters?Cheers, Phil |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-12 : 03:51:56
|
| It's batch scripting...here's the resource we used for SQL 2008 R2: http://technet.microsoft.com/en-us/library/ms144259.aspxI'd think (although I'm far from sure!) that it would work in more or less the same way for Express, just with a limited set of parameters. I guess Google is your friend as always...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
suspend6
Starting Member
3 Posts |
Posted - 2010-08-12 : 20:49:51
|
| Very helpful, many thanksPhil |
|
|
|
|
|
|
Deployment of SQLServer 2008 Express