in

The ORM Foundation

Get the facts!

How to import relationships between multiple schemas with NORMA?

Last post 08-07-2012 1:50 by Matthew Curland. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-27-2012 18:25

    How to import relationships between multiple schemas with NORMA?

    I am using Norma for Visual Studio 2010 - Published 6 May 2012.  In looking at the included readme file (which is "NORMA April 2012 CTP Readme"), it states that "Importing multiple schemas in a single step is not currently supported."

     I need to import from a database that has mulitple schemas, with some tables having cross-schema relationships.  Is there any way for me to get those relationships in with multiple steps?

    (Using Sql Server 2008 R2)

  • 08-07-2012 1:50 In reply to

    Re: How to import relationships between multiple schemas with NORMA?

    As you noted, there is currently no support for importing multiple schemas. This actually goes deeper than the importer in that NORMA does not have support for namespaces, which would allow name conflicts within a single model. This is also needed for other scenarios, such as multi-model merge and just different uses of the same name in the same model.

    The best approach I can give you right now is to import each of the schemas separately then use cross-model drag-drop to pull all of the elements into one model. If there are any name overlaps they would need to be adjusted before import. The cross-schema references will likely be pulled in as one or more values instead of entities, so would need to be adjusted to put the full model together.

    There is a discussion at http://www.ormfoundation.org/forums/p/573/1706.aspx#1706 (and preceding threads) on one approach to getting multiple schemas regenerated from the same model. You'll need to tweak the registration files for VS2010 and (possibly) an 64-bit system, but this approach will work fine in VS2010. Let me know if you have problems getting the extensions installed.

    -Matt

    P.S. Sorry for the delayed response. I've been managing, enabling and working with a crew at my place in the back field and haven't been online much. NORMA is feeling neglected, but I'll be able to make it up to her soon.

Page 1 of 1 (2 items)
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service