Open topic with navigation

Moving the Scribe Internal Database

If your site upgrades or moves to a new instance of Microsoft SQL Server (for example, upgrading from SQL Server 2008 to SQL Server 2012, you must move your Scribe Internal Database. The Scribe Internal Database (default name SCRIBEINTERNAL) is a SQL Server database that contains information used by TIBCO Scribe® Insight.

To Move The Scribe Internal Database

1. Back up all of your data from your old (source) database, as described in Backing Up Files. Be sure to include the Scribe Internal Database in the backup.

   Note: When moving the Scribe Internal Database, Scribe suggests that you either:
   
   – Upgrade to the latest version of Insight before backing up the Scribe Internal Database
   
   – Create the new Scribe Internal Database using the same version of Insight as you had running for the old Scribe Internal Database.
   
   If you restore an old version of the Scribe Internal Database to a new version of the same database, you may corrupt existing Integration Processes, Execution History logs, or experience other unpredictable results.

2. Create a new Scribe Internal Database on the new (target) SQL Server instance:
   1. In the Scribe installation directory (..\Scribe), right-click InternalDB.exe and select Run as Administrator.
   2. On the Internal Database tab, click Install Internal Database.

      Note: If the Stop Scribe services message displays, click OK to stop the Scribe services and close the message.

   3. On the Scribe Database Setup window, click Next.
   4. Under Authentication, select the type of Authentication you want to use. If you select SQL Server authentication, enter the Admin Login ID and Admin Password.
   5. Under Database Information, enter:
      • Instance — The new SQL Server Instance name.
      • Database Name — The original Scribe Internal Database name.
   6. Click Next, and then click Yes to create the new database.
   7. On the Internal Database tab, click Test Connection.
   8. Click OK to close the Internaldb.exe utility.
3. Restore the source Scribe Internal Database onto the target SQL Server.
4. Restore the backup file (*.bak) that you created earlier to the new Scribe Internal Database you just created. At the prompts, select Yes to overwrite the existing database.
5. From the Internaldb.exe utility, open the Internal Database tab and click Test Connection to make sure the connection is working.
6. Your Scribe Internal Database is now on the new SQL Server. Be sure to test Insight thoroughly in a test environment before using the new Scribe Internal Database in production.

TIBCO Scribe® Insight Help Library