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.
Connect to the database as a user with DBA authority.
Choose Tools » SQL Anywhere 11 » Migrate Database.
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.
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 Create remote servers using the CREATE SERVER statement.
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 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.
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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|