Home All Groups Group Topic Archive Search About

Looking for Database comparison/synchronizing tool

Author
3 Oct 2006 3:19 PM
Matthew Mark
I've read a lot of info but would like to hear from you all who've actually
used these tools. I'm sure you've made purchases that didn't live up to your
expectations. We are using SQL Server 2000 and will eventually move to 2005.
We use merge replication.

The ones that look the best to me are Red Gate and SQL Delta. I want to hear
your experiences both good and bad. And, let me know if you have another tool
you really like.

Thanks,
--
Matthew Mark

Author
3 Oct 2006 3:33 PM
Sue Hoegemeier
I have nothing but good things to say about using Red Gate
for this. Definitely met expectations.

-Sue

On Tue, 3 Oct 2006 08:19:01 -0700, Matthew Mark
<MatthewM***@discussions.microsoft.com> wrote:

Show quote
>I've read a lot of info but would like to hear from you all who've actually
>used these tools. I'm sure you've made purchases that didn't live up to your
>expectations. We are using SQL Server 2000 and will eventually move to 2005.
>We use merge replication.
>
>The ones that look the best to me are Red Gate and SQL Delta. I want to hear
>your experiences both good and bad. And, let me know if you have another tool
>you really like.
>
>Thanks,
Author
3 Oct 2006 8:32 PM
Keith Kratochvil
I second that opinion.  I have used Red Gate's tools and they work well.

Here are a few additional tools that you may find helpful:
Red Gate has a tool called SQL Compare
http://www.red-gate.com/

Quest - Comparison Suite for SQL Server
http://www.quest.com/sql_server/

Innovartis DB Ghost
http://www.dbghost.com

Data Dude (a Visual Studio product)
http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx

--
Keith Kratochvil


Show quote
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:fk05i2lk6sectbgb454it187famcse8mcb@4ax.com...
>I have nothing but good things to say about using Red Gate
> for this. Definitely met expectations.
>
> -Sue
>
> On Tue, 3 Oct 2006 08:19:01 -0700, Matthew Mark
> <MatthewM***@discussions.microsoft.com> wrote:
>
>>I've read a lot of info but would like to hear from you all who've
>>actually
>>used these tools. I'm sure you've made purchases that didn't live up to
>>your
>>expectations. We are using SQL Server 2000 and will eventually move to
>>2005.
>>We use merge replication.
>>
>>The ones that look the best to me are Red Gate and SQL Delta. I want to
>>hear
>>your experiences both good and bad. And, let me know if you have another
>>tool
>>you really like.
>>
>>Thanks,
>
Author
3 Oct 2006 8:46 PM
Sue Hoegemeier
Glad to see you still around here. Think January.... : )
BTW - did you move or just dump the site you had with the
log shipping scripts you had up there? I was looking for it
to refer someone to it quite awhile back and your site was
gone. Any plans to resurrect it?

-Sue

On Tue, 3 Oct 2006 15:32:36 -0500, "Keith Kratochvil"
<sqlguy.bac***@comcast.net> wrote:

Show quote
>I second that opinion.  I have used Red Gate's tools and they work well.
>
>Here are a few additional tools that you may find helpful:
>Red Gate has a tool called SQL Compare
>http://www.red-gate.com/
>
>Quest - Comparison Suite for SQL Server
>http://www.quest.com/sql_server/
>
>Innovartis DB Ghost
>http://www.dbghost.com
>
>Data Dude (a Visual Studio product)
>http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx
Author
3 Oct 2006 9:36 PM
Keith Kratochvil
Wow, I am surprised that people are still referring to that old page.  I
will look around for the old pages/info that I had online and try to get it
posted somewhere.

Fortunately there are some other good pages available out there:

314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515

323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135

325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220

821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786

321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247

329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133




--
Keith Kratochvil


Show quote
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:ppi5i299qrvs7ls908v3lj9qq5ou78783n@4ax.com...
> Glad to see you still around here. Think January.... : )
> BTW - did you move or just dump the site you had with the
> log shipping scripts you had up there? I was looking for it
> to refer someone to it quite awhile back and your site was
> gone. Any plans to resurrect it?
>
> -Sue
>
> On Tue, 3 Oct 2006 15:32:36 -0500, "Keith Kratochvil"
> <sqlguy.bac***@comcast.net> wrote:
>
>>I second that opinion.  I have used Red Gate's tools and they work well.
>>
>>Here are a few additional tools that you may find helpful:
>>Red Gate has a tool called SQL Compare
>>http://www.red-gate.com/
>>
>>Quest - Comparison Suite for SQL Server
>>http://www.quest.com/sql_server/
>>
>>Innovartis DB Ghost
>>http://www.dbghost.com
>>
>>Data Dude (a Visual Studio product)
>>http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx
>
Author
4 Oct 2006 1:28 AM
Jason Allison
Hi all,

