I also never separate databases from the code and other files necessary to run the application. As Javier mentions, if you need to move an app to another physical machine, you copy the entire directory to another directory on the other machine. If you had stuff split, then you have to remember to mimic the same structure on the new machine. Like Javier, if I have directories to store PDF files and other backup material, I put it in a directory under the primary one.
Karen -----Original Message----- From: Javier Valencia <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Jul 15, 2013 9:42 am Subject: [RBASE-L] - RE: File Management Question Bruce, In my development computers I use approach 1 as follows Main directory C:\databases Individual databases: C:\databases\RAMS In this folder I store: Database files (*.RX1-*.RX4) Startup file for compiler (*.rcp) Any code used to test the database (*.rmd) Any external programs used with the database (*.exe) Any graphic files used with the database (*.jpg, *.png, *.ico) Any applicable data files (input, output) C:\databases\RAMS\Backup Stores backup data C:\databases\RAMS\Equip_photos Stores equipment photos JPGs C:\databasess\RAMS\FWODocs C:\databasess\RAMS\FWODocs\2012 Stores Fleet Work Order Scanned documents generated by RAMS for 2012 C:\databasess\RAMS\FWODocs\2013 Stores Fleet work Order Scanned documents generated by RAMS for 2012C:databases\WAMS C:\databasess\RAMS\FInvoices C:\databasess\RAMS\ FInvoices \2012 Stores Fleet Invoices generated by RAMS for 2012 C:\databasess\RAMS\FWODocs\2013 Stores Fleet Invoices generated by RAMS for 2013 ...and so on... C:\databases\WAMS ... C:\databases\RCM ... You can see that each database is stored in its own directory and all information related to or generated by the individual database is stored in subdirectories. If you want to move the database to a different computer, I juts copy the appropriate master directory and all the needed files are included. I hope this is what you were looking for. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Friday, July 12, 2013 9:17 AM To: RBASE-L Mailing List Subject: [RBASE-L] - File Management Question All: Fishing for perspective for this single-user development environment. With complexity, automation and backup issues in mind, assuming a dedicated data partition and unlimited space, which of these two file management structures might make the best long-term sense? 1. Each individual database ( R:Atabase.RX* ) and all related code files stored within its own dedicated folder path, or; 2. All database files ( *.RX* ) stored within one folder, with separate dedicated folder paths for related code files. Or am I missing an option? (I understand that the individual .RX? files can be distributed among folders, but I'm not there yet.) Thanks for your thoughts, Bruce Chitiea SafeSectors, Inc. eCondoMetrics 909.238.9012 Cell
