Configuration management tools for SQL Server 2000

Is there a simple tool available that will analyse two SQL Server 2000
databases and report the structural differences between them? A bonus would
be its ability to generate change scripts to bring one of them up to the
state of the other.
Thanks,
AlanCheck out www.red-gate.com
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ejAex3lTEHA.2580@.TK2MSFTNGP12.phx.gbl...
Is there a simple tool available that will analyse two SQL Server 2000
databases and report the structural differences between them? A bonus would
be its ability to generate change scripts to bring one of them up to the
state of the other.
Thanks,
Alan|||I like SQL Compare from red gate, but there are several alternatives.
http://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ejAex3lTEHA.2580@.TK2MSFTNGP12.phx.gbl...
> Is there a simple tool available that will analyse two SQL Server 2000
> databases and report the structural differences between them? A bonus
would
> be its ability to generate change scripts to bring one of them up to the
> state of the other.
> Thanks,
> Alan
>|||Tom - are you on the Red-gate pay roll?

>--Original Message--
>Check out www.red-gate.com
>
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in
message
>news:ejAex3lTEHA.2580@.TK2MSFTNGP12.phx.gbl...
>Is there a simple tool available that will analyse two
SQL Server 2000
>databases and report the structural differences between
them? A bonus would
>be its ability to generate change scripts to bring one
of them up to the
>state of the other.
>Thanks,
>Alan
>
>.
>|||Nope. I just used the product liked it, and wrote a review on it in SQL
Pro.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"sb" <anonymous@.discussions.microsoft.com> wrote in message
news:1a43801c44e65$67f9e3f0$a301280a@.phx
.gbl...
Tom - are you on the Red-gate pay roll?

>--Original Message--
>Check out www.red-gate.com
>
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in
message
>news:ejAex3lTEHA.2580@.TK2MSFTNGP12.phx.gbl...
>Is there a simple tool available that will analyse two
SQL Server 2000
>databases and report the structural differences between
them? A bonus would
>be its ability to generate change scripts to bring one
of them up to the
>state of the other.
>Thanks,
>Alan
>
>.
>|||I use ErWin and/OR ER-Studio.
Greg Jackson
PDX, Oregon|||Have you also done reviews on all the other similar
products to validate your opinion on what to recommend?

>--Original Message--
>Nope. I just used the product liked it, and wrote a
review on it in SQL
>Pro.
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>..
>"sb" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1a43801c44e65$67f9e3f0$a301280a@.phx
.gbl...
>Tom - are you on the Red-gate pay roll?
>
-[vbcol=seagreen]
>--
>message
>SQL Server 2000
>them? A bonus would
>of them up to the
>.
>|||> Tom - are you on the Red-gate pay roll?
He is not, but what difference does that make? He's not forcing anyone to
use the product, he's telling the original poster to check it out.|||alot - it doesn't appear to be impartial.
Isn't being impartial a responsibility for anyone
(especially MVPs) when giving advice? If accurate non-
partial analysis was made with no emotion, that would be
a contribution worthy of the title MVP.
MVPs are a source of information which in the most part
is highly regarded. I would like to see a little more
than a mere plug for a product.

>--Original Message--
>He is not, but what difference does that make? He's not
forcing anyone to
>use the product, he's telling the original poster to
check it out.
>
>.
>|||> MVPs are a source of information which in the most part
> is highly regarded. I would like to see a little more
> than a mere plug for a product.
This is not as easy as it seem to be. I might have used a product and know i
t does the job. I might or might
not know about the other products, and I might now that they exists, but I m
ight not know if they solve the
particular problem, or how well they do it.
We will never be totally impartial, not the MVP's nor the other posters. Som
e of us do in fact spend a
considerable amount of time to test and write about products tested. Most of
us can't, as we need to feed
ourselves the out families.
So end result can quite simply be that we stop mentioning the product, just
so we don't come out as being
partial. I think that the Op will miss out. If I would need more info about
how well one product stand against
another product, I would just ask that in a follow-up. Or ask if people know
about other products...
Also, is a tool vendor here find that we recommend one product, and that is
not the product they he/she is
selling, I for one wouldn't mind at all a post from the tool vendor stating
that he also develops a product
for this purpose... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sb" <anonymous@.discussions.microsoft.com> wrote in message news:1aa2701c44ed4$44e973c0$a101
280a@.phx.gbl...[vbcol=seagreen]
> alot - it doesn't appear to be impartial.
> Isn't being impartial a responsibility for anyone
> (especially MVPs) when giving advice? If accurate non-
> partial analysis was made with no emotion, that would be
> a contribution worthy of the title MVP.
> MVPs are a source of information which in the most part
> is highly regarded. I would like to see a little more
> than a mere plug for a product.
>
> forcing anyone to
> check it out.