How to apply a patch to SQL Server from a installer

[alberteinstein]

Hi

Iam running Sql Server 2000.Usually any sql code patches (that are written by me) are applied manually - that is the user opens the sql file and executes it himself in query analyzer to apply the patch at their end.

I wish to automate this process in such a way that I give the user ONE installer file so that all patches are applied automatically with little user intereference required( Username,password to database could be entered at the begining of the installer)

Can you tell me what is the best way to achieve this?
Should the code be written in VB and QA be called from there?

Or can it be achieved using installers like Nullsoft?
Has anyone done this? Please Help.

Thank You.

 

[philhege]

You can probably write a VB program and wrap it in an installer (or deployment project). Include the SQL statements in the project

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Not NULL-terminated yet.

 

[alberteinstein]

Thanks for your reply Phil.

Although i mentioned VB iam not so converse...its been a long time since i worked in it.

SO could you elaborate on the commands that should be used?
Further it would be great if the same 'kit' could be re-used where in I would have to change only the sql files in the installer the next time...

 

[philhege]

SQL 2K or 2K5?

 

[alberteinstein]

SQL 2K

 

[philhege]

Look into using OSQL scripts to run your T-SQL, or loading the scripts and pushing them to the data connection.