Writing an application to help administer SQL databases
I currently have a collection of SQL scripts that are used routinely and I
would like to write an application where I can "plug-in" the values and
let the application handle running the code. I'd like to eliminate having
to open a SQL file, find the script, change the code accordingly, select
and run it.
My question is what language would best facilitate this? What are best
practices when doing something like this? I'm working in a Windows
environment, working on SQL 2008 R2 Servers. I have resources to learn on
the fly so the language isnt too big of a deal. Also, purchasing a tool is
out of the question.
Thanks in advance!
No comments:
Post a Comment