Oracle SQL Developer Data Modeler 3.0 production – migrating Domains from EA (Mac OS X)

Posted on február 1, 2011. Filed under: Uncategorized | Značky:, |

Migration to 3.0 production was was not as easy as I thought it would be. My Domains carefully set for all columns got screwed and all VARCHAR2 column sizes were lost.

After some investigation I found out, that EA saves all Domains to default domains file which is buried in

OracleDataModeler.app/Contents/Resources/datamodeler/datamodeler/types/defaultdomains.xml

and not in your home, so it doesn’t get copied to new version settings when running 3.0 production for the 1st time.

So before you open your model in 3.0 production you have to import this defaultdomains.xml by File > Import > Domains. Don’t forget to check Import in Default Domains check-box.

Happy modeling 😉

Reklamy
Read Full Post | Make a Comment ( None so far )

Liked it here?
Why not try sites on the blogroll...