Run the IN_EXTERN_MSG_SEQ.sql script - iConvert for Perceptive Content Product Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external - Perceptive-Content/iConvert-for-Perceptive-Content-Product-Guide/Foundation-24.1/iConvert-for-Perceptive-Content-Product-Guide/After-the-conversion/Run-the-IN_EXTERN_MSG_SEQ.sql-script - 2024-04-02 - To complete the conversion of your SQL Server database, you must run the IN_EXTERN_MSG_SEQ.sql script. This script will copy the data in the inemuser.IN_EXTERN_MSG_SEQ table from the existing server (source_db) to the new server (dest_db). This process only applies to SQL Server databases. To prepare and execute the script, complete the following steps.

To complete the conversion of your SQL Server database, you must run the IN_EXTERN_MSG_SEQ.sql script. This script will copy the data in the inemuser.IN_EXTERN_MSG_SEQ table from the existing server (source_db) to the new server (dest_db). This process only applies to SQL Server databases. To prepare and execute the script, complete the following steps.

1. In SQL Server Management Studio, connect to the Unicode server using a login with system administrator privileges.
2. Open the IN_EXTERN_MSG_SEQ.sql script and complete the following substeps.
   1. Ensure the variables in the Variable Declaration section of the script are set to the correct source, destination server, and database for your environment.
   2. Replace the INOW6_DESTINATION variable name with the name of the destination Unicode database.
      Note: This name must match the declared v_dest_db variable.
3. Click Execute.
   Note: This script creates a temporary linked server between the two instances of SQL Server in order to pull data between the source and destination databases.