Live Database - CADWorx - Help

CADWorx Structure

Language
English
Product
CADWorx
Subproduct
Structure
Search by Category
Help
CAESAR II Version
12
CADWorx Version
20.0 (2020)
CADWorx Structure Version
2020(4.0)

CADWorx Structure tab: Tools > Live DB

CADWorx Structure tab: Project > Setup > Live Database

Command line: STRLIVEDB

CADWorx Structure supports a fully functional live external database. Use this command to define the database settings that are saved to the configuration file listed. When a drawing is opened and a configuration file is located in the same folder, the drawing initializes according to that configuration file using a live database or not.

  • When you delete a component from a drawing with an active live database, the database marks that component for deletion. When you close the drawing without saving, then the item does not delete from the database. If you save the drawing, then the item deletes from the database.

  • When a component or a group of components are copied from a drawing to a new drawing that uses the same live database, the copied components are duplicated in the live database with the new drawing name.

  • When a component or a group of components are cut from a drawing and placed in another drawing that uses the same live database, the components duplicate in the live database with the new drawing name. When the old drawing is saved and closed any duplicate items from the first drawing are deleted from the live database because they are no longer on the first drawing.

  • All changes to live database settings take effect in the next drawing session.

On/Off

Turns the live database system on and off. When on, all components drawn are updated instantaneously to the database. Changes can be made in the drawing or in the database. When off, all CADWorx component information is stored only within the drawing.

Database Type and Connection

Select the type of database to use as the live database. Depending on the type chosen, the path to the database or schema displays.

We recommend using Microsoft SQL Database for shared and multi-user environments.

Access

Defines the Microsoft Access database information. Click Create New File to save a database file. Click Open File to specify an existing database.

SQL

Defines the Microsoft SQL Server database information. You must have already created an SQL database in SQL Server. Select a server, then type the database name in the Database box.

Live DB supports SQL Server 2016 and older. Consult SQL Server documentation for more information on SQL Server database setup.

Oracle

Defines the Oracle database information. Type the ODBC schema name in the Schema box.

Consult Oracle documentation for more information on server database setup.

Authentication

  • Windows Authentication - References your Windows User ID and Password as defined in the server authentication settings.

  • Database Authentication - Enter your User ID and Password for the database as defined in the database authentication settings.

Startup Dialog Options

Sets the database option on CADWorx Structure startup.

  • No dialog (new drawings are in Live DB)

Select to place new drawings automatically in the database. Selecting this option requires that a new drawing be named and saved immediately on creation. Drawings that use a live database must be in the same folder with the appropriate configuration file.

  • No dialog (new drawings are not in Live DB)

Select to not add new drawings to the database. You can add drawings to the live database later using this command.

  • Show dialog

Select to display a dialog box on which you can choose to use a database or not.

Save and Close saves the current settings to the configuration file.