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:
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Click Tools » SQL Anywhere 16 » Migrate Database.
Click Next.
Select the target database, and click Next.
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.
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.
Select the user to own the tables in the target database, and then click Next.
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.
Click Finish.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |