Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote
    Lesson 3: Set up the remote database

Create the remote database

You need to extract a database from the consolidated database for remote user field.

Extract the remote database

1. Right-click the sample database asademo (DBA), and choose Extract Database from the popup menu.

   The Extract Database wizard appears.

2. Click Next on the introductory page of the wizard.

3. Choose to extract the asademo database. Click Next.

4. Choose to extract at isolation level 3. Click Next.

5. Choose to Start Subscriptions Automatically for user field. Click Next.

6. Enter a location for the SQL file that will build the database. For example, choose c:\tutorial\field.sql. As well, choose to extract the structure and data (the default setting).

7. Choose to extract all parts of the schema and leave the maximum view dependency at its default setting. Click Next.

8. Choose not to Extract Fully Qualified Publication Definitions. Click Next.

9. Leave the location to save the data at its default value.

10. Choose Create and Reload Into the Following New Database, and enter a path and filename for the database. For example, c:\tutorial\field.db. Click Finish.

    The Extracting Database window appears, displaying the progress of the extraction. When completed, close the window.

Note 

In a proper SQL Remote setup, the remote database field would be loaded on to the computer, together with a database server and any client applications required. For this tutorial, we leave the database where it is and use Interactive SQL to input and replicate data.