Does anyone have experience with the following?
Our Test and Prod environments should be identical after code is promoted from Test to Prod (via Change Management). Has anyone tried verifying that the multiple IBI databases match? I tried to determine which table(s) contain WF code but I'm wondering if they might be stored as CLOBs or BLOBs because I couldn't find any code. Any thoughts would be appreciated. Thanks.

This message has been edited. Last edited by: Bob Shulkind,

IBI recommended uses dbVisualizer to compare tables but this is a manual process. I would open 1 table, open a 2nd table, and then compare the 2. I was looking for an automated process where I could list all tables to compare and schedule the process. However, now I'm wondering if the keys in the tables will be the same between databases. Does anyone know which tables contain WebFOCUS code?

The best method to compare code from two environments might be to use Change Management Export to export everything in the Repository and then use a file comparison utility to compare the extracted files.

There is a setting in the Admin Console to export files in "raw" format, making them readable. I have not found documentation on calling Change Management in batch, though it can be done.

Thanks Francis. I will look into the 'raw' format.

Hi Francis - this is great! That greatly helps if we need to restore a file from backup. Using that option we can select an individual program, copy the code, and paste into the program that lost code.
Thank you very much!!
Bob

Yes, it's a great way to backup code. I'd like to find the documentation on running this in batch mode so that I can use Windows Task Scheduler to set up a batch process to export the whole Repository to a cm export folder, then copy that folder to a backup drive.

We were warned that this "raw" capability may not be available in a future release...

Close but not quite. I may be able to compare databases this way but the contents of a .fex is not in text format so I wouldn't be able to restore lost code from it unless I'm missing something. I got my hopes up.

Do you think you can use it to restore code for individual programs since it doesn't seem to be text-based?

The fex is in text format. If you turned that "Raw" setting on in the Admin Console, after exporting there should be two sub-folders in the export folder: "root" and "root_content". Look in "root_content".

I'm seeing the root directory under export but there isn't a root_content directory. I thought root_content may be a hidden directory but I changed the settings to show hidden files and it still wasn't there. Any ideas?

Yes! It works. I needed to clear cache on the Admin console. Thanks greatly for your help Francis!!

I was just about to ask you about the cache clearing! Good news.

How do I flag this as resolved? Believe it or not, I haven't had a posting resolved before. You are the first!!! Thanks.

Bob, edit your original post (using that middle icon and change the text in the subject - prepend with [SOLVED]

Thanks again!

quote:

...I'd like to find the documentation on running this in batch mode so that I can use Windows Task Scheduler to set up a batch process to export the whole Repository to a cm export folder, then copy that folder to a backup drive...

I have a goal to periodically backup several our Repository Content Folders.

In the 'WebFOCUS Security and Administration' manual (8105M) I see information regarding running a Change Management Export Scenario using the command line interface.

If I understand the manual correctly I create a scenario with the online WF Portal GUI, and then can call it via a .bat job.

I would then, schedule the .bat job.

As I start to delve into this, thought I'd see if anyone else has gone down this path.

[This was the only FocalPoint thread I could find on this topic, so I thought I would append (or DISP=MOD).]

This message has been edited. Last edited by: David Briars,