We have discoverer desktop/administration 4.1
We have two databases. One for real time, and one that is a copy of that for use by the business that gets cloned in the morning. This copy database is where users are able to create there own reports. Everyday, backup is taken of this copy database and then the database is cloned from the real time database in the morning. Then a job is run to put back the priviledges of users to create their reports and also to copy back the workbooks they have created. We are now getting rid of this extra copy database. Is there a way to copy all the user created workbooks which is in the thousands. Also is there a way to copy folders that are only missing from the target database?
Thanks in advance.
Trying to merge EUL folders can be time consuming and you are not guaranteed to get the same identifiers in both areas. It doesn't sound like you currently use the EUL in the Target database so I would either replace it with what is in the Copy or add a new EUL and import everything from the Copy.
If everything you need is in the Copy and you go down the new EUL route then here is what I would do:
1. Export entire EUL from Copy - this will copy all folders and workbooks
2. Create a brand new empty EUL in the target database
3. Import the EUL into the new empty EUL
4. Ask users to work in this new EUL
5. When satisfied all is well, drop the original EUL
Does this help?