Topic
4 replies Latest Post - ‏2012-12-05T20:16:19Z by loicjulien
atimpo
atimpo
15 Posts
ACCEPTED ANSWER

Pinned topic using Migrate -> Compare & Migrate Objects with large catalogs

‏2012-11-19T15:48:18Z |
When I use Migrate -> Compare & Migrate Objects with two databases that have very lareg catalogs (5000 - 6000 tables each), this wizard never comes back within a reasonable amount of time. I've let it run overnight, and it's still not returned anything. Any tips on how to speed up the migration? I choose a schema for a source object to compare.
Updated on 2012-12-05T20:16:19Z at 2012-12-05T20:16:19Z by loicjulien
  • atimpo
    atimpo
    15 Posts
    ACCEPTED ANSWER

    Re: using Migrate -> Compare & Migrate Objects with large catalogs

    ‏2012-11-26T20:03:40Z  in response to atimpo
    Forgot to mention, Data Studio 3.1.0 on Windows XP.
    • YuanFeng
      YuanFeng
      61 Posts
      ACCEPTED ANSWER

      Re: using Migrate -> Compare & Migrate Objects with large catalogs

      ‏2012-12-03T07:38:00Z  in response to atimpo
      Hi,
      I am not sre if you can share the ddl script to us, we can have a basic test on the new version
  • loicjulien
    loicjulien
    96 Posts
    ACCEPTED ANSWER

    Re: using Migrate -> Compare & Migrate Objects with large catalogs

    ‏2012-12-05T20:14:25Z  in response to atimpo
    Hi,

    Since Data Studio will need to load most of both catalogs in memory before it can start the comparison, I wonder if you need to do a full comparison or if you could set a Catalog filter in order to work with a smaller set.

    We had written an article on how to enable such a filter last year. Adding it here, as a reference, as this may further help you: http://www.ibm.com/developerworks/data/library/techarticle/dm-1109datastudiodbcatalog/index.html

    This is slightly different than setting filters in the Compare/Migrate dialog, since the comparison may still involve objects that could lay outside of the objects selected within the wizard (cross schema RI, ...)

    Setting a Database Catalog Filter allows Data Studio to never load portion of the catalog to start with.

    Let me know if you would like to further talk about this, so that we can help you with your use-case.

    You can reach me at [http:// lj -- AT -- us.ibm.com ]

    ~Loic
    • loicjulien
      loicjulien
      96 Posts
      ACCEPTED ANSWER

      Re: using Migrate -> Compare & Migrate Objects with large catalogs

      ‏2012-12-05T20:16:19Z  in response to loicjulien
      BTW, you can remove the http:// to reach me :) This is an automatic string conversion that was done by the Forum.