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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data » Migrating databases to SQL Anywhere


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. Connect to the database as a user with DBA authority.

  2. Choose Tools » SQL Anywhere 11 » Migrate Database.

  3. Click Next.

  4. Select the target database, and click Next.

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

    If you have not created a remote server, click Create Remote Server Now and follow the instructions in 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.

  6. 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.

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

    If you have not created a user, click Create User Now and follow the instructions in the Create User Wizard. For more information, see Creating new users.

  8. 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.

  9. Click Finish.