Chapter 8. SQL Remote Design forAdaptive Ser verEnter prise
Creating publications
Inthis section Thissection describes how to create simple publications consisting of whole
tables,or of column-wise subsets of tables.
☞Simplepublications are also discussed in the chapter “A Tutorial for
AdaptiveServer Enterprise Users” on page 53.

Creating whole-table articles

Thesimplest type of article is one that includes all the rows and columns of
adatabase table.
❖To create an article that includes all the rowsand columns of a
table
1. Mark the table for replication. Youdo this by executing the
sp_add_remote_tableprocedure:
sp_add_remote_table table-name
2. Add the table to the publication. Youdo this by executing the
sp_add_articleprocedure:
sp_add_article publication-name, table-name
Example ♦Thefollowing commands add the table SalesRep to the SalesRepData
publication:
sp_add_remote_table ’SalesRep’
sp_add_article ’SalesRepData’, ’SalesRep’
go

Creating articles containing some of the columns in a table

Tocreate an article that includes only some of the columns from a table, you
needto list the columns that you wish to include, using sp_add_article_col.
Ifno columns are listed, the article includes all columns of the table.
❖Tocreate an article that includes some of the columns and all the
rowsof a table
1. Mark the table for replication. Youdo this by executing the
sp_add_remote_tableprocedure:
sp_add_remote_table table-name
go
143