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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » Database migration to SQL Anywhere

 

Using the Migrate Database Wizard

In Sybase Central, you can create a remote server to connect to the remote database, and an external login (if required) to connect the current user to the remote database using the Migrate Database Wizard.

Prerequisites

You must already have a remote server created. You must already have a user to own the tables in the target database.

You must have either both the CREATE PROXY TABLE and CREATE TABLE system privilege, or all of the following system privileges:

  • CREATE ANY TABLE
  • ALTER ANY TABLE
  • DROP ANY TABLE
  • INSERT ANY TABLE
  • SELECT ANY TABLE
  • CREATE ANY INDEX
 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click Tools » SQL Anywhere 16 » 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.

    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 to own the tables in the target database, and then click Next.

  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.

Results

The specified tables are migrated.

 See also