Automic Workload Automation

I have v10 on one of our dev systems and I installed v11.2 on another dev system. My question is: how can I copy the data (objects) from the v10 database to the v11.2 database?
Thanks

I used TransportCase.   You select the objects you want to copy by adding them to the TransportCase folder.  Then you run the (V10)DBUnload utility to write them to a file.  Then you run the (V11)DBLoad utility to import the file.

Lessons I learned included;

I did this as two phases; (1) copy all USER and USER_GROUP objects first, then (2) copy everything else.  Doing so avoids potential security issues at object load time.

DBLoad is smart enough to merge variables.  For instance UC_CLIENT_SETTINGS will receive your V10 settings, and it will also retain its new V11 rows.

I was especially careful with client 0000 so I wouldn't risk breaking the AE.  I manually applied our settings so that at the same time I could see what the new settings were.

As Pete would suggest, the Transport Case would be the best option (for moving lots of object between different AE version).

Normally there 3 options:
Import/export - folder structure is not kept / Cannot use for large amount of object
Transport case - (Not that the password of all user will be reset it default)
Client Copy - The AE need to be on the same version as stated in the documentation

So of the three normal options transport case would be the best.  There is a white paper on this that mention the pro and con of each here and some instruction on how to use it.

Thanks for the advise :) TransportCase is working fine for copying the objects. But this will not help copying the objects in the activity window (EVNT and JSCH objects). So how can I do that?

Also I was considering:
1- Create the database to be used with V11.2
2- Load the v10 data in it
3- Then update the database to v11.

are my consideration reliable or they are not?

Thanks All
 

All data copied to the new system. But nothing in the Activities window. Is there anyway (other than manually) to execute all needed Evnt and Jsch jobs in one batch?

With any of the import/export, transport or client copy.  Will only copy the "object" and put that in the new system (so that its available to be executed/run).

If you want it so that all the jobs are still within the activities windows like your current v10 version); then you will need to do a copy of the AE v10 database.

You will need to create a new environment for it and load the copied database into it, then upgrade that copied system to V11.

Luu_Le_185 Thanks :smile: