Creating a Hotfix Package update based on selections

Question

Hi Guys,

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?

Many Thanks

Answer 1

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.

Cheers, Bob

Moving this message to SMO-specific forum soon...

Answer 2

Hello,

Your question seems to be more related with creation of MSI with maybe a better forum

http://social.msdn.microsoft.com/Forums/en-US/msbuild/threads

for example : http://social.msdn.microsoft.com/Forums/en-US/msbuild/thread/13dfd51e-878a-4c04-8738-43cfa27a89e1

You could also have a look at

http://blogs.msdn.com/b/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx

http://blogs.msdn.com/b/psssql/archive/2009/04/09/sql-server-2008-sp1-and-cumulative-updates-explained.aspx

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.