开发者

Correct deployment tool to copy files & run SQL Script

What would be the best way to deploy upgrades to a piece of software with the following requirements:

The upgrade:

  • Must be run from a client machine, not a server.
  • Must Show a dialog to select a network location and copy files to a share.
  • Must show a dialog to enter SQL Server connection information and the upgrade must connect to SQL Server to run an upgrade script.
  • Must not change anything on the client machine from which the upgrade is run. (Nothing in Add/Remove programs, registry, etc. I.e. no Windows Installer.)
  • Must not rely on any additional dlls or frameworks. The user must be able to download a single file and run it from Windows XP SP2 without having to install anything else.

Some things I have looked into:

  • Batch files (can’t show a dialog to allow the user to enter connection information)
  • OSQL (can’t show a dialog and can’t copy files)
  • WiX (runs on top of Windows Installer so it puts开发者_开发知识库 things on the client machine from which it is run)
  • Custom C#/VB app (requires .NET framework)
  • Winzip/WinRAR (can't show a dialog, can’t run SQL Scripts)


If you don't want to rely on any dlls and frameworks, you should make a native app, this can be, for example, custom winrar sfx (you can run additional scripts after extraction, this can be a batch that executes sqlcmd).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