merging BE databases (specifically jobs, job history and catalogs)
I'm in a position were I have a caso'd 2012 and then a 3 stand alone 2010 BE servers. I need to migrate the info (jobs, job history, catalogs and logins) from each of the 3 2010 servers and incorporate them in the 2012 environment.
My initial thought is to update the three 2010 serves to the same level then copy database and catalogs from 2 onto the 3rd, import them somehow and upgrade to the 3rd to 2012 and then copy database and catalogs to the 2012 caso server and import.
The goat being to migrate the jobs and catalog but also keep job history for sox purposes. Is this possible?