Get tables for a new publication (gettablesfornewpub) v7

Suggest edits

The gettablesfornewpub command lists the tables and views available for including in a new publication from a given publication database definition.

Synopsis

-gettablesfornewpub –repsvrfile repsvrfile –pubdbid dbid

Parameters

pubsvrfile

The file containing the publication server login information.

dbid

The publication database ID of the publication database definition whose available tables and views to list.

Examples

For the publication database definition identified by publication database ID 1, the tables available for inclusion in a publication are EDB.DEPT, EDB.EMP, and EDB.JOBHIST. The view available for inclusion in a publication is EDB.SALESEMP.

$ java -jar edb-repcli.jar -gettablesfornewpub \
>   -repsvrfile ~/pubsvrfile.prop -pubdbid 1
Fetching tables/views list ...
[[EDB.DEPT, TABLE], [EDB.EMP, TABLE], [EDB.JOBHIST, TABLE], [EDB.SALESEMP, VIEW]]
← Prev

Removing a publication database (removepubdb)

Next →

Creating a publication (createpub)