Creating a Migration Robot in Kapow Design Studio – Part 2 of 5


Adding a Database to the Project

First add a new database by right-clicking on “Databases” in the “Databases” window in the bottom left of the Design Studio workspace.

clip_image001

A new “Settings” dialog box appears. Click on the “Database Connections” tab.

clip_image002

Click on the “+” symbol in the bottom left of the dialog box.

clip_image003

An “(Unnamed)” entry appears in the list.

clip_image004

Fill in the database properties for “(Unnamed)” so that it matches what I have for “Development Database”.

clip_image006

Click on [Test Connection]. The test should complete successfully. Click [OK] to close the “Test Result” message box.

clip_image007

Click [OK] to close the “Settings” dialog box.

Right-click on the “Development Database in the Databases window and click on the Add to Project \ Lotus Notes Sandbox Migration option.

clip_image008

The “Add Database Mapping to Project” dialog box opens. Click [OK] to continue.

clip_image009

The “objectdb.db (Development Database)” now appears as part of the project.

clip_image010

Adding a Table to the Database Based on the Type

Make sure that your database is running. Check that the green arrow is beside your database. If not, you will need to start the Local Development Database.

clip_image011

Select the project in the project window and click on Tools \ Create Database Table.

clip_image012

Select the objectDB database and the SandBoxDoc type.

Check Add Drop table if you want Design Studio to drop the table if it already exists.

clip_image013

Click [Generate SQL] if you want to create the new table. Click [Execute] to run the SQL.

clip_image014

Click [Close] to close the “Create Database Table” dialog box.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s