Publications
Page 3 of 7

What a Publication Contains

The following dictionary items can be explicitly published:

  • tables (other than system tables)
  • indexes
  • views
  • method aliases
  • work unit aliases (see Work Units)
  • class aliases
  • stored prepared statements
  • foreign keys
  • triggers
  • user-defined aggregates
  • jar files (typically containing application code or Java classes and resources)

The following database items are implicitly published:

  • primary keys
  • unique and check constraints (if all columns in the constraint are published)

You can also add target database properties to a publication. Target database properties are conceptually a bit different from the items previously mentioned, because published target database properties do not have to be set in the source database, and you can set them to values at the target that are different from the source values. (You can do this because in many cases you want your target environments to be different from the server's environment. For example, you may want to set a target's database classpath to one value and the source's database classpath to a different value.)