I have about 4 production SQL servers all with the same DB structure. Now I need to update them with changes done to my development server. What is the best way to update all four servers? Can DTS update the structure? Or will I have to write a script to update all 4 servers? Any help would be greatly appreciated.

I would be using a tool like Red Gate's SQL Compare. (Check the script
created though)

DTS will not update structure, it simply blows it away and replaces.

When you apply changes in your dev environments do you not keep the ALTER
scripts ?



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"George Prado" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the best way to update all four servers? Can DTS update the structure? Or
will I have to write a script to update all 4 servers? Any help would be
greatly appreciated.

I have not been keeping up with the update statments since I have been doing most of my updates through enterprise manager. I am interested in the Red Gate's SQL Compare you mentioned. Where could I get more information on it

----- Allan Mitchell wrote: ----

I would be using a tool like Red Gate's SQL Compare. (Check the scrip
created though

DTS will not update structure, it simply blows it away and replaces

When you apply changes in your dev environments do you not keep the ALTE
scripts



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP
www.SQLDTS.com - The site for all your DTS needs
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or


"George Prado" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:CFDFD3FD-611D-49EC-B0F5-FD30BFF10B76 (AT) microsoft (DOT) com..
the best way to update all four servers? Can DTS update the structure? O
will I have to write a script to update all 4 servers? Any help would b
greatly appreciated

Here you go. I like it. They also have a Data Compare which is kinda good
as well.

http://www.red-gate.com/sql/summary.htm



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"George Prado" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Red Gate's SQL Compare you mentioned. Where could I get more information on
it?