Database

Overview

  • “Choose Database” is used for opening a different database file.

  • “Restructure database” attempts to reduce database file size.

  • “Create new database“ creates a new database with no data.

  • “Search in databases” opens a dialog for searching through multiple database files at once (see Database Search chapter).

When “One database per project” is active, “Choose Database” and “Create new database“ are equivalent to opening/creating project databases in the Project screen.

Database setup

OptiWin has two database setups. A single complete database and one database for each project. Here are the pros and cons for each type

One Complete Database

This is the old functionality. All your projects will be stored in one database, until you change your database. Each database you use will also have all the product information it needs. If you open/create a new database, the database must be updated will all product information before you can be used.

One Database For Each Project

This is the new functionality, and is selected by default.

Each project in the project list will have a unique database. Each database created in this mode will have no product data. The product data is stored in a local product database. When you want to select a product for your room the program will fetch all product information from the product database. When you have selected the product you want to use in your room, OptiWin will transport all data about the specific product from the product database to your current project. This will ensure that each project database will be much smaller than a normal database.

This will enable the possibility to store each project and files in a separate folder. The projects visible in the project list will be a history of the projects you worked with earlier. When you select a project in the project list, the program will automatically load the database.

 

When you create a new project, the database will by default have the same name as your project. When you save your database you will get the option to change both name and location.

 

Updating Products

It's easier to maintain your databases with this functionality. You never have to upgrade your project databases. All product updates from the web will be updated on your product database. This means you only have to update the product database once for each update. After a product database update, the program will automatically synchronize all changes for relevant products to your project database, when you enter a project.

Database Search

You can now search in multiple databases to find a specific project you are looking for. Navigate to Setup -> Database and you will find a new button "Search in databases".

The list "Database History" is previously opened databases. Anytime you open a database in Optiwin, the database name and path is stored in the history.

The list named "Database" is the selection of databases you want to search. You can add databases to this list in two ways:

  1. Click on the "Choose database" and select one or multiple databases.

  2. Or you can search in previously used databases by marking one or multiple "Database History" and use the arrow.

 

Now you list should have some databases to choose from in the "Database"-list. By selecting databases in this list, the list name "Projects" will be filled with all the projects in the databases you selected.

 

You can use the filter in the "Project"-list to search for a project. Select the project you want in the list and activate load this database by using the "Use selected database"-button. You can also go directly to the project page by using the "Go to project"-button.