Convert UDBDatasource to UDBXDatasource and vice versa. UDB- > UDBX is to Convert to UDBXDatasource UDBDatasource (*.udb) (*.udbx). UDBX- > UDB is to convert UDBXDatasource (*.udbx) to UDBDatasource (*.udb).
| Advantages and disadvantages of UDBX format compared to UDB format | ||
| Advantage | Easy to manage | UDBXDatasource is a single file, which is easier to manage than UDB's dual files. |
| More reliable | The single-file design of UDBXDatasource avoids the problem of data damage that may be caused by the accidental crash of 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 of data volume, the query performance of UDBX is obviously 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 UDBXDatasource is fast, even if the file is large. | |
| Disadvantage | Large file volume | With the exception of point data, the data size of the UDBX file after R-Tree creation is slightly larger than UDB File on average. The more complex the object, the larger the data file, and vice versa. |
| Slow query speed | Point Dataset queries are slightly slower than UDB engine. | |
UDB->UDBX
- On the Data tab, in the Tools group, click the UDB- > UDBX button in the Datasource Conversion drop-down menu to display the UDB- > UDBX dialog.
- Click the Add button on the toolbar in the dialog box. The drop-down options include four Add Datasource methods. The differences are as follows:
- Add Datasource: Select the UDBData source in the Local File.
- Add WorkSpace: Add all UDBData sources in a Workspace stored in the Local File to the list and display the Workspace.
- Add Current Data Source: Add all UDBDatasources in Current Workspace.
- Add Current Works pace: Adds all UDBDatasources in the Current Works pace and displays Workspace.
- In the dialog box list, you can manage the Datasource Info to be converted through the Select All, Invert, Delete, and Uniform Settings buttons in the toolbar. For example, after selecting All Data sources, click the Uniform Settings button. Uniform Settings is the storage path of all Datasource Conversion results.
Caution: - When the Source Datasource has a password, the Datasource Conversion can be performed only with the password of the Input Data: source in the Password column.
- When the Target Datasource needs to be stored in different paths, it can be set separately 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 is China. Smwu. The converted Works paceAuto Save is China1.smwu, and the saved path is the same as the original file. Caution:
The Convert Workspace check box can be selected only when the Datasource in the Workspace is added in the current list box; For data that only Add Datasource, the program cannot identify the Workspace that references the Datasource, so this check box cannot be selected in this case.
- 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 group, click the UDBX-> UDB button in the Datasource Conversion drop-down menu to display the UDBX-> UDB dialog. The rest of the content is the same as above, please refer to the above document for detailed description.
Caution: UDBX is converted to UDB as a double file.
Related topics
View the Datasource properties