This info is much appreciated, if I may I would like to extend this a little
further. I am looking for a product (I have no idea who makes it) called Key
Change. I can't seem to find it via search, but have heard it is a great
product. It supposedly allows you to completely remap an entire SQL
database. Is anyone aware of this product? If so caould someone point me in
the right direction?

Regards,

Jason
Show quote
"Keith Kratochvil" <sqlguy.bac***@comcast.net> wrote in message
news:eRui5Qz5GHA.1196@TK2MSFTNGP02.phx.gbl...
> Wow, I am surprised that people are still referring to that old page.  I
> will look around for the old pages/info that I had online and try to get
> it posted somewhere.
>
> Fortunately there are some other good pages available out there:
>
> 314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
> http://support.microsoft.com/?id=314515
>
> 323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
> Paper)
> http://support.microsoft.com/?id=323135
>
> 325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
> http://support.microsoft.com/?id=325220
>
> 821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
> http://support.microsoft.com/?id=821786
>
> 321247 HOW TO: Configure Security for Log Shipping
> http://support.microsoft.com/?id=321247
>
> 329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
> Errors
> http://support.microsoft.com/?id=329133
>
>
>
>
> --
> Keith Kratochvil
>
>
> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> news:ppi5i299qrvs7ls908v3lj9qq5ou78783n@4ax.com...
>> Glad to see you still around here. Think January.... : )
>> BTW - did you move or just dump the site you had with the
>> log shipping scripts you had up there? I was looking for it
>> to refer someone to it quite awhile back and your site was
>> gone. Any plans to resurrect it?
>>
>> -Sue
>>
>> On Tue, 3 Oct 2006 15:32:36 -0500, "Keith Kratochvil"
>> <sqlguy.bac***@comcast.net> wrote:
>>
>>>I second that opinion.  I have used Red Gate's tools and they work well.
>>>
>>>Here are a few additional tools that you may find helpful:
>>>Red Gate has a tool called SQL Compare
>>>http://www.red-gate.com/
>>>
>>>Quest - Comparison Suite for SQL Server
>>>http://www.quest.com/sql_server/
>>>
>>>Innovartis DB Ghost
>>>http://www.dbghost.com
>>>
>>>Data Dude (a Visual Studio product)
>>>http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx
>>
>
>
Author
4 Oct 2006 3:50 AM
Sue Hoegemeier
Some of what you had was more along the lines of what is on
SQL Server Central. There are a lot of people using log
shipping in 2000 on standard edition - in other words no
wizard. You did have some decent info on your site for that
scenario.

-Sue

On Tue, 3 Oct 2006 16:36:05 -0500, "Keith Kratochvil"
<sqlguy.bac***@comcast.net> wrote:

Show quote
>Wow, I am surprised that people are still referring to that old page.  I
>will look around for the old pages/info that I had online and try to get it
>posted somewhere.
>
>Fortunately there are some other good pages available out there:
>
>314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
>http://support.microsoft.com/?id=314515
>
>323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
>Paper)
>http://support.microsoft.com/?id=323135
>
>325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
>http://support.microsoft.com/?id=325220
>
>821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
>http://support.microsoft.com/?id=821786
>
>321247 HOW TO: Configure Security for Log Shipping
>http://support.microsoft.com/?id=321247
>
>329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
>Errors
>http://support.microsoft.com/?id=329133
Author
5 Oct 2006 12:24 PM
Martijn Tonies
> I've read a lot of info but would like to hear from you all who've
actually
> used these tools. I'm sure you've made purchases that didn't live up to
your
> expectations. We are using SQL Server 2000 and will eventually move to
2005.
> We use merge replication.
>
> The ones that look the best to me are Red Gate and SQL Delta. I want to
hear
> your experiences both good and bad. And, let me know if you have another
tool
> you really like.

You might also want to try Database Workbench, it includes a compare tool:
www.upscene.com



--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

AddThis Social Bookmark Button