Generating the Remote Server and Proxy Tables Creation Scripts

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

  1. Select Tools > Proxy Tables > GenerateProxy Tables to open the Generation dialog, and click the Options tab.
  2. Set an appropriate value for the UserReplica and UserShorcut options to allow you to generate the proxy tables corresponding to replica and/or external shortcuts.
  3. Set the Generate proxy servers option to True to generate proxy servers. You can deselect any proxy servers you do not want to generate.
  4. Click OK to begin generation.

    The generated script is displayed in the Result dialog.

  5. [optional] Double-click the generated SQL file or click the Edit button to open the script in a text editor.
  6. Run the script on your database in order to create the proxy tables.
Parent topic: Proxy Tables (ASE/SQL Anywhere)