Advanced Functions: Create New Database and Copy Data

Target

Select from the list the target company which represents a database setup in your ExtrasLogon.db settings. If you havent already setup a new database use the Change Settings button to set one up.

User ID

The Caliach Vision UserId used when creating a new database is always SYS with no password. If you also copy the data the current database users will be copied.

Password

When creating a new database the Login password is always blank.

Server username

Enter the Server DBMS username that you wish to attach with. This will assign you database privileges. This field is only visible for server engines. SQLite has no security of this nature.

Server password

Enter your Server DBMS password here. It is case-sensitive. This field is only visible for server engines. SQLite has no security of this nature.

Chunk size

Data is read and written in blocks of rows, known as chunks. The larger the chunk the more memory is used but writing to disk is more efficient.

Lockout other users while copying data

If checked, you can only proceed if you are the only user on the current database and when processing the copy no other user can access the database to make changes. This option ensures a know data state for the copy.

Change Settings

Click to change or add logon settings. This opens the Database Connection Settings window.

Create or Overwrite Database to Empty

To create or overwrite the target database that is then left empty of data. If you are overwriting, the target database will first be dropped (deleted entirely) before being re-built.

Create or Overwrite Database and Copy Data

To create or overwrite the target database. If you are overwriting, the target database will first be dropped (deleted entirely) before being re-built. You current data will then be coppied table-by-table. The result will be a cloned database of the source.

Create/Renew Play Data

With a PostgreSQL database you can create a databaseplay database. If it already exists it will be dropped first and recreated. You must be the only connection to the current database. This process is much faster than using the other Create processes on this window.

NOTE: This process creates or renews a duplicate database named the same as your current database plus the 4 letters “play”. It can only be run if you have exclusive use of the current database and that there are no connections to the play database. The process also performs the following on the databaseplay database:

• Truncates the tables USLFILE (User session log) and USTFILE (User tokens)
• Sets the Company name suffix to PLAY
• Sets the multi-company name suffixes to PLAY

• Database Connection Settings