SQL Server script to convert Meridian 2012 or later audit log database to Enterprise Server 2014 format

Background

Meridian Enterprise 2014 introduced a new EDM Server setting named Use Enterprise server for audit trail. If that option is enabled during an upgrade from Meridian 2012 or later, the existing audit log database structure will be incompatible with the Enterprise Server audit log database structure.

Description

The following SQL Server script can be run to update a Meridian audit log table structure so that the data can then be merged into the Enterprise Server audit log database.

INSERT INTO BCAuditTrail
([ActionName],[RepositoryName],[Context],
[UserName],[UserFullName],[ActionArg1],[ActionArg2],
[ActionArg3],[ActionDate],[ObjectID],[ObjectName],[ObjectPath],[ObjectRevision])
SELECT
[Action],[Vault],[Context],[LoginName],[UserFullName],
CONVERT(nvarchar(max), [ActionArg1]),CONVERT(nvarchar(max),
[ActionArg2]),CONVERT(nvarchar(max), [ActionArg3]),[ActionDate],
CONVERT(nvarchar(255), [ObjectID]),[ObjectName],[ObjectPath],[ObjectRevision]
FROM AuditTrail;