Importing an SQL database
You can read complete networks from an existing SQL database or selected network tables additionally to the current network table.
Note: The database has to contain table $Version which is required for the import. |
1. In the File menu, select the Import > Database entry.
The Select database window opens.
2. Select MS SQL server.
3. Confirm with OK.
The Data link properties window opens.
4. Select the Provider tab.
5. Select the appropriate provider for SQL servers, for example Microsoft OLE DB provider for SQL server.
6. Select the Connection tab.
Tip: Alternatively you can click the Next button in the Provider tab. |
7. Enter the server name where the SQL database is.
Tip: Alternatively select the name from the drop-down list. |
8. Enter user name and password to access the SQL server.
9. Select the option Allow password to be saved.
10. From the drop-down list select the desired database on the SQL server.
Tip: You can check whether the connection to the SQL server has been established and export to the database can take place by clicking the Test connection button. |
11. Confirm with OK.
The Read network window opens.
12. Make the desired settings (Opening a network file and Reading network data additively).
13. Confirm with OK.
The import of network data from the SQL database is started. If you have selected the option Read network file additionally, the Read network data additionally window also opens (Reading network data additively). If the network data contains incomplete line routes or system routes, i.e. at least one link or stop point is missing in the route course or blocked for the transport system, the Read network (completing LineRoute/SystemRoute) window also opens (Reading a network file with incomplete line routes or system routes).