DBA xPress Preferences

Parent Previous Next


Preferences


Within the DBA xPress Preferences, users can customize the behavior and properties of Data Inspector, Data Space Analyzer, Data Surf, Schema Inspector, and Schema Surf:


  Data Inspector

o   Comparison Defaults

  Compare Intersecting IDENTITY Ranges Only: Controls whether segmented identity comparisons only consider the range of identity values that are covered in both databases

  Data Read Timeout: Controls the timeout, in seconds, for opening the table data

  Default Index Preference: Controls the default index preference type

  Do not Compare Computed Columns: Controls whether or not computed columns that are not part of the key should be compared

  Ignore IDENTITY Values: Controls whether IDENTITY values should be ignored if they are not part of the key

  Ignore ROWGUIDCOL Columns: Controls whether ROWGUIDCOL columns should be ignored by default

  Ignore String Case: Controls whether the case of strings should be ignored

  Ignore String Line Endings: Controls whether differences in string line endings should be ignored

  Match Objects in any Schema: Controls whether object matching should consider objects with the same name in other schemas

  Maximum Active Threads: Controls the maximum number of threads to use in threaded comparison mode

  Segmented Identity Compare Block Size: Controls the number of rows in each segment for segmented identity comparisons

  Trim Spaces: Controls whether leading / trailing white spaces should be ignored when comparing strings

  Use Binary CLR Type Comparisons: Controls whether CLR types should be compared using their binary, rather than their string representation

  Use Case Sensitive Matching: Controls whether case sensitive matching should be used to find / match object names

  Use Segmented Identity Compare: Controls whether segmented identity comparisons are used when the selected index is a single column index and the indexed column is an IDENTITY column

o   General

  Grid Viewer Row Count Limit: Allows users to set the maximum number of rows to be viewable

  Start with deselected items: Data Inspector will begin with deselected items

o   Synchronization Defaults

  Batch Separator: Controls the batch separator used in between script portions

  Disable DML Triggers During Synchronization: Controls whether DML triggers should be disabled during synchronization

  Disable Foreign Keys During Synchronization: Controls whether foreign keys should be disabled during synchronization

  Max Rows per Batch: Controls the maximum number of rows per batch

  Only Update Compared Columns: Controls whether only the values selected at compare time should be updated when modifying existing rows

  Synchronize target DELETEs: Controls whether DELETEs on target are selected by default

  Synchronize target INSERTs: Controls whether INSERTs on target are selected by default

  Synchronize target UPDATEs: Controls whether UPDATEs on target are selected by default

  Use Transacted Modification SQL: Controls whether the data modification SQL should be transacted


  Data Space analyzer

o   Default Database View: Set which Database View within the Data Space Analyzer will, by default, be displayed when first loaded

o   Default Server View: Set which Server View within the Data Space Analyzer will, by default, be displayed when first loaded

o   Show Data Labels: Controls whether data labels will be displayed by default

o   Use fast loading on 2005+: Controls whether to use faster and less detailed data about space usage


  Data Surf

o   Color Inheritance: Controls whether new nodes will inherit their parent node's color

o   Default Layout Style: Controls the layout style that will be selected

o   Default Node Color: Controls the default color given to nodes

o   Failed Node Color: Controls the default color given to nodes that data failed to load

o   Graph Font: Controls the font style used for displaying text within nodes

o   Grid Font: Controls the font style used for displaying the data within the grid

o   Limit: Controls the maximum number of nodes that can be created in a single operation

o   Warning Level: Controls the number of nodes above which a warning is generated for a single operation


  Schema Inspector

