The following items must be migrated manually:
User-defined thresholds
Abstract plan definitions maintained in sysqueryplans
All system databases except the model database
Any required database options like cache binding, recovery order, and the associated log I/O size as specified by sp_logiosize
Proxy databases
Engine groups
Engine bindings
Execution classes
Cache configurations
Auditing tables and auditing configuration
Server-wide row-lock promotion settings
Access rules
Drop access rules before beginning data migration; they
can prevent the Database Owner from accessing all rows in a table,
which prevents complete data migration.
Compiled objects with hidden SQL text
User-defined segments
Constraints are migrated but when they are bound by name to user-defined message numbers, the bindings must be re-created manually
Settings for objects such as ascinserts, maxwritedes, indextrips, oamtrips, datatrips, and sortbufsize created using dbcc tune
Device definitions
SQLJ functions
Proxy tables for external files
Audit options and audit events
Server configuration
Database suspect threshold
Recovery orders
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
