Comparing two databases

[william humphrey]

Igor

Thanks for the suggestions. I think doing it with LiveCode text handling is
going to be a very flexible solution and you could just dump the data from
the databases after a certain "date" which is set based on the last time
they were synchronised.


On Mon, Apr 29, 2013 at 11:32 AM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> 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]
>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
http://www.bluewatermaritime.com