o   Comparison Defaults

  Find Constraints by Signature: Controls whether, after searching for a constraint match by name, Schema Inspector will search for it by signature

  Ignore Key Index Properties: Controls whether key index (primary key, unique constraint, target of foreign key constraint) properties should be ignored

  Ignore Partitioning: Controls whether partitioning should be ignored

  Ignore Referential Actions: Controls whether referential actions should be ignored

  Ignore WITH NOCHECK: Controls WITH NO CHECK should be ignored

  Ignore Full Text Catalog Default Selection: Controls whether the default property of full text catalogs should be ignored

  Ignore Full Text Index Accent Sensitivity: Controls whether full text index accent sensitivity should be ignored

  Ignore Full Text Index Change Tracking: Controls whether full text index change tracking states should be ignored

  Ignore Full Text Index Stoplists: Controls whether full text index stop lists should be ignored

  Find Object in any Schema: Controls whether schema-scoped objects can be searched for in any schema, emitting an ALTER SCHEMA statement during synchronization

  Ignore Corrected Object Names: Controls whether object names which have been corrected are ignored during comparison

  Ignore Object Principals: Controls whether object principals should be ignored

  Ignore Principal Logins: Controls whether principal login differences should be ignored

  Ignore XML Schema Collection Properties: Controls whether XML schema collection properties for columns should be ignored

  Use Case Sensitive Matching: Controls whether case sensitive matching should be used to find / match object names

  Ignore Fill Factor: Controls whether fill factor properties should be ignored

  Ignore Index Column Inclusion: Controls whether included column properties should be ignored

  Ignore Index Padding: Controls whether index padding properties should be ignored

  Ignore Key Ascendancy: Controls whether key sort order properties should be ignored

  Ignore IGNORE_DUP_KEY: Controls whether IGNORE_DUP_KEY properties should be ignored

  Ignore Lock Always: Controls whether allow row lock / allow page lock properties should be ignored

  Ignore ANSI NULLS: Controls whether the SET ANSI NULLS option state should be ignored

  Ignore Encrypted Object Differences: Controls whether object encryption differences should be ignored

  Ignore NULL on NULL Input: Controls whether NULL or NULL Input properties should be ignored

  Ignore Object EXECUTE AS Principals: Controls whether object EXECUTE AS principals should be ignored

  Ignore Permission Sets: Controls whether assembly permission sets should be ignored

  Ignore QUOTED IDENTIFIER: Controls whether the SET QUOTED IDENTIFIER state should be ignored

  Ignore Schema Bindings: Controls whether schema binding properties should be ignored

  Ignore SQL Case: Controls whether cases in SQL definitions should be ignored

  Ignore SQL Comments: Controls whether comments in SQL definitions should be ignored

  Ignore SQL White Space: Controls whether white space in SQL definitions should be ignored

  Ignore WITH CHECK OPTION: Controls whether WITH CHECK OPTION properties should be ignored

  Ignore WITH RECOMPILE: Controls whether WITH RECOMPILE properties should be ignored

  Ignore Event Notification Broker Instances: Controls whether event notification broker instances should be ignored

  Ignore Event Notification Service Names: Controls whether event notification service names should be ignored

  Ignore Maximum Queue Readers: Controls whether maximum queue readers property should be ignored

  Consider Column Order: Controls whether column order for tables and table types will be considered

  Ignore Boundary Value Alignments: Controls whether boundary value alignments on partition functions should be ignored

  Ignore Collations: Controls whether collations should be ignored computed column persistence should be ignored

  Ignore Column Sparsity: Controls whether column sparsity should be ignored

  Ignore Computed Column Persistence: Controls whether computed column persistence should be ignored

  Ignore Data Space Default Selections: Controls whether data space default selections should be ignored

  Ignore File Group Assignments: Controls whether file group assignments should be ignored

  Ignore IDENTITY: Controls whether IDENTITY properties should be ignored

  Ignore IDENTITY Seed and Increment: Controls whether IDENTITY seed and increment values should be ignored

  Ignore Maximum Length: Controls whether the maximum length property should be ignored

  Ignore NOT FOR REPLICATION: Controls whether NOT FOR REPLICATION should be ignored

  Ignore Nullability: Controls whether nullability should be ignored

  Ignore Precision and Scale: Controls whether precision and scale properties should be ignored

  Ignore ROWGUIDCOL: Controls whether row GUID column properties should be ignored

o   Documentation

  Default Report Type: Controls the type of report generated by default

  Include Equivalent Objects in Comparison: Controls whether to include details of objects that are equivalent while generating comparison documentation

  Include Modification DDL in Synchronization: Controls whether to include the data definition language (DDL) script used while generating synchronization documentation

  Create New Folder: Controls whether to create a new folder when generating HTML reports

  Default Output Folder: Controls the default output folder for HTML reports

  Generate Page Headers: Controls whether to generate page headers in the documentation

  Custom Style Sheet File: Controls the location for a custom style sheet that will be used

  Use Collapsible Table of Contents: Controls whether to use a collapsible table of contents containing JavaScript

  Use Default Style Sheet: Controls whether to use the default Schema Inspector style sheet

  Comment Color: Controls the color of comments

  Default Output Folder: Controls the default output folder for RTF reports

  Text Color: Controls the color of text

  Function Color: Controls the color of functions

  Identifier Color: Controls the color of identifiers

  Keyword Color: Controls the color of keywords

  Link Color: Controls the color of links

  Number Color: Controls the color of numbers

  Operator Color: Controls the color of operators

  String Color: Controls the color of strings

  Table Background Color: Controls the color to use for table rows

  Table Header Background Color: Controls the color to use for table headers

o   General

  Group Comparison Results by Types: Controls whether to group the results of the comparison by type

  Start with deselected items: Controls whether to start with items deselected when viewing comparison results

o   Generation Defaults

  Allow System Named Constrains: Controls whether system name constraints are emitted without names, to be named by the system on the target

  Always Load Definable Objects Direct from Server: Controls whether definable object definitions should always be loaded direct from the server

  Always Specify Collation: Controls whether collation should always be specified, even if it is the same as the database default

  Auto Create Files for File Groups: Controls whether, when creating file groups, files should be created in the same location as the first entry in sysfiles

  Batch Separator: Controls the batch separator used in between script portions

  Do not Warn About Unsafe Assemblies: Controls whether script generation warnings about unsafe assemblies should be suppressed

  Emit Generation Warnings in Output SQL: Controls whether warnings generated while generating SQL are emitted in the output

  Emit Table Constraints in Line: Controls whether table constrains are emitted with CREATE TABLE statements

  Fix Object Names in Definable Objects: Controls whether object names in definable objects should be corrected

  Keep Trigger Order: Controls whether FIRST and LAST statements should be issued for triggers

  Replace User-defined SQL Types with Base Types: Controls whether user defined SQL types should be replaced with base types in the target script

  Use Object Presence Checks: Controls whether object presence checks should be emitted with generated SQL

  Use Online Index Building: Controls whether, if possible, the ONLINE ON clause should be emitted when creating indexes

  Use Store and Restore for CLR Type Alterations: Controls whether table data should be stored in another table and restored again afterwards when altering CLR Types

  Use Transacted Schema Modification SQL: Controls whether generated SQL should be transacted


  Schema Surf

o   Default Layout Style: Controls the layout style that will be selected

o   Default Levels Shown: Controls the number of dependency levels to be shown

o   Default Node Color: Controls the color given to nodes

o   Graph Font: Controls the font style used for displaying text within nodes