database.register

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited May 18, 2004 5:18AM in SQL Toolkit Previous Versions
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
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Louis,

    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
    > > >
    > > >
    > >
    > >
    >
    >
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Chris,

    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
    > >>
    > >>
    > >
    > >
    > >
    >
This discussion has been closed.