FAQ - BME Database migration to another MS SQL Server

FAQ - BME Database migration to another MS SQL Server

Question
How can I migrate the BME server database to another MS SQL server?
How can I migrate the WebEdition database to another MS SQL server and update & connect to BME server?

Answer
This article describes how to move BME server database to another MS SQL database server. This procedure could also be used for migrating and updating WE database to connect with BME server.

This may be useful e.g. in case you are moving or upgrading your WebEdition/BME server to a new physical computer or when you need to separate MS SQL database server role to a dedicated computer.
  1. Backup the database of current server following the procedure described in Backup and restore of TBS WebEdition server database (MS SQL).
  2. Copy the backup file to a folder on the target computer.
  3. Start Microsoft SQL Management Studio on the target computer.
  4. Right click Databases node and select Restore Database… from the displayed context menu.
  5. Fill in “TBS_BAWSE” into To database: field, switch Source for restore to From device and click […]. In Specify Backup dialog, click [Add] and browse for your stored backup file.
  6. In Select the backup sets to restore list, select (check the box in Restore column) the item you added in the previous step. Click [OK] to start the process.



     7. 
When the database is restored, it is necessary to run a script to create correct login credentials for the restored database. To do so, select File -> Open -> File… in the main menu of MS SQL Management Studio and choose the location of ‘TBS_BAWSE_resolveloginafterrestore.sql’ file (located at C:\TBS\ Biomanager_ENTERPRISE\Tools\DBInstallerTool\scripts. Run the script with [Execute] button (or F5).
    8. After the restoration is successful, it is required to run the "TBS.Apps.DBInstallerTool" (located at C:\TBS\ Biomanager_ENTERPRISE\Tools\DBInstaller folder) by selecting the option "Update the Database" to update the database schema and connect the BME application server to new database (snapshot below for reference).

               





    • Related Articles

    • FAQ - Database migration to another MS SQL server

      Question How can I migrate complete TBS WebEdition server database to another MS SQL server? Answer This article describes how to move TBS WebEdition server database to another MS SQL database server. This may be useful e.g. in case you are moving or ...
    • FAQ - Basic backup/restore of WE database in the same MS SQL Server

      Question How can I simply backup and restore TBS WebEdition server database (in the same SQL Server installation)? Answer In order to prevent data loss, it is a good practice to regularly backup content of TBS WebEdition server database. This article ...
    • FAQ - WebEdition migration to another server machine

      Question How can I migrate the TBS WebEdition server software to another server machine? Answer This article describes how to migrate the TBS WebEdition (WE) server software to a different physical computer. The below steps should be followed in ...
    • FAQ - Ways to access SQL Server in WebEdition

      Question By default WebEdition accesses SQL server database using 'SQL Server authentication'. How can I change that to 'Windows authentication'? Answer TBS server software is preconfigured to use 'SQL Server authentication' method when connecting to ...
    • HowTo - Handle 'Database operation error' issues

      The Database operation error issue is one of the most common problems detected after a WebEdition installation. It is a general error which is basically saying that connection to the database server (default, SQL Server) could not be established. ...