I work for a software development company that has over 20 MSSQL2000
developer and support instances/environments in which I frequently
apply incremental updates to. The updates are SQL scripts given to me
by developers that, for example, add columns, drop and create updated
or new stored procedures or views. Sometimes a specific version of our
software may have 15-20 incremental updates to deploy. These updates
need to be applied somewhat immediatly to most of the data instances.
I've been running these manually for quite sometime via SQL Query
Analizer. In case you are wondering, as for applying permissions to
these objects, I've already got a script that sets permissions for
specified users for specified databases that i can run for each
instance in the click of a mouse.
What I am longing for is some sort of utility that may exist out there
for doing exactly what I am doing with these incremental updates, yet
more automated. We name our scripts specifically so that they can be
thrown into a single folder and they are already sorted by date and
type, so that a stored procedure update won't reference a table update
that has not been applied yet, etc.
Anyone have any directions they could point me in? I've tried
searching the newsgroups and net with no luck so far.This is a multi-part message in MIME format.
--=_NextPart_000_02AB_01C3AD1B.1AEF2BB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Check out "master server" in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Matt Norwood" <littletinymonkey@.hotmail.com> wrote in message
news:cc80cca0.0311171148.7e43bcff@.posting.google.com...
Hello everyone,
I work for a software development company that has over 20 MSSQL2000
developer and support instances/environments in which I frequently
apply incremental updates to. The updates are SQL scripts given to me
by developers that, for example, add columns, drop and create updated
or new stored procedures or views. Sometimes a specific version of our
software may have 15-20 incremental updates to deploy. These updates
need to be applied somewhat immediatly to most of the data instances.
I've been running these manually for quite sometime via SQL Query
Analizer. In case you are wondering, as for applying permissions to
these objects, I've already got a script that sets permissions for
specified users for specified databases that i can run for each
instance in the click of a mouse.
What I am longing for is some sort of utility that may exist out there
for doing exactly what I am doing with these incremental updates, yet
more automated. We name our scripts specifically so that they can be
thrown into a single folder and they are already sorted by date and
type, so that a stored procedure update won't reference a table update
that has not been applied yet, etc.
Anyone have any directions they could point me in? I've tried
searching the newsgroups and net with no luck so far.
--=_NextPart_000_02AB_01C3AD1B.1AEF2BB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Check out "master server" in the =BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Matt Norwood"
--=_NextPart_000_02AB_01C3AD1B.1AEF2BB0--|||have a read on www.dbghost.com it may be the help you need.
>--Original Message--
>Check out "master server" in the BOL.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Matt Norwood" <littletinymonkey@.hotmail.com> wrote in
message
>news:cc80cca0.0311171148.7e43bcff@.posting.google.com...
>Hello everyone,
>I work for a software development company that has over
20 MSSQL2000
>developer and support instances/environments in which I
frequently
>apply incremental updates to. The updates are SQL scripts
given to me
>by developers that, for example, add columns, drop and
create updated
>or new stored procedures or views. Sometimes a specific
version of our
>software may have 15-20 incremental updates to deploy.
These updates
>need to be applied somewhat immediatly to most of the
data instances.
>I've been running these manually for quite sometime via
SQL Query
>Analizer. In case you are wondering, as for applying
permissions to
>these objects, I've already got a script that sets
permissions for
>specified users for specified databases that i can run
for each
>instance in the click of a mouse.
>What I am longing for is some sort of utility that may
exist out there
>for doing exactly what I am doing with these incremental
updates, yet
>more automated. We name our scripts specifically so that
they can be
>thrown into a single folder and they are already sorted
by date and
>type, so that a stored procedure update won't reference a
table update
>that has not been applied yet, etc.
>Anyone have any directions they could point me in? I've
tried
>searching the newsgroups and net with no luck so far.
>|||thanks!
No comments:
Post a Comment