Re: local copy of remote database -- how to solve this case?




On 30.05.2007 23:52 T-BAG wrote:
hello!

is it possible to create "simplified" local copy of the remote database in an automatic/semi-automatic way? I don't need triggers, user roles etc., just tables and indexes placed at two local tablespaces.

Why not use materialized views (using a DBlink as someone else has suggested) that way you can automate the process of synchronizing the local copy.

Thomas
.



Relevant Pages

  • Click next until the End of File
    ... I'm trying to automate a process. ... I want my sub form to automatically ... click next until the end of file then triggers the main form to move ... familiar with recordset and EOF. ...
    (microsoft.public.access.formscoding)
  • Triggers, recursion & status
    ... Is there any way to use triggers (or to automate this behavior in another ... way) to set a status character field to I, U or D depending to the action ...
    (microsoft.public.fox.programmer.exchange)