Datasource Conversion

Feature Description

Datasource Conversion supports converting UDB (*.udb) datasource to UDBX (*.udbx) datasource and vice versa.

Pros & Cons of UDBX compared to UDB
Pros	Easy to manage	UDBX datasource is a single file, which is easier to manage than UDB's dual files.
	More reliable	The single-file design of the UDBX datasource avoids the problem of data damage that may be caused by the accidental crash of the UDB double-file program and improves the reliability and integrity of data.
	Replicate efficiently	Without the User Custom field, the replication performance of UDBX is comparable to UDB. As the number of fields increases, the replication performance of UDBX gradually improves over UDB.
	Good query performance	With the increase in data volume, the query performance of UDBX is better than that of UDB, because the query performance of UDB decreases significantly when the data volume increases, while UDBX solves this problem well.
	Fast opening speed	Opening the UDBX datasource is fast, even if the file is large.
Cons	Large file volume	Except for point data, the data size of the UDBX file after R-Tree creation is slightly larger than the UDB File on average. The more complex the object, the larger the data file, and vice versa.
Cons	Slow query speed	Point dataset queries are slightly slower than the UDB engine.

Steps

UDB -> UDBX

On the Data tab, in the Tools drop-down menu, click the UDB -> UDBX button in the Datasource Conversion drop-down.
Click the Add button on the toolbar in the dialog box. The drop-down options include four methods. The differences are as follows:
- Add Datasource: Select the UDB datasource in the local file.
- Add WorkSpace: Add all UDB datasources in a workspace stored in the local file to the list and display the workspace.
- Add Current Datasource: Add all UDB datasources in the current workspace.
- Add Current Workspace: Adds all UDB datasources in the current workspace and displays workspace.
In the dialog box list, you can manage the datasource Info to be converted through the Select All, Select Reverse, Delete, and Uniform Settings buttons in the toolbar. If you select all datasources and click the "Uniform Settings" button, you can set a unified storage path for the conversion results of all datasources.
Caution:
- When the source datasource is password-protected, you must enter the password in the Password column to proceed with the datasource conversion.
- If the target datasource needs to be stored in different paths, you can individually set the storage path in the Target datasource column.
Check the Convert Workspace check box to convert the corresponding workspace while converting the datasource without overwriting the original Workspace. For example, the workspace where the UDB data is located in World. smwu, and the converted Workspace AutoSave will be World1.smwu, and the saved path will be the same as the original file.

Caution:

The "Convert Workspace" checkbox is only selectable when the datasource added to the current list box belongs to a workspace. For datasources added individually, the program cannot identify the workspace referencing the datasource, so the checkbox cannot be selected in such cases.
After completing the above settings, click the Start button to perform the UDB conversion operation. After the conversion is completed, the conversion information will be output in the Output Window, and the log file path of the conversion details will be given for viewing.

UDBX -> UDB

On the Data tab, in the Tools drop-down menu, click the UDBX -> UDB button in the Datasource Conversion drop-down. The rest of the steps are the same as above, please refer to the above document for a detailed description.

Caution: