Migrate Content Job

2»

Comments

  • DavidHaveman
    DavidHaveman Member
    edited November 13, 2012 #32

    I've seen that, but my question is what happens if you don't?  Is the Admin Method smart enough to skip those documents, or filter them out from the query if you don't have a filter on a_storage_type? I'm guessing no...

  • YingXing
    YingXing Member
    edited November 13, 2012 #33

    I am not sure if it actually did the move, but it certainly took the time - I missed the parameter initially, and found out that it was the same time to move the 1000 objects from the same storage as to a different storage. Some experts might have the right answer.

  • Panvivek
    Panvivek
    edited November 10, 2017 #34

    Hi,

    For me , the query looks like :

    EXECUTE migrate_content WITH target_store='filestore_02',query='r_object_id in(select r_object_id from dm_sysobject(all) where a_storage_type='thumbnail_store_01')',sysobject_query=TRUE,log_file='C:\MigrateContent.txt',renditions='all',remove_original=TRUE,update_only=TRUE,command_file_name='C:\M

    igrateContentCMD.txt';

    But this fails saying parser error in the vicinity of EXECUTE migrate_content WITH target_store='filestore_02',query='r_object_id in(select r_object_id from dm_sysobject(all) where a_storage_type='thumbnail_store_01"

    and if i pass thumbnail_store_01 in double quotes , it throws error of invalid attribute name ('thumbnail_store_01'). The DA dql allows only single quotes

    Any help much appreciated

  • Mohamed.Sayed
    Mohamed.Sayed Member
    #35

    it should working with you:

    EXECUTE migrate_content WITH target_store='filestore_02',query='r_object_id in(select r_object_id from dm_sysobject(all) where a_storage_type=''thumbnail_store_01'')',sysobject_query=TRUE,log_file='C:\MigrateContent.txt',renditions='all',remove_original=TRUE,update_only=TRUE,command_file_name='C:\MigrateContentCMD.txt';

Categories