Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Migrating databases to SQL Anywhere

Migrating databases to SQL Anywhere Next Page

Using the Migrate Database wizard

You can create a remote server to connect to the remote database, as well as an external login (if required) to connect the current user to the remote database using the Migrate Database wizard.

To import remote tables (Sybase Central)
  1. From Sybase Central, connect to the target database.

  2. Choose Tools > SQL Anywhere 10 > Migrate Database.

    The Migrate Database wizard appears.

  3. Select the target database from the list, and then click Next.

  4. Select the remote server you want to use to connect to the remote database, and then click Next.

    If you have not already created a remote server, click Create Remote Server Now to access the Create Remote Server wizard.

    For more information about creating a remote server, see Creating remote servers.

    You can also create an external login for the remote server. By default, SQL Anywhere uses the user ID and password of the current user when it connects to a remote server on behalf of that user. However, if the remote server does not have a user defined with the same user ID and password as the current user, you must create an external login. The external login assigns an alternate login name and password for the current user so that user can connect to the remote server.

  5. Select the tables that you want to migrate, and then click Next.

    You cannot migrate system tables, so no system tables appear in this list.

  6. Select the user that will own the tables on the target database, and then click Next.

    If you have not already created a user, click Create User Now to open the User Creation wizard.

    For more information, see Creating new users.

  7. Select whether you want to migrate the data and/or the foreign keys from the remote tables and whether you want to keep the proxy tables that are created for the migration process, and then click Next.

  8. Click Finish.