made it to this... i was running this with mysql dialect to complete the build.
1. added mysql dependencies to pom.xml 2. created a new mysql database to serve as a place holder 3. configured rdbm.properties with mysql database details 4. ran two targets that eric recommended below resulted in ddl stmts for these tables: UP_USER UP_USER_LOCALE UP_PERMISSION UP_USER_LAYOUT UP_LAYOUT_STRUCT UP_LAYOUT_PARAM UP_SEQUENCE UP_USER_PROFILE UP_GROUP UP_ENTITY_TYPE UP_GROUP_MEMBERSHIP UP_ENTITY_CACHE_INVALIDATION UP_ENTITY_LOCK UP_ENTITY_PROP UP_EVENT_AGGR_STATUS UP_EVENT_AGGR_STATUS_SEQ either things have been dramatically simplified since 3.1.1, or this process isn't producing all the require table ddl. does this list look complete? if so, i can work with laura to document the bare minimum requirements for executing these tasks. thanks, tim On Jan 12, 2012, at 9:01 AM, Carroll, Tim wrote: > thanks drew/eric. i'll try this out later today. looks like i'll need to > upgrade my version of ant first. > > > On Jan 10, 2012, at 11:23 PM, Eric Dalquist wrote: > >> If you just want the schema with no data I believe the following will do it: >> >> ant db -Dscriptfile=up4_legacy.ddl >> ant db-hibernate -Dexport=false -DoutputFile=up4_hibernate.ddl >> >> Note that since uPortal 4 uses dialect autodection you will still have to >> have uPortal configured with database settings and the appropriate JDBC >> driver for your database. Also please test this against a DB that doesn't >> contain data you care about, this should all work but I haven't just >> generated the DDL files directly in a long while. >> >> -Eric >> >> On 1/10/12 5:00 PM, Carroll, Tim wrote: >>> Hi All. I'm interested in generating the uPortal 4 database schema for >>> review without installing the product. Is there an easy way to do this? >>> Thanks, Tim >>> >>> >> > > > -- > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-dev > -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
