Would that really matter in the case of the BO Repository? If I recollect, the largest fields are really just Varchar2(255), since the Universes and Documents are divided into chunks of 255 characters.
I would think that more of the issues will come with migrating the indexes from database to database. You “should” be able to spool the files out to a flat file to load directly with a control file. It won’t rebuild the indexes, but it might be just as good for a test… you can always rebuild indexes later.
Actually, documents are not stored this way. Older databases that didn’t support a BLOB object did what you were suggesting. This is from the script that is used to create an Oracle repository.
create table OBJ_X_DOCUMENTS(X_DOC_N_ID NUMBER(10) not null, X_DOC_N_BLOCKID NUMBER(10) not null, X_DOC_B_CONTENT LONG RAW not null)
So, moving repositories is easy for everything but documents. For some databases (Oracle to SQL Server) it seems to be pretty straightforward. For Sybase to anything, I think the security and universe domains will be fine. The document domains likely won’t work.
Since Eddy and Lee have hidden their email addresses, I can’t send the presentation that I have on this topic. If either or both want it, let me know.
So, if I am on SQL Server and I want to migrate my documents to new instance of SQL Server, I can create a blank repository on the new server, create a new BOMain key on the new server, copy the contents of the old repository tables to the new repository tables. Will this copy the actual documents to the new server?
Also, is there a way to “bulk” export documents to a repository instead of exporting them one at a time?
If you’re going from SQL Server to SQL Server, why not just move the existing database to the new server? Wouldn’t that be much simpler? Don’t forget, after creating your new BOMian.key, you also have to change the connections to the Document and Universe domains in Supervisor.
If you are developing on Server A and testing on Server B , each with their own full instance of Business Objects and SQL Server, and you copy the database from Server A to the database on Server B, where do the .rep files actually reside? Or are they actually contained within the repository database?
The database contains pointers to the .rep documents. I’m not sure in which directory the .rep files reside, but I’m sure they can be moved as a batch.
Strangely enough, when I search for any report files on the BO server which I have exported to the repository, none are found. Where are the pointers pointing? Are the files converted to a different format?
Well, I was wrong. The documents are actually stored in the OBJ_X_DOCUMENTS table in the repository. So moving or copying the database will capture the documents, as well as everything else.
We are planning to migrate from DB2 to SQL server. do you have any documents or presentation? if you have one can you mail me at ctgy9000@yahoo.com. thanks
Attempting to migrate repository from SQL Server to SQL Server. When I recreate the ODBC Connection on the new server I can’t login using the old key I get and error. (Cannot retrieve the time reference for the security domain USR0014) The *.key has a reference to the IP in the ODBC.
When I attempt a safe recovery my ODBC connection tests fine but I get and error (No security domain exists for this connection. ADW0010).
All 50 repository tables made it to the new db. I checked OBJ_M_ACTORS and it has data. I noticed in the OBJ_M_CONNECTION table the M_CNTN_M_TYPE has a value of 1 for the cconections to the repository vs. 2 for secured connections.