Options
database.register
Brian Donahue
Posts: 6,590 Bronze 1
Hi Louis,
Reading Comments is a bit of a misnomer. The IgnoreComments option
specifically refers to the extended properties of a database object, while
the message 'reading comments...' refers to the software pulling information
from the syscomments table. There is a patch out to fix this problem, which
you can download from ftp://ftp.red-gate.com/Patch to 3.15b.zip.
Once you get the zip archive, extract all of the files to your
installation folder. I believe you may need to update your references to the
SQLCompare.Engine.dll once you've got the new file because there is a
different version number and it is a strong-named assembly.
Please let me know if you have any more problems with this!
Regards,
Brian Donahue
Red Gate Technical Support
"Louis Romestant" <romestantl@software-answers.com> wrote in message
news:ayhHpZCOEHA.2140@server53...
> Hi;
>
> I'm running a few experiments with the toolkit and for the most part
things
> are working well. I've pretty much just replicated your sample code which
> would go a long way in explaining this fact. However, when I
> database.register it spends maybe a minute on what appears to be "Reading
> comments" while the Sql Compare application itself just blows right
through
> when comparing the same two databases.
>
> I tried Options.Default | Options.IgnoreComments thinking this might have
an
> effect, but no such lick.
>
> What could it be I am missing?
>
> thanks;
>
> Louis
>
>
Reading Comments is a bit of a misnomer. The IgnoreComments option
specifically refers to the extended properties of a database object, while
the message 'reading comments...' refers to the software pulling information
from the syscomments table. There is a patch out to fix this problem, which
you can download from ftp://ftp.red-gate.com/Patch to 3.15b.zip.
Once you get the zip archive, extract all of the files to your
installation folder. I believe you may need to update your references to the
SQLCompare.Engine.dll once you've got the new file because there is a
different version number and it is a strong-named assembly.
Please let me know if you have any more problems with this!
Regards,
Brian Donahue
Red Gate Technical Support
"Louis Romestant" <romestantl@software-answers.com> wrote in message
news:ayhHpZCOEHA.2140@server53...
> Hi;
>
> I'm running a few experiments with the toolkit and for the most part
things
> are working well. I've pretty much just replicated your sample code which
> would go a long way in explaining this fact. However, when I
> database.register it spends maybe a minute on what appears to be "Reading
> comments" while the Sql Compare application itself just blows right
through
> when comparing the same two databases.
>
> I tried Options.Default | Options.IgnoreComments thinking this might have
an
> effect, but no such lick.
>
> What could it be I am missing?
>
> thanks;
>
> Louis
>
>
This discussion has been closed.
Comments
Is the registration getting past 'reading comments' after a while, or is
it locking up completely? You may want to check that your event logs aren't
filling up. But then again, the application should throw an exception if
that happens, I think...
Regards,
Brian Donahue
Red Gate Technical Support
"Louis Romestant" <romestantl@software-answers.com> wrote in message
news:8h5M4QFOEHA.1224@server53...
> Brian;
>
> Thanks. I downloaded the patch and applied it after a kind man showed me
> how to use my ftp client. I now have version 3.1.6.200 of
> RedGate.SQLCompare.Engine. Is that correct? It doesn't seem to have made
a
> difference. I dropped and re-added the reference.
>
> What else should I look for?
>
> thanks;
>
> Louis
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:72YQ2ZEOEHA.1224@server53...
> > Hi Louis,
> >
> > Reading Comments is a bit of a misnomer. The IgnoreComments option
> > specifically refers to the extended properties of a database object,
while
> > the message 'reading comments...' refers to the software pulling
> information
> > from the syscomments table. There is a patch out to fix this problem,
> which
> > you can download from ftp://ftp.red-gate.com/Patch to 3.15b.zip.
> >
> > Once you get the zip archive, extract all of the files to your
> > installation folder. I believe you may need to update your references to
> the
> > SQLCompare.Engine.dll once you've got the new file because there is a
> > different version number and it is a strong-named assembly.
> >
> > Please let me know if you have any more problems with this!
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Louis Romestant" <romestantl@software-answers.com> wrote in message
> > news:ayhHpZCOEHA.2140@server53...
> > > Hi;
> > >
> > > I'm running a few experiments with the toolkit and for the most part
> > things
> > > are working well. I've pretty much just replicated your sample code
> which
> > > would go a long way in explaining this fact. However, when I
> > > database.register it spends maybe a minute on what appears to be
> "Reading
> > > comments" while the Sql Compare application itself just blows right
> > through
> > > when comparing the same two databases.
> > >
> > > I tried Options.Default | Options.IgnoreComments thinking this might
> have
> > an
> > > effect, but no such lick.
> > >
> > > What could it be I am missing?
> > >
> > > thanks;
> > >
> > > Louis
> > >
> > >
> >
> >
>
>
The dependency information exists in the (not-aptly-named) syscomments
table of the database. I'd say that most, if not all, of the dependency
queries are done while 'Reading Syscomments'. Are you still experiencing
really horrid performance problems compared to version 3.10? Even on really
massive databases, the dependency generation should only be taking an
additional few seconds.
There is also a new version of SQLCompare.Engine (3.16) released last
Friday. I'd try updating the software and see if the performance is any
better (it doesn't write parser errors into the event log any more...).
Regards,
Brian Donahue
Red Gate Technical Support
"Chris Tybur" <ctybur@infinitevisions.com> wrote in message
news:4$LLDQFPEHA.1512@server53...
> At what point does the comparison engine build its dependency matrix? Is
> it while the status says 'Reading comments'? Is it before syscomments is
> read?
>
> Chris
>
> Brian Donahue (Red Gate) wrote:
>
> > Hi Louis,
> >
> > Reading Comments is a bit of a misnomer. The IgnoreComments option
> > specifically refers to the extended properties of a database object,
while
> > the message 'reading comments...' refers to the software pulling
information
> > from the syscomments table. There is a patch out to fix this problem,
which
> > you can download from ftp://ftp.red-gate.com/Patch to 3.15b.zip.
> >
> > Once you get the zip archive, extract all of the files to your
> > installation folder. I believe you may need to update your references to
the
> > SQLCompare.Engine.dll once you've got the new file because there is a
> > different version number and it is a strong-named assembly.
> >
> > Please let me know if you have any more problems with this!
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Louis Romestant" <romestantl@software-answers.com> wrote in message
> > news:ayhHpZCOEHA.2140@server53...
> >
> >>Hi;
> >>
> >>I'm running a few experiments with the toolkit and for the most part
> >
> > things
> >
> >>are working well. I've pretty much just replicated your sample code
which
> >>would go a long way in explaining this fact. However, when I
> >>database.register it spends maybe a minute on what appears to be
"Reading
> >>comments" while the Sql Compare application itself just blows right
> >
> > through
> >
> >>when comparing the same two databases.
> >>
> >>I tried Options.Default | Options.IgnoreComments thinking this might
have
> >
> > an
> >
> >>effect, but no such lick.
> >>
> >>What could it be I am missing?
> >>
> >>thanks;
> >>
> >>Louis
> >>
> >>
> >
> >
> >
>