Post reply

Converting Meta Data Services Packages to Local

  • October 28, 2003 at 1:41 pm

    #151962

    I need to know how to convert MDS Packages to Local Packages so I can move them from one server to another. Is this possible or can I just move the MDS Packages by themselves without conversion? Please let me know what you think and any response is a good one. Thanks in advance

  • October 28, 2003 at 3:15 pm

    #479987

    Just open the package in design. Then using 'Save As...' from the Package menu, save it to 'SQL Server' instead of 'Meta Data Services'.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 29, 2003 at 9:24 am

    #480136

    Is there a database built into SQL Server that houses the meta data services packages?

  • October 29, 2003 at 3:06 pm

    #480192

    The Meta Data packages are still stored in MSDB, but they are held in a whole series of tables that are prefixed with RTbl. These are all the repository tables.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply