Online Documentation for SQL Manager for DB2

Offline work with database


SQL Manager for DB2 allows you to perform actions on your database offline. This can be done by means of Projects which may be considered as virtual databases that do not require connection to the server.

You can create an empty project as well as a project based on the existing database. The latter means that you can copy all objects from the database or you can choose only objects you need.

After the project is created you can work with it as if it was a real database: create, edit or drop schemas, create and drop tables, views, functions etc, undo and redo actions.

 

Offline work with database - Edit project objects

 

 

All your projects are situated in the Projects tab in the Object Inspector.

Existing projects can be updated with a database. In this case new or modified objects from a database are copied to the project. Vice versa you can create database from a saved project or alter a database with a project.

 

The process of creating and updating a project is executed by means of the Project Interaction Wizard. As a result of updating a database you get a SQL script showing differences between database and projects. This script can be executed, loaded to the SQL Script Editor or saved to an *.sql file.

 

Like databases projects can be compared with each other or with databases by means of Compare Databases Wizard. After comparing is completed one project can be transformed into another project or database.

 

Offline work with database - Compare projects

 

 

You can use Visual Database Designer to work with a project.

 

Offline work with database - Project in VDBD

 

 

Creating reports tool is also available for projects. You can generate and print metadata reports of any project object(s). HTML Report Wizard that generates a detailed HTML report of the selected project objects is also accessible. Just select existing project from the drop-down list in the Source database field.

 

Offline work with database - Create HTML report for a project