Hi
Im going to be dumping and reloading databases this weekend. Dreading it a bit as it will be my first time. We have a script in place which has been written by the previous programmer. I have posted this script below does this look correct?
I have a few questions:
1. how do you rename databases? is it the proutil utility?
2. we basically need to copy the database to the live environment once re-indexed do i use the procopy command? whats the syntax for this?
Dump DF (df file)
proutil /test/data/live-data/pecas –C idxbuild all –T /test/data –TB 5
cheers
Im going to be dumping and reloading databases this weekend. Dreading it a bit as it will be my first time. We have a script in place which has been written by the previous programmer. I have posted this script below does this look correct?
I have a few questions:
1. how do you rename databases? is it the proutil utility?
2. we basically need to copy the database to the live environment once re-indexed do i use the procopy command? whats the syntax for this?
- Ensure the backup worked.
- Stop all the services using rslmenu and start PECAS in single user mode (edpecas – this is the editor in single user-mode)
- Dump all data definitions and sequences. Dumping of both is important!
Dump DF (df file)
- Go into Lseditor and go to data dictionary
- In there go into Admin à Dump Data Defintions.
- Once completed then do sequences Admin à Create Bulk Loader Description File
- Delete the test database’s to create enough working room.
- This is done in Shell mode.
- Rm –I test* (this deletes test database)
- Create a new database in the test area. (Data dictionary à Database à Create.. à Empty à call the database Pecas)
- Load the data without any data integrity (-i)
(proutil /test/data/live-data/pecas –C BULKLOAD pecas.fd –i –T /test/data).
proutil /test/data/live-data/pecas –C idxbuild all –T /test/data –TB 5
- Rename the old database in the live environment using Proutil
- Copy the database to the live environment. Use Procopy (check backup script which uses procopy)
- Start Pecas in single user mode and run compall.p (this compiles all the code EXCEPT code in special/ls/ USE EDPECAS)
- Use the application compiler to compile all programs in pecas/special/ls/ (application compiler is in Tools à App Compile selector à then enter/select special/ls)
- Use PC to compile all the programs on the edi machine, packing machine, superman, FirstB2B software only compiles under V8 for some reason. Map network drive to compile on other machines)
cheers