Hello everyone, I was wondering if anyone has written some sort of UPDATE system for their Rbase projects.
We have several databases in use, live. One for each of our companies we own. They all share some common code, stored procedures, forms, reports, etc. And they have some unique programming, forms, reports as well. For the common code, we always have to update them individually. Its very time consuming and leaves lots of room for error, even when careful and using checklists. After speaking with John (Rbase) and Frankie (Developer of our ERP system and Co-Owner of our company), got me thinking to develop the following: ----- Have ONE Database of which we have all the common code, reports, forms, stored procedures. That ONE Database is only for DEVELOPMENT and TESTING purposes. I will have a UPDATE SYSTEM Table in which I will certain internal system data including when an update and its version is ready to distribute, and for which companies. We currently have a SCHEDULER system which has Schedule Tasks to do many Database Maintenace, imports, health checks, Database Reloads, etc. We will add a Daily CHECK FOR UPDATES Task to run nightly. This will lock the Database during the update process. Then, LOAD any new RMDs, Stored Procedures, Forms, Reports, Views and Labels, which are designated to update AND to the proper Database. Finally, to Unlock the Database for production use. I will have a Message sent via Email (SMS, WhatsApp) out to the Users, Alerting them of when the update will happen and that their access will not be available during those times. I will have a Message sent via Email (SMS, WhatsApp) out to the Users, as a New Version Update and its new features, and that the update was completed successfully. ----- My question to everyone is, has anyone done anything like this? Any other ideas, features, likes, dislikes? This group is EXCELLENT and would love to learn and improve with any suggestions, DONTs and DOs, etc. Thank you, Robert Diaz -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/SA1PR19MB51829C1711453E72CD616052A8D12%40SA1PR19MB5182.namprd19.prod.outlook.com.
