Comparing two databases

[Ruslan Zasukhin]

On 4/29/13 6:06 PM, "Lynn Fredricks" <lfredricks at proactive-intl.com> wrote:

> Hi SKIP,
> 
>> Is that something that can be scripted?   I need to create an
>> automated
>> report of differences and emailed out to the appropriate
>> parties.  I briefly looked at the SQL DIFF function that you
>> described but it looks like it is all manually run from Studio Pro.
> 
> It should be possible to do it by script with LiveCode, but I would imagine
> it would take a significant amount of coding. LiveCode has about the best
> text handling you are going to find in a development tool.
> 
> Yes, in Studio Pro you have to run it. We don't have scripting supported
> yet.

Let me add ...

1) Valentina DB already have on engine level interesting SQL command
              MAIL ... TO ...

2) We going add into Valentina Studio Sceduler,
To be able automate different tasks ...

We have right now scheduler in Valentina Server ... But it do not have SQL
DIFF ..


So ... I think with scheduler, in near future it should be possible do DIFF,
and send result by email ...

4) Also Valentina Studio Pro have reports, which can allow produce even nice
HTML/PDF reports to be sent also ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]