Compare Problem

Brian DonahueBrian Donahue Posts: 6,590 New member
Hi John,

SQL Data Compare writes lots of temporary XML data in the folder pointed
to by your %TMP% environment variable. Since it's pointing to your personal
profile, I'd be surprised if this was a directory access error.

Could it be that the drive is actually running out of space? If it is,
you may want to go to your System Properties and change the location of your
%TMP% environment variable.

Regards,

Brian Donahue
Red Gate Technical Support

"John-Arne Lillebø" <[email protected]> wrote in message
news:[email protected]
> Hello.
>
> Running v.3.3.5.237 of SQL Data Compare and i sometimes get these
msgbox'es
> when comparing any two databases.
>
> The message is:
> Access to the path "C:DOCUME~1jalLOCALS~1Temp mpAF7.tmp" is denied.
> The filename differs from each time.
>
> I'm an administrator user.
> Didn't have this problem with the last version of SQL Data Compare
>
> Any suggestions ?
>
> John-Arne Lillebø
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi John-Arne,

    Do you use that dodgy 1.1.4322.510 version of .Net Framework? That's
    usually responsible for flaky (inconsistent) behaviour in SQL Bundle.

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    news:B%[email protected]
    > Hi John,
    >
    > SQL Data Compare writes lots of temporary XML data in the folder
    pointed
    > to by your %TMP% environment variable. Since it's pointing to your
    personal
    > profile, I'd be surprised if this was a directory access error.
    >
    > Could it be that the drive is actually running out of space? If it is,
    > you may want to go to your System Properties and change the location of
    your
    > %TMP% environment variable.
    >
    > Regards,
    >
    > Brian Donahue
    > Red Gate Technical Support
    >
    > "John-Arne Lillebø" <[email protected]> wrote in message
    > news:[email protected]
    > > Hello.
    > >
    > > Running v.3.3.5.237 of SQL Data Compare and i sometimes get these
    > msgbox'es
    > > when comparing any two databases.
    > >
    > > The message is:
    > > Access to the path "C:DOCUME~1jalLOCALS~1Temp mpAF7.tmp" is denied.
    > > The filename differs from each time.
    > >
    > > I'm an administrator user.
    > > Didn't have this problem with the last version of SQL Data Compare
    > >
    > > Any suggestions ?
    > >
    > > John-Arne Lillebø
    > >
    > >
    >
    >
This discussion has been closed.