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?
>>--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
>>
>>.
>.
>|||> 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--
>> 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.
>
>.
>|||> 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 it does the job. I might or might
not know about the other products, and I might now that they exists, but I might 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. Some 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$a101280a@.phx.gbl...
> 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--
> >> 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.
> >
> >
> >.
> >|||thanks for the reply Tibor.
I do believe MVPs should not plug a single product but
point out the pros and cons of each. If they can't, they
don't know what they are talking about, so silence is the
better option.
They could of course earn their titles and get educated
as this is a large part of the job and which has earned
them their title. MVPs should be a source of facts. This
for obvious reasons cannot apply to the general public,
but you are in a position of which I for one hold in high
regard - you cannot afford to have this tainted. Your
information is your reputation - if it is below par - so
are you.
>--Original Message--
>> 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 it does the job. I might or might
>not know about the other products, and I might now that
they exists, but I might 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. Some 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$a101280a@.phx.gbl...
>> 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--
>> >> 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.
>> >
>> >
>> >.
>> >
>
>.
>|||I agree with you general standpoint of this, but please remember that MVP's, as well as newsgroups in general,
are about peer-to-peer sharing. I.e., it is all about volunteer and unpaid sharing/helping. We could have the
standpoint to "never mention a 3:rd party product unless you have evaluated and compared them all", but end
result of that is that very few such products will ever be mentioned...
(I wouldn't mind doing product comparison, but I need to earn an income...)
Personally, I'm always hesitant to mention 3:rd party products, partly because of your point, and partly
because I might only know that it exists (i.e., I might not even have used the product). What is best for the
OP? Not getting a reply at all, or having something to investigate? I've decided on some "middle of the road",
where I list 3:rd party products on my web-site, and of course all are welcome to inform me of the existence
of such a product.
--
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:1a5e801c44edd$b37143a0$a601280a@.phx.gbl...
> thanks for the reply Tibor.
> I do believe MVPs should not plug a single product but
> point out the pros and cons of each. If they can't, they
> don't know what they are talking about, so silence is the
> better option.
> They could of course earn their titles and get educated
> as this is a large part of the job and which has earned
> them their title. MVPs should be a source of facts. This
> for obvious reasons cannot apply to the general public,
> but you are in a position of which I for one hold in high
> regard - you cannot afford to have this tainted. Your
> information is your reputation - if it is below par - so
> are you.
> >--Original Message--
> >> 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 it does the job. I might or might
> >not know about the other products, and I might now that
> they exists, but I might 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. Some 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$a101280a@.phx.gbl...
> >> 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--
> >> >> 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.
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||> I do believe MVPs should not plug a single product but
> point out the pros and cons of each.
That's fine, when we have the data. Are you suggesting that because I am an
MVP, before I suggest the only product I've ever used for this product, I
need to go and research every other available product?
You're out of your tree.
> If they can't, they
> don't know what they are talking about, so silence is the
> better option.
Bullsh*t. I've used a product, I know it works, therefore I'm going to
suggest it. Silence is NOT the better option... nobody is going to be
completely impartial and have a 100% unbiased and accurate comprehensive
analysis of every single tool available to perform a specific, and often
obscure, task.
> They could of course earn their titles and get educated
> as this is a large part of the job and which has earned
> them their title. MVPs should be a source of facts.
Being an MVP has nothing to do with having extensive knowledge of every
single 3rd party tool available. We're human too, remember.
> information is your reputation - if it is below par - so
> are you.
Cram it.|||hello Tibor,
thanks again for your reply.
I do think that MVPs should approach product
recommendations with the same professionalism they do
with the core product, where time does not seem to be an
issue.
>--Original Message--
>I agree with you general standpoint of this, but please
remember that MVP's, as well as newsgroups in general,
>are about peer-to-peer sharing. I.e., it is all about
volunteer and unpaid sharing/helping. We could have the
>standpoint to "never mention a 3:rd party product unless
you have evaluated and compared them all", but end
>result of that is that very few such products will ever
be mentioned...
>(I wouldn't mind doing product comparison, but I need to
earn an income...)
>Personally, I'm always hesitant to mention 3:rd party
products, partly because of your point, and partly
>because I might only know that it exists (i.e., I might
not even have used the product). What is best for the
>OP? Not getting a reply at all, or having something to
investigate? I've decided on some "middle of the road",
>where I list 3:rd party products on my web-site, and of
course all are welcome to inform me of the existence
>of such a product.
>--
>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:1a5e801c44edd$b37143a0$a601280a@.phx.gbl...
>> thanks for the reply Tibor.
>> I do believe MVPs should not plug a single product but
>> point out the pros and cons of each. If they can't,
they
>> don't know what they are talking about, so silence is
the
>> better option.
>> They could of course earn their titles and get educated
>> as this is a large part of the job and which has earned
>> them their title. MVPs should be a source of facts.
This
>> for obvious reasons cannot apply to the general public,
>> but you are in a position of which I for one hold in
high
>> regard - you cannot afford to have this tainted. Your
>> information is your reputation - if it is below par -
so
>> are you.
>> >--Original Message--
>> >> 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 it does the job. I might or might
>> >not know about the other products, and I might now
that
>> they exists, but I might 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. Some 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$a101280a@.phx.gbl...
>> >> 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--
>> >> >> 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.
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>|||> I do think that MVPs should approach product
> recommendations with the same professionalism they do
> with the core product, where time does not seem to be an
> issue.
Well, gee, we work with the core product every day, and most of us earn our
living from it.
We don't, however, work with every single 3rd party product, for every
imaginable task, every day.
It's not like we go out and take a SQL Server course every time we attempt
to answer a question. If that's the equivalent of what you expect us to do
for product recommendations, well, don't hold your breath. Maybe you should
avoid such threads so you don't get so worked up about it, because what
you're asking simply isn't going to happen. As the others mentioned, we
have families to feed, just like you.
MVPs are not coming out and saying users must use this product. We're
offering a tool (or in my case, usually a relatively long list of tools) for
the user to investigate. If I have used a specific tool, I will mention
that, because I think it's useful information. If I have used a tool and it
sucks, I'm not afraid to mention that, either.
You might disagree. Tough. What you're proposing is some kind of
censorship that will leave users worse off than you perceive them to be now.
A|||hello Aaron,
So I take it if a question was asked to you about
replication and all you had ever used was transactional
replication, because it suited you you'd recommend it?
What I am pushing for here is better information, and
what is wrong with that?
By the way I love the colloquialisms.
>--Original Message--
>> I do believe MVPs should not plug a single product but
>> point out the pros and cons of each.
>That's fine, when we have the data. Are you suggesting
that because I am an
>MVP, before I suggest the only product I've ever used
for this product, I
>need to go and research every other available product?
>You're out of your tree.
>> If they can't, they
>> don't know what they are talking about, so silence is
the
>> better option.
>Bullsh*t. I've used a product, I know it works,
therefore I'm going to
>suggest it. Silence is NOT the better option... nobody
is going to be
>completely impartial and have a 100% unbiased and
accurate comprehensive
>analysis of every single tool available to perform a
specific, and often
>obscure, task.
>> They could of course earn their titles and get educated
>> as this is a large part of the job and which has earned
>> them their title. MVPs should be a source of facts.
>Being an MVP has nothing to do with having extensive
knowledge of every
>single 3rd party tool available. We're human too,
remember.
>> information is your reputation - if it is below par -
so
>> are you.
>Cram it.
>
>.
>|||> So I take it if a question was asked to you about
> replication and all you had ever used was transactional
> replication, because it suited you you'd recommend it?
If it fit the requirements, yes. If transactional replication wouldn't work
to meet the requirements, DUH, of course not.
Have I ever suggested something that didn't make sense, simply because it
was the only answer I knew?
You're not even taling apples vs. oranges here, you're talking apples vs.
car batteries.
> What I am pushing for here is better information, and
> what is wrong with that?
You're expecting MVPs to be completely unbiased and have gobs and gobs of
free time to research every single product before recommending one that they
have used, worked well, and that the user could investigate.
Once again, fat chance!
What is your interest in this? Are you a competitor to red-gate?|||> Have you also done reviews on all the other similar
> products to validate your opinion on what to recommend?
Mr. Anonymous, he said "check it out" not "this is the best product ever."|||> I do think that MVPs should approach product
> recommendations with the same professionalism they do
> with the core product, where time does not seem to be an
> issue.
Perhaps there's a misunderstanding about the MVP program. We are not paid by Microsoft. We earn our money from
"regular" work. I am a trainer and consultant, for instance.
I've decided to share what I've come to learn about the product from working. In hope that it will help
others. That's all.
If I get a request to earn money from working with a 3:rd party tool and I feel that I will do a good job with
that, then I would accept that job. During that period of time, I would get to know that tool, and if I like
it, I would probably comment on that tool here.
However, you can't expect us to take unpaid time to evaluate tools, so we can post unbiased comments about
them. You could post a request with MS that they pay someone to do that. But all of us here work for their
money and have house, rent, mortgages, insurances, food and all that stuff to pay.
MS could decide to censor the MVP's, in order to be more fair with the 3:rd party vendors. However, I don't
think it would gain the 3:rd party vendors, nor the community, and I know for sure that I wouldn't not
appreciate being censored.
--
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:1ab6501c44ef5$9ecf0d20$a401280a@.phx.gbl...
> hello Tibor,
> thanks again for your reply.
> I do think that MVPs should approach product
> recommendations with the same professionalism they do
> with the core product, where time does not seem to be an
> issue.
> >--Original Message--
> >I agree with you general standpoint of this, but please
> remember that MVP's, as well as newsgroups in general,
> >are about peer-to-peer sharing. I.e., it is all about
> volunteer and unpaid sharing/helping. We could have the
> >standpoint to "never mention a 3:rd party product unless
> you have evaluated and compared them all", but end
> >result of that is that very few such products will ever
> be mentioned...
> >(I wouldn't mind doing product comparison, but I need to
> earn an income...)
> >
> >Personally, I'm always hesitant to mention 3:rd party
> products, partly because of your point, and partly
> >because I might only know that it exists (i.e., I might
> not even have used the product). What is best for the
> >OP? Not getting a reply at all, or having something to
> investigate? I've decided on some "middle of the road",
> >where I list 3:rd party products on my web-site, and of
> course all are welcome to inform me of the existence
> >of such a product.
> >--
> >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:1a5e801c44edd$b37143a0$a601280a@.phx.gbl...
> >> thanks for the reply Tibor.
> >>
> >> I do believe MVPs should not plug a single product but
> >> point out the pros and cons of each. If they can't,
> they
> >> don't know what they are talking about, so silence is
> the
> >> better option.
> >> They could of course earn their titles and get educated
> >> as this is a large part of the job and which has earned
> >> them their title. MVPs should be a source of facts.
> This
> >> for obvious reasons cannot apply to the general public,
> >> but you are in a position of which I for one hold in
> high
> >> regard - you cannot afford to have this tainted. Your
> >> information is your reputation - if it is below par -
> so
> >> are you.
> >>
> >> >--Original Message--
> >> >> 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 it does the job. I might or might
> >> >not know about the other products, and I might now
> that
> >> they exists, but I might 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. Some 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$a101280a@.phx.gbl...
> >> >> 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--
> >> >> >> 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.
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||I'll offer you a deal. If you don't like the advice of an MVP, we will
happily refund your community registration fee.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"sb" <anonymous@.discussions.microsoft.com> wrote in message
news:1abdb01c44ef8$5100f650$a101280a@.phx.gbl...
> hello Aaron,
> So I take it if a question was asked to you about
> replication and all you had ever used was transactional
> replication, because it suited you you'd recommend it?
> What I am pushing for here is better information, and
> what is wrong with that?
> By the way I love the colloquialisms.
> >--Original Message--
> >> I do believe MVPs should not plug a single product but
> >> point out the pros and cons of each.
> >
> >That's fine, when we have the data. Are you suggesting
> that because I am an
> >MVP, before I suggest the only product I've ever used
> for this product, I
> >need to go and research every other available product?
> >
> >You're out of your tree.
> >
> >> If they can't, they
> >> don't know what they are talking about, so silence is
> the
> >> better option.
> >
> >Bullsh*t. I've used a product, I know it works,
> therefore I'm going to
> >suggest it. Silence is NOT the better option... nobody
> is going to be
> >completely impartial and have a 100% unbiased and
> accurate comprehensive
> >analysis of every single tool available to perform a
> specific, and often
> >obscure, task.
> >
> >> They could of course earn their titles and get educated
> >> as this is a large part of the job and which has earned
> >> them their title. MVPs should be a source of facts.
> >
> >Being an MVP has nothing to do with having extensive
> knowledge of every
> >single 3rd party tool available. We're human too,
> remember.
> >
> >> information is your reputation - if it is below par -
> so
> >> are you.
> >
> >Cram it.
> >
> >
> >.
> >|||Hello Aaron,
It looks like we are going to have a difference of
opinion which I see nothing wrong with.
I have watched this topic come up on numerous occasions
and have not said anything up until now. I really wish
one of you MVPs would spend the time to research this
topic as all I have ever seen are plugs when this comes
up. It really doesn't look unbiased (I know you're
allowed to be) or professional from where I'm standing. I
also think there has been enough interest to warrant the
effort. All that I have written has had no affiliation to
any product only the topic.
I am entitled to my opinion and I do not appreciate the
slur as having fallen out of my tree, or being told
to "Cram it" as I have kept this thread professional.
>--Original Message--
>> So I take it if a question was asked to you about
>> replication and all you had ever used was transactional
>> replication, because it suited you you'd recommend it?
>If it fit the requirements, yes. If transactional
replication wouldn't work
>to meet the requirements, DUH, of course not.
>Have I ever suggested something that didn't make sense,
simply because it
>was the only answer I knew?
>You're not even taling apples vs. oranges here, you're
talking apples vs.
>car batteries.
>> What I am pushing for here is better information, and
>> what is wrong with that?
>You're expecting MVPs to be completely unbiased and have
gobs and gobs of
>free time to research every single product before
recommending one that they
>have used, worked well, and that the user could
investigate.
>Once again, fat chance!
>What is your interest in this? Are you a competitor to
red-gate?
>
>.
>|||> I'll offer you a deal. If you don't like the advice of an MVP, we will
> happily refund your community registration fee.
LOL!
Now, if I don't like the moaning from a community member about all of our
bad advice and biased recommendations, where do I get my refund? ;-)|||Probably have to talk to Stephen about that.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eu1logwTEHA.3332@.TK2MSFTNGP12.phx.gbl...
> > I'll offer you a deal. If you don't like the advice of an MVP, we will
> > happily refund your community registration fee.
> LOL!
> Now, if I don't like the moaning from a community member about all of our
> bad advice and biased recommendations, where do I get my refund? ;-)
>|||> I really wish
> one of you MVPs would spend the time to research this
> topic
I'm sure that many of us would be happy to do that. But the point is that no-one would be willing to pay for
that. Do you expect us to go unpaid during that evaluation?
Please consider that evaluating only one tool will be from half a day to a week worth of work. Imagine 5
tools, and then some comparison of them. That will easily be a man-month worth of work. Sure, I'm willing to
do that, if someone cough up the dough for that. As long as no-one is doing that, I need to earn my money
elsewhere.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/|||Your definition of "professional" is quite equivalent to my definitions of
"accusatory" and "stand-offish."
For starters, did you notice that my reply said:
"I like SQL Compare from red gate, but there are several alternatives.
http://www.aspfaq.com/2209"
If you look at the link I posted, you will see that I have compiled a list
of links to several capable products, including Red-Gate. I don't expect to
tell the user which product to use, because I simply don't have the time to
adequately test all of them. Do you? If so, please feel free to post a
review of each product, so the user might decide which one to use without
having to lift a finger! I'd be interested to see how you find the time to
do so; I guess you'll have to put aside this need to spend over 18 hours now
worried about getting your 2 cents in, telling the rest of us how we should
be quiet.
Do you expect every MVP to memorize the full list of available tools? Do
you not expect all people (MVP or not) to chime in when they know that a
tool they have used may meet the user's needs? Where, and in what charter,
does it say that MVPs have to, or are even casually expected to, provide
unilateral coverage of every 3rd party product known to man? We are not
talking about election campaign airtime here.
My company has a license for Red-Gate's tools, so I have no problem adding
the information (deemed helpful by most, yourself aside, I'm sure) that I
have had good luck with the product. Notice, again, that I did not say
"this is the only tool you need" or "this product kicks ass" or "this is the
best product out there." I said "I like it." In my understanding of the
English language, that does not translate to, and should not be interpreted
as, "you must like it too. Or else." The user is free to use that
information, or not use that information, as he/she evaluates a product that
will meet their needs.
If you don't like that, killfile me. Killfile all MVPs, for all I care.
But don't tell us how we should spend our non-paid time... unless you are
offering to pay me for the time I spend needlessly reviewing every single
3rd party product for SQL Server.
E-mail me if that's the case. Otherwise, adieu.
*PLONK*
--
http://www.aspfaq.com/
(Reverse address to reply.)
"sb" <anonymous@.discussions.microsoft.com> wrote in message
news:1afc601c44f07$9b922c70$a001280a@.phx.gbl...
> Hello Aaron,
> It looks like we are going to have a difference of
> opinion which I see nothing wrong with.
> I have watched this topic come up on numerous occasions
> and have not said anything up until now. I really wish
> one of you MVPs would spend the time to research this
> topic as all I have ever seen are plugs when this comes
> up. It really doesn't look unbiased (I know you're
> allowed to be) or professional from where I'm standing. I
> also think there has been enough interest to warrant the
> effort. All that I have written has had no affiliation to
> any product only the topic.
> I am entitled to my opinion and I do not appreciate the
> slur as having fallen out of my tree, or being told
> to "Cram it" as I have kept this thread professional.|||Aaron, I suspect that Stephen will just laugh at you.
--
Not so sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:elk2WiwTEHA.2408@.tk2msftngp13.phx.gbl...
> Probably have to talk to Stephen about that.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:eu1logwTEHA.3332@.TK2MSFTNGP12.phx.gbl...
> > > I'll offer you a deal. If you don't like the advice of an MVP, we
will
> > > happily refund your community registration fee.
> >
> > LOL!
> >
> > Now, if I don't like the moaning from a community member about all of
our
> > bad advice and biased recommendations, where do I get my refund? ;-)
> >
> >
>|||> Aaron, I suspect that Stephen will just laugh at you.
How appropriate. ;-)|||Hi Alan,
Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data.
You can find it here:
http://www.extreme.co.il
"Aaron [SQL Server MVP]" wrote:
> 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
> >
> >
>
>|||Hi Alan,
Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data.
You can find it here:
http://www.extreme.co.il
"Alan Howard" wrote:
> 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
>
>|||Hi all,
Thanks for your suggestions and spirited debate. I tried the eval of SQL
Compare from Red Gate and would like to say I've had a look at the others
but I just haven't had the time yet. SQL Compare is a nifty tool.
Regards,
Alan
"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
>