Re: [GENERAL] database/table snapshot

2009-01-31 Thread Jasen Betts
On 2009-01-30, Grzegorz Jaśkiewicz wrote: > Hey folks, > > I wonder, how would you guys approach table snapshots. > So the thing is, I have table X (I have few more tables, but lets > simplify that). That table is being replicated to X' on other server. > Now I need an ability to see changes, say

Re: [GENERAL] database/table snapshot

2009-01-30 Thread Asko Oja
Hello We have script called cube_dispatcher in SkyTools that we we use for similar sounding purpose. We must provide daily snapshots of changes to online tables for Business Intelligence team. So we create trigger on every table that needs to be handled that writes changed records into queue and t

[GENERAL] database/table snapshot

2009-01-30 Thread Grzegorz Jaśkiewicz
Hey folks, I wonder, how would you guys approach table snapshots. So the thing is, I have table X (I have few more tables, but lets simplify that). That table is being replicated to X' on other server. Now I need an ability to see changes, say every interval T. So, the simplest solution would be t