My users want to be able to practice procedures on a test SQL database. How would I set one up for AeriesCS?
The usage of a test SQL database is recommended by Eagle Software and pretty common with AeriesCS users. The setup of a test database is a little different than with the traditional MS Access Aeries. The process involves backing up the live database with Enterprise Manager and then restoring the backed up data to a new database with a different suffix name. The most common suffix used is to give the same suffix as the live database with the addition of the word Test at the end (example DST05000DistrictNameTest). When a user wishes to use the test database, on the login screen, the new suffix of DistrictNameTest would be inserted in lieu of the live DistrictName suffix. This gives the user a test area to work in. You can further enhance this feature and also help users to avoid confusion between databases by changing the district and school names in the LOC table of the test database to something that would prompt the user to visually realize that he/she is not working in the live datab
Related Questions
- Would users be able to share the same database files simultaneously among them (say, more than 2/3 simultaneous users)?
- My users want to be able to practice procedures on a test SQL database. How would I set one up for AeriesCS?
- Can SQL Relay proxy multiple database users instead of using the same user for every session?
