Online Documentation for SQL Manager for DB2

Work with database objects offline

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

When creating a project you can create a new database or copy an existing one. 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. But all actions are performed offline.

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 Project Interaction Wizard. As a result of updating a database you get an 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.

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