Freitag, 20. Juli 2012 13:19
I a very much a newbie to Visual Studio 2010.....and I would very much like your help.
Currently I support a medical software. The software has been written for Windows.
Periodically the supplier will issue hotfixes which come in the form of application files e.g. .dll's or .exe's etc. These hotfixes are almost always accompanied by sql scripts which need to be executed.
I would like to create an application where I can package the files and scripts into some kind of installer. I would then like to give our engineers the opions to select which hotfixes to install before executing the process based on their selections.
The process should stop the application services, copy and replace the application files in the application folder, execute the sql scripts required, then restart the services.
Please can someone help?
Freitag, 20. Juli 2012 18:22
You can use SMO for executing scripts programmatically. See: http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/44835d6f-6bca-4374-93e2-3a0d81280781/. You can also stop and start SQL Server and Agent services using SMO/WMI, see http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.aspx.
Moving this message to SMO-specific forum soon...
Samstag, 28. Juli 2012 15:19Moderator
Your question seems to be more related with creation of MSI with maybe a better forum
You could also have a look at
It is possible that it could give you ideas to create an application conceived to modify an existant other application.
If you want that a moderator moves your thread towards the MSBuild Forum, post your agreement and the move will be done ASAP ( don't forget that it is a week-end + holidays so this move may be delayed because moderators are not always waiting for an action ). The move by a moderator avoids to recreate the thread, so lost posts... and no thread dying because it is not in the good forum ( even for a moderator, it is not easy to find the best suitable forum for every thread to move ).
Useful information : language used by your hotfixes and which .Net Framework (2.0,3.0,3.5,4.0....)
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
- Als Antwort markiert Iric WenModerator Montag, 30. Juli 2012 08:18