Creating and modifying publications
You create publications using SQL Central or the SQL CREATE
PUBLICATION statement. In SQL Central, all publications and articles
appear in the Publications folder. This section describes how to create
publications in SQL Central. For information about creating and
modifying publications using SQL, see the online MobiLink – Client
Administration book.
Connecting to the
database in SQL Central
You use the SQL Anywhere plug-in in SQL Central, not the MobiLink
Synchronization plug-in, to work with MobiLink clients and remote
databases. For information on starting SQL Central from the PowerBuilder
design time environment, see the Users Guide.
You must have DBA authority to create or modify publications,
MobiLink users, and subscriptions.
To connect to the database in SQL Central:
-
Start SQL Central, select Connections>Connect with SQL
Anywhere 16 from the SQL Central menu bar. -
On the Identification page in the Connect dialog box, enter
DBA as the user name and SQL as the password, select or browse to
the data source name or file and click OK.
Publishing all the rows and columns in a
table
The simplest publication you can create is a single article that
consists of all rows and columns of one or more tables. The tables must
already exist.
To publish one or more entire tables in SQL Central:
-
Connect to SQL Central as described in Connecting to
the database in SQL Central. -
Open the Publications folder and select
File>New>Publication from the SQL Central menu. -
Type a name for the new publication and click Next.
-
On the Specify Tables page, select a table from the list of
available tables and click Add.The table appears in the list of selected tables on the
right. -
Optionally, add more tables. The order of the tables is not
important. -
Click Finish.
Publishing only some columns in a
table
You can create a publication that contains all the rows but only
some of the columns of a table.
To publish only some columns in a table in SQL Central:
-
Follow the first four steps of the procedure in Publishing all the rows and columns in
a table. -
Click Next. On the Specify Columns page, double-click the
table’s icon to expand the list of available columns, select each
column you want to publish, and click Add.The selected columns appear on the right.
-
Click Finish.
Publishing only some rows in a
table
You can create a publication that contains some or all of the
columns in a table, but only some of the rows. You do so by writing a
search condition that matches only the rows you want to publish.
In MobiLink, you can use the WHERE clause to exclude the same set
of rows from all subscriptions to a publication. All subscribers to the
publication upload any changes to the rows that satisfy the search
condition.
To create a publication using a WHERE clause in SQL
Central:
-
Follow the first four steps of the procedure in Publishing all the rows and columns in
a table, and optionally the first two steps of the procedure
in Publishing only some columns in a
table. -
Click Next. On the Specify Where Clauses page, select the
table and type the search condition in the lower box.Optionally, you can use the Insert dialog box to help you
format the search condition. -
Click Finish.
Adding articles
You can add articles to existing publications.
To add articles in SQL Central:
-
Connect to SQL Central as described in Connecting to
the database in SQL Central. -
Open the Publications folder and double-click the name of the
publication to which you want to add an article. -
Select File>New>Article from the SQL Central
menu. -
In the Create Article wizard, select a table and click
Next. -
If you want only some columns to be synchronized, select the
Selected Columns radio button and select the columns. -
If you want to add a WHERE clause, click Next and enter the
clause. -
Click Finish.
Modifying and removing publications and
articles
You can modify or drop existing publications in SQL Central by
navigating to the location of the publication and selecting Properties
or Delete from its pop-up menu. You can modify and remove articles in
the same way.
Publications can be modified only by the DBA or the publication’s
owner. You must have DBA authority to drop a publication. If you drop a
publication, all subscriptions to that publication are automatically
deleted as well.
Avoid altering publications in a running MobiLink setup
Altering publications in a running MobiLink setup is likely to
cause replication errors and can lead to loss of data unless carried
out with care.