Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Detect Database Changes .... |
Mon, Apr 11 2016 8:14 AM | Permanent Link |
gripsware gripsware datentechnik gmbh | Hi there ...
we are trying to improve our Backup-Routine .. by comparing tha Backup-FileDate with the Database-FileDates (edbtbl,edbidx,edbblb) we are trying to detect changed databases .. a few problems/questions are coming up ... - Is it possible to Flush all changes to Disk (EDBServer) - Is there a kind of last-modify-date for an entire database or the tables? - Using a Trigger is no real option ... (Too slow (many tables with many more records))) - Selecting over all Tables is also not possible ... (The Tables are really big ... and not all are having modifydate-columns ) (We already splitted our Database into several smaller Databases to gain a better performance ...) However ... if we could simply force a flush .. we could do a findfirst/findnext (which we are already doing) and see what table has been changed ... |
Tue, Apr 12 2016 3:35 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Volker
Have you thought of setting up a mirrored system and using the built in publishing system to keep it up to date? Setting it up to start with would be a bit of a problem but once its up and running it should be fine, and as an added benefit you can even backup the mirrored system. Roy Lambert |
Tue, Apr 12 2016 7:21 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Volker,
Roy is correct - you should definitely use the replication for "hot backup" processing. It is ideally suited for this purpose. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |