Create table using API

— // Drop the Tableexecsql,c,DROP TABLE DMS_AUDITexecsql,c,COMMIT — // Create the Tableexecsql,c,CREATE TABLE [dbo].[DMS_AUDIT]([r_object_id] nvarchar NOT NULL,[audited_obj_id] nvarchar NOT NULL,[time_stamp] nvarchar NULL,[user_name] nvarchar NOT NULL, [user_id] nvarchar NOT NULL, [chronicle_id] nvarchar NOT NULL, [object_name] nvarchar NULL, [object_type] nvarchar NOT NULL,[event_name] nvarchar NOT NULL,[event_source] nvarchar NOT NULL,[event_description] nvarchar NOT NULL) ON [PRIMARY]execsql,c,COMMIT –############TABLE my_attrib_definitions Population #####—…

Read More

Changing Documentum Installation Owner

There is a migration utility under $DM_HOME/install/external_apps/MigrationUtil that allows you to change the installation owner.  1 Backup/Snapshot of VM Image2 Backup/Snapshot of Database3 Create new Install Owner for Production (ADUC account).4 Copy MigrationUtil on the Documentum Server.5 Update the JDBC drivers to JDBC5.jar in the MigrationUtil folder.6 Make copy of Config.xml within the same folder…

Read More