Versions Compared

Old Version 5

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
PermReqDBMSOracle
PermReqDBMSOracle
Permissions Required for Oracle

TaskPermissions for Own ObjectsPermissions for All Objects
Archive and Compare SchemasNo special privileges required.SELECT_CATALOG_ROLE
Alter Schema ObjectNo special privileges required.DBA role to alter system objects
Configuration SettingsNot applicableDBA role
Compare Data

Select privilege on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Select privilege on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Synchronize/Mask/Move Data

Insert/Update/Delete privileges on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Insert/Update/Delete privileges on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Anchor
PermReqDBMSSQL
PermReqDBMSSQL
Permissions Required for SQL Server

TaskPermissions for Own ObjectsPermissions for All Objects
Archive and Compare Schemas

No special privileges required.

Encrypted stored procedures cannot be viewed.

No special privileges required.

Encrypted stored procedures cannot be viewed.

Alter Schema Object

Permission to connect to the MSDB database.

No special privileges for objects owned by the user.

sysadmin

On SQL Server 2000, you must enable sp_configure to allow updates, and have permission to connect to the MSDB database.

Configuration SettingsNot applicablesysadmin
Compare Data

Select privilege on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Cannot view encrypted stored procedures.

Select privilege on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Cannot view encrypted stored procedures.

Synchronize/Mask/Move Data

Insert/Update/Delete privileges on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Insert/Update/Delete privileges on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

...

TaskPermissions for Own ObjectsPermissions for All Objects
Archive and Compare Schemas

No special privileges required.

Stored procedures cannot be hidden.

syscomment.text read must be allowed in order to compare or archive stored procedures.

No special privileges required.

Stored procedures cannot be hidden.

syscomment.text read must be allowed in order to compare or archive stored procedures.

Alter Schema ObjectNo special privileges required.

sa_role

Enable sp_configure to allow updates

Configuration SettingsNot applicablesa_role
Compare Data

Select privilege on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

The compression comparison function is unavailable for Sybase at this time.

Select privilege on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

The compression comparison function is unavailable for Sybase at this time.

Synchronize/Mask/Move Data

Insert/Update/Delete privileges on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

Insert/Update/Delete privileges on the relevant tables and views.

Schema archive permissions on the database or schema objects used in the job.

...

The following subtopics describe the version information used when comparing, archiving, or creating a configuration standard:

IBM DB2 for LUW Version Information

...

Oracle Version Information

...

SQL Server Version Information

...

Sybase Version Information

...

Anchor
VerInfoDB2
VerInfoDB2
Version Information for DB2 for LUW

ParameterDescription
INST_NAMEName of the current instance.
IS_INST_PARTITIONABLE

Indicates whether the current instance is a partitionable database server instance.

Possible return values are 0, if it is NOT a partitionable database server instance, and 1if it IS a partitionable database server instance.

NUM_DBPARTITIONS

The number of database partitions.

If it is NOT a partitioned database environment, this value is 1.

INST_PTR_SIZEThe bit size of the current instance. Values are 32 or 64.
RELEASE_NUM

The internal release number as returned by the db2level command.

For example, 03030106.

SERVICE_LEVEL

The service level as returned by the db2level command.

For example, DB2 v8.1.80.

BLD_LEVEL

The build level as returned by the db2level command.

For example, n041021.

PTF

The program temporary fix (PTF) identifier as returned by the db2level command.

For example, U498350.

FIXPACK_NUM

The FixPak number as returned by the db2level command.

For example, 9.

Anchor
VerInfoOracle
VerInfoOracle
Version Information for Oracle

On Oracle platforms, DB Change Manager provides a list of all products installed on the Oracle instance and their versions.

Anchor
VerInfoSQL
VerInfoSQL
Version Information for SQL Server

On SQL Server, the following parameters are included:

  • Product Version (e.g. 9.00.3042.00)
  • Platform (e.g. NT INTEL X86)
  • Language
  • Physical Memory
  • Processor Count
  • Processor Type
  • Windows Version
Info

For entries that contain internal values, the numeric attribute is also available for standard comparisons. For example, the Product Version attribute has a character and an internal value of “8.00.2039” and 524288, respectively. DB Change Manager supplies the Product Version as “8.00.2039,” and the Product Version Internal Value as 524288.

Anchor
VerInfoSybase
VerInfoSybase
Version Information for Sybase

On Sybase platforms, two groups of configuration parameters are supplied:

  • The Server Information group displays the results of executing sp_server_info, where the attribute name is the configuration parameter and the value is its value.
  • The Version Information group, which contains the following parameters:
    • Build Number
    • Build Type
    • Compilation Date & Time
    • Compilation Kernel
    • Compilation OS Bit Size
    • Compilation OS Platform
    • EBF Version
    • Post Build Type
    • Product
    • Product Code
    • Version


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 |  
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
  | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse