Reporting in Data Compare

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 23, 2003 11:26AM in SQL Data Compare Previous Versions
Hi Andrew,

There is no HTML reporting in Data Compare at the moment, but it may
appear in a future version. In the meantime, you can export Data Compare
results in Comma Separated Value format.

To program the SQL Data Compare COM objects, we sell a SQL Toolkit,
which contains the instructions and examples for programming the Red Gate
libraries. The details are on our website.

If you're familiar with Visual Basic, it would be possible to export the
results in HTML format if you had the toolkit documentation. The results
would be held in a collection that you could write to a file, inserting HTML
tags inbetween.

Regards,

Brian Donahue

"Andrew Harrington" <andrew.harrington@wallst.com> wrote in message
news:9elLhPrCDHA.1176@server53...
> Does HTML reporting exist for Data Compare the way it does for SQL
Compare?
> If not, can something be created through the COM object?
>
> We'd like to create a daily or weekly report displaying what data might be
> out of synch (with the understanding that we don't want to dump the entire
> contents of the tables on a web page).
>
> Thanks
> Andrew
>
>
· Share on Twitter

Comments

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

    Thanks for your post to the newsgroup. The only data export function in
    SQL Data Compare (aside from the migration script!) is the copy function. If
    you right-click in the comparison data grid, you'll see the option 'Copy'.
    That will put the grid on your clipboard in CSV format.

    Yours,

    Brian Donahue
    Red Gate Technical Support

    "Josh Venman" <joshv_nospam@ideasinternational.com> wrote in message
    news:0ldi6vMgDHA.1480@server53...
    > Brian,
    >
    > I'm running SQL Data Compare 3.01 Build 142. Maybe I'm missing something
    > obvious, but how do you access the option to export the compare results in
    > CSV format?. I can only see a means of printing the results..
    >
    > Thanks,
    > Josh
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:vF5NOb0CDHA.2188@server53...
    > > Hi Andrew,
    > >
    > > There is no HTML reporting in Data Compare at the moment, but it may
    > > appear in a future version. In the meantime, you can export Data Compare
    > > results in Comma Separated Value format.
    > >
    > > To program the SQL Data Compare COM objects, we sell a SQL Toolkit,
    > > which contains the instructions and examples for programming the Red
    Gate
    > > libraries. The details are on our website.
    > >
    > > If you're familiar with Visual Basic, it would be possible to export
    > the
    > > results in HTML format if you had the toolkit documentation. The results
    > > would be held in a collection that you could write to a file, inserting
    > HTML
    > > tags inbetween.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > >
    > > "Andrew Harrington" <andrew.harrington@wallst.com> wrote in message
    > > news:9elLhPrCDHA.1176@server53...
    > > > Does HTML reporting exist for Data Compare the way it does for SQL
    > > Compare?
    > > > If not, can something be created through the COM object?
    > > >
    > > > We'd like to create a daily or weekly report displaying what data
    might
    > be
    > > > out of synch (with the understanding that we don't want to dump the
    > entire
    > > > contents of the tables on a web page).
    > > >
    > > > Thanks
    > > > Andrew
    > > >
    > > >
    > >
    > >
    >
    >
    · Share on Twitter
This discussion has been closed.