Integrating a Standalone SQL Anywhere Database with WorkSpace

If you are using a standalone SQL Anywhere 10 database, integrate it with WorkSpace to access its data.

  1. Open the Database Development perspective.
  2. Verify that the SQL Anywhere instance is running and that the connection profile to the database server is connected.
  3. Click the Execute Multiple SQL Files icon, located on the main toolbar for the perspective. Execute multiple XML files icon
  4. Select asa_10.sql, navigating to it if needed. The asa_10.sql file is located at <your_WorkSpace_dir>\DevRuntimes\ASA\.
  5. In the Select Profile for the Files dialog, select the following and click OK:
    1. Sybase_ASA_10.x for the database server type.
    2. The connection profile used to connect to the database server instance.
  6. Use the SQL Results view to verify that the sql file execution was successful.
  7. Restart SQL Anywhere.
Parent topic: Post-Installation Tasks

Created August 20, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com