Hi Guys,

We moved our current textwork to a new sql instance.
Therefore we back up our sql server inmagic databases and restore it into the new instance.

We now encounter issue with our menu page, which consists of 3 buttons.
When we click on the first item, we received an error message saying that it could not locate SQL database for textbase.......

Completed an sql trace and noticed it was doing the following:
SET NOCOUNT ON IF EXISTS(SELECT _TextbaseID FROM .dbo._InmTextbaseMap WHERE _TextbaseID = 4) SELECT _TextbaseID, _ExternalName, _InternalName FROM .dbo._InmTextbaseMap WHERE _TextbaseID = 4 ELSE SELECT -1 AS _TextbaseID

As we all understand, the _TextbaseID is the primary hence it is automatically assign when we restore the inmagic database. It looks to me that the first button on our menu is pointed to _TextbaseID 4 however it's now changed to 1 on our new instance.

Does anyone know how to fix this, the mapping is correct in the dbo._InmTextbaseMap database.

Kind regards,

Eric Kuang

When backing up and restoring Content Server textbases, you should use the Back Up Textbases and Restore Textbases commands in the INMCSADMIN.EXE program for exactly the reasons you're encountering.

The SQL database name is stored in the .CBA file, and I know of no straightforward way to change it to point to the new database name.

You may be able to rename the database in the new SQL instance to match the old name. If you go this route, you may also want to edit the name in the _InmTextbases table.

Thank you Lisa.
It is now working as expected by backing up and restoring.