With {{UBIK}} Server version 4.0, much has changed on database level. We had to sacrifice direct downward compatibility with respect to older database versions in order to gain new possibilities (see [[Dynamic_Live_Mode]]).
In order to upgrade a {{UBIK}} Environment from version 3.7 to version 4.0, it is necessary to create a new database and to transfer the data from the old database to the new one. Here's how.
<!-- DO NOT REMOVE THIS -->{{Template:HowTo/Begin}}<!-- DO NOT REMOVE THIS -->
== Create an empty {{UBIK}} 4.0 database ==
* Create a new, empty database for your {{UBIK}} 4.0 Environment. It has to be on the same server as your old database (or a copy thereof).* Make sure your SmartStudio version 4.0 has all the plugins required for your project.
* If you haven't removed the CUI meta classes from your 3.7 database before loading the meta classes into the SmartStudio project, you also need the CUI plugin.
* Open SmartStudio version 4.0.
* Open the previously created Project.
* Connect to the new (and empty) {{UBIK}} 4.0 Environment.=> SmartStudio now asks you to upgrade the empty database to version 4.0. Confirm the upgrade dialog. {{UBIK}} now creates all the basic system definitions in the previously empty database.
{{Hint|You might get an MSDTC related error. In that case you need to enable the MSDTC: https://learn.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-sql/configure-msdtc-on-sql-server-and-adapter-client}}
* Open the Transport Container with all the 3.7 meta definitions from the Project.
* Merge & Save the Transport Container to the Environment.
=> All the meta definitions should be available in the new {{UBIK}} 4.0 Environment. Now we just have to transfer the instance data.
{{Hint|Known issue: SmartStudio assumes the relation data meta class of a relation has the same name. If the relation was renamed (but not the data meta class), a new data meta class with the same name will be created for the relation. In that case, you might have to set the correct data meta class after the transfer (all meta classes are transferred, just the reference might be wrong). The new data meta class with the same name as the relation can be deleted then.}}
* Open the "Instance Data Transfer Wizard" using the "Environment" menu.
* Follow the wizard's instructions until the end.
=> The wizard copies all the instance data from the old 3.7 Environment to the new {{UBIK}} 4.7 Environment.
== Maintain languages ==