How to Copy Tables, joins,Classes from one universe to other

I have two universe old.unv and new.unv

new.unv has all objects in old.unv +

1)additional tables that are imported… ,
2)joins between these tables are done
3)new classes created

Now I want to copy these 3 points above to the Old.unv and Move the old.unv to production.

I dont want to move new.unv to production because… there are reports that are created using old.unv and if my move new universe to production the reports may stop working…

Hence I want to copy the new things in new.unv to old.unv
Please suggest how to do this ?


rajesh_tns (BOB member since 2008-06-18)

Just drag the objects, tables etc… over to the new universe.


zack :us: (BOB member since 2007-08-02)

Should be as simple as opening both copies, and doing a copy / paste between them. Joins to “old” tables may need to be create manually, and you’ll need to create contexts as appropriate, but the “heavy lifting” should be just that simple.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Thanks all… I did not know its as simple as this… I shall try that

thankuu


rajesh_tns (BOB member since 2008-06-18)

I Have 3 universes and some classes are same for all the universes. All universes using the same database connection.
My question is, can I copy the classes/objects from one universe to another universe?
Thanks.


pvsrls (BOB member since 2008-06-16)

Yes – why don’t you try? :wink:


Anita Craig :us: (BOB member since 2002-06-17)

I did that and there are no issues. But in the object properties “List Name” value is the same, is that a problem(unique id for each object) or not ?
Thanks alot.


pvsrls (BOB member since 2008-06-16)

I’m sorry, I don’t understand your current question.


Anita Craig :us: (BOB member since 2002-06-17)

Copying stuff from one universe to another is no problem. It is a bit different if report depend on a universe and on copied classes and objects. Classes and objects may not have the same id’s when copied!

HenkK


HenkK :netherlands: (BOB member since 2004-03-02)

My question is for any object, in the properties window, there is a properties tab, in that tab there is the option “List Name”, if that is same for the copied objects or different from the copied objects.
Is it matters in any way???
According to Henkk, it does not matter.
Thanks.


pvsrls (BOB member since 2008-06-16)

Hi,

Continuing on this topic, I want to copy a whole schema, (i.e. joins and tables) from a new universe to an old universe. I deleted the schema from the old universe then pasted in the new one. It all looks okay and the objects have picked up the correct table names but when I try to save it, I get an error message stating:

Does anybody have an idea as to why? I haven’t recreated the contexts at this stage and not all the original tables have been replaced so some objects have ‘!Unknown’ as their referenced table but I wouldn’t have thought that either of these would cause a problem.

Thanks,

Steve


steveayres :uk: (BOB member since 2006-11-23)

Hi Steve,

I don’t think the contexts would cause a problem.

When I’m doing this, however, I always bring in all the tables first so I don’t have any objects with Unknown! in the Select. I’m lazy, I don’t like re-pointing objects… 8) .

It will be intersting to know if when you delete these classes and Objects with Unknown! whether you were able to Save then…


Mak 1 :uk: (BOB member since 2005-01-06)

Mak, thanks for your response.

Having been messing around with this for a while, my problem is now slightly more fundamental. When I save my universe as another name and then delete all my contexts I get the error when I then try to save again. I then can’t do anything with universe as the file is corrupted.

I have now decided to manually rebuild my schema rather than try to copy over an existing one but I’m now concerned that once I have gone through all that effort, the minute I delete my contexts to replace them, I’m going to end up with a corrupt unv file again.

Has anybody else encountered this or does anybody have any ideas?

Thanks, Steve


steveayres :uk: (BOB member since 2006-11-23)

What happens if you delete them one at a time and then save?

What SP are you on…?

I haven’t had any of these problems using SP2…


Mak 1 :uk: (BOB member since 2005-01-06)

XIr2 SP2. The thing is, I copied this universe in the first place in order to rebuild the schema, etc. so I have already deleted all the contexts once before.

I think I have a solution though - let me know if you see a flaw in my plan:

I took a shockingly built 6.5 universe migrated it to XIr2, copied it and rebuilt the schema. I then re-organised all the classes and objects. This was a mistake though because I have a load of reports that also need migrating and because I have now re-organised the classes, I can’t just point the reports to the new universe and be done with it because Business Objects expects the class structure to be the same.

So that is why I wanted to copy the schema but if I can’t do that, I can instead just create another version of my new universe, (let’s call it universe 3), copy the old class structure to my new universe. Save my new universe as my old universe and export. Migrate the 6.5 reports. Then copy the new class structure that is still in universe 3 into the new universe. Because the object IDs are the same and I am not repointing the reports, this should work shouldn’t it?

Even as I’m writing this I can see that there might be a simpler solution but my brain is so addled after a couple of days of this that I can’t see the wood for the trees! :crazy_face:

Thanks for your help, Steve


steveayres :uk: (BOB member since 2006-11-23)

Hi Steve,

This post may help you…

https://bobj-board.org/t/106492

Sounds horrific, good luck!


Mak 1 :uk: (BOB member since 2005-01-06)