Doing a diff on 2 identical databases?

I have a production database that has log shipping enabled to a remote
server. It has been about a year now, and i wanted to know if there was a
tool or command i can use to do a diff to assure that both databases are in
fact truly in sync. Due to the application utilizing the database, it is
running in Bulk-logged mode and not FULL. Any help is greatly appreciated.You could use DataCompare from Redgate or AdeptSQL Diff - both do
essentially the same.
HTH,
Paul Ibison|||On Thu, 19 Jul 2007 22:55:26 +0100, Paul Ibison wrote:
> You could use DataCompare from Redgate or AdeptSQL Diff - both do
> essentially the same.
> HTH,
> Paul Ibison
Also look into a free tool from Quest: ComparisonSuite for SQLServer I use
it and it works really well.
-Chuck|||ApexSQL Diff is very good.
--
TheSQLGuru
President
Indicium Resources, Inc.
"FS" <FS@.discussions.microsoft.com> wrote in message
news:A9351434-E932-4F55-837D-B3ED75B44BAF@.microsoft.com...
>I have a production database that has log shipping enabled to a remote
> server. It has been about a year now, and i wanted to know if there was a
> tool or command i can use to do a diff to assure that both databases are
> in
> fact truly in sync. Due to the application utilizing the database, it is
> running in Bulk-logged mode and not FULL. Any help is greatly appreciated.|||Thank you all for your replies.
"TheSQLGuru" wrote:
> ApexSQL Diff is very good.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "FS" <FS@.discussions.microsoft.com> wrote in message
> news:A9351434-E932-4F55-837D-B3ED75B44BAF@.microsoft.com...
> >I have a production database that has log shipping enabled to a remote
> > server. It has been about a year now, and i wanted to know if there was a
> > tool or command i can use to do a diff to assure that both databases are
> > in
> > fact truly in sync. Due to the application utilizing the database, it is
> > running in Bulk-logged mode and not FULL. Any help is greatly appreciated.
>
>