What sybmigrate does

During the setup portion of the migration process, the following server data is migrated to the target Adaptive Server:

• Remote servers

• Logins

• Login attributes

• Server roles

• Login roles

• Role attributes

• Users

• Alternate users

• Roles

• Permissions

• Remote logins

• External login attributes

• Timer

• Resource limits

• Replication attributes

• Display level attributes

• User messages in the master database

• Java classes in the master database

• JAR files in the master database

• Proxy objects

During the migration portion of the migration process, the following database-specific data is migrated to the target database:

• Defaults

• User-defined datatypes

• Rules

• User tables

• User table data

• Views

• Triggers

• Indexes

• Stored procedures

• Extended stored procedures

• Users

• Logins

• Roles

• Remote servers

• Database data

  • Users

  • Alternate users

  • Roles

  • Role attributes

  • Permissions

  • User messages

  • Java classes

  • JAR files

• Defaults

• Rules

• User-defined types

• Tables

• Indexes

• Referential constraints

• Views

• Stored procedures

• Triggers