Automic Workload Automation

  • Private Community

  • 1.  A few questions on Client Copy

    Posted Feb 05, 2018 09:37 AM
    Hello,

    These questions came up in a recent support inquiry :

    Question 1 :  What should I select in Destination DB ?  What is the meaning of all these numbers ?

    b26rns4r6ji8.pnghttps://us.v-cdn.net/5019921/uploads/editor/ai/b26rns4r6ji8.png" width="787">

    Answer : The client does not exist in the target system yet, so you can create it with any number that you choose. For this reason all possible numbers are listed.


    Question 2 : Can I change the name of a Client ?

    Answer : Once created a Clients number cannot be changed. A workaround would be to :

    a. Copy The client to another client with the desired number.
    b. Delete the original client, also with Client Copy, once it has been duplicated.


    Best regards,
    Antoine


  • 2.  A few questions on Client Copy

    Posted Feb 12, 2018 07:55 AM
    Antoine_Sauteron
    Is it possible to copy a client from system A on Database X to a different System B on Database Y.

    I'm using the unix version of the Utilities so the command I use today to copy a client within the same system is

    ./ucybdbcc -Iucybdbcc.ini -B -C -S0001 -T0050 -O;

    If it is possible to copy to different system, what would this command look like?


  • 3.  A few questions on Client Copy

    Posted Feb 12, 2018 08:00 AM
    Hi JohnO'Mullane

    Yes it's possible.

    It's not as much about the command than about entries in the .ini file.

    You need to set connection information to both source and target databases - respectively in [SOURCEDB] and [TARGETDB] sections. The -S and -T are taken from the ini.

    Best regards,
    Antoine


  • 4.  A few questions on Client Copy

    Posted Feb 12, 2018 08:26 AM
    Small add to Antoines post:

    Both AE Systems should (must?) be on the same Initialdata version:

    It is possible to copy clients from an MS-SQL Server to an Oracle or DB2 database. Ensure that both AE databases are of the same version.

    Unfortunately documentation does not clearify if this is valid for Servicepack- Minor- or Major version......


    https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/11.2/All%20Guides/help.htm#ucabeq.htm%3FTocPath%3DAdministratorhandbuch%7CDienstprogramme%7CAE%2520DB%2520Client%2520Copy%7C_____1

    cheers, Wolfgang


  • 5.  A few questions on Client Copy

    Posted Feb 12, 2018 08:41 AM
    Hi,

    Just to confirm Wolfgangs assumption. Both AE Systems must have the same Major/Minor Version and also Servicepack, at least on AE and Initialdata version. 

    If you cant ensure this, you can export the content of a target client using the unload utility and load it to the other system.

    Please Note, that the source system has to be more recent than the target system then.


  • 6.  Re: A few questions on Client Copy

    Posted Jul 05, 2018 11:50 AM

    Harald_Heidinger_152 wrote:

     you can export the content of a target client using the unload utility and load it to the other system.

     

    We need to copy many large clients (3000-25000 objects each) from one system to another. These systems are located in different data centers, so we found during our first copy using the clientcopy utility that it was going to take 4+ hours (actually didn't complete before we had to terminate our session for the day).

     

    We are interested in copying a client's contents to a file, moving the file across the network, then reimporting. I think this is what Harald is basically suggesting with his quoted thought above. Will that retain folder organizations and everything else that you would get with a copy client using the utility, like all object linking/references? We are not copying statistics/reports. We just want the objects and folder structure.

     

    Thx,

    Eric



  • 7.  Re: A few questions on Client Copy

    Posted Jul 05, 2018 07:44 PM

    Hey Eric, 

     

    From what harald_heidinger mention it sound like using a transport case (via the unload utility)..the folder structure will be kept though it will also take some time depending on the amount of object...

     

    We have this white paper which list the advantage/disadvantage of each of options for moving objects.. Technical Whitepaper - Copying Objects between Separate UC4 Systems or Clients  - The sections "Transport Cases" list advantage/disadvantage and "how to - using transport case to Copy objects"...  subsection "Unload All Objects of a client"  list step on how to perform the task

     

    Notes that this is an old pdf and does not include the new method of import/export with references that was introduced in the higher versions.

     

    Hope this help.



  • 8.  Re: A few questions on Client Copy

    Posted Jul 06, 2018 12:24 PM

    Thanks for that response, Luu. The white paper does help explain the options very well.



  • 9.  A few questions on Client Copy

    Posted Feb 12, 2018 08:58 AM
    THX for confirmation Harald_Heidinger_152 !

    cheers, Wolfgang


  • 10.  A few questions on Client Copy

    Posted Feb 12, 2018 09:02 AM
    Thanks Antoine_Sauteron FrankMuffke Harald_Heidinger_152