Chapter 14 DBMS-Specific Features

Generating the remote server and proxy tables creation scripts

You can generate the remote server and proxy tables creation scripts in order to run them in the database. Generation must be started from the model containing proxy tables.

The ProxyTables extended model definition contains the creation script syntax for Sybase ASA.

To generate the remote server and proxy tables creation scripts:

1. Select Tools→Proxy Tables→Generate Proxy Tables.
   
   The Generation dialog box opens.
2. Click the Options page to display the corresponding page.
3. Set a value for the UserReplica and UserShorcut options. This allows you to generate the proxy tables corresponding to replica and/or external shortcuts.
4. Set a value for the Generate proxy servers option:

If you want to generate all proxy servers Set the Generate proxy servers option to True in the Generation dialog box

If you do not want to generate all proxy servers Set the Generate proxy servers option to False in the Generation dialog box, this prevents server generation whatever the GenerateAsProxyServer extended attribute value

If you want to generate several proxy servers Set the Generate proxy servers option to True in the Generation dialog box, deselect the data sources corresponding to the proxy servers you do not want to generate

1. Click OK.
   
   Generation starts.
   
   The generated script appears in the Result dialog box.
2. Double-click the generated SQL file or click the Edit button.
   
   The script appears in a text editor.
   
   You can now run this script on your database in order to create the proxy tables.

Copyright (C) 2005. Sybase Inc. All rights reserved.