Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted May 19, 2008

DB2 9.5 and IBM Data Studio - Part 10: Building Stored Procedures - Page 3

By Paul Zikopoulos

Addendum: Moving data development projects between different workstations

It’s easy to move projects to different workstations or installations if you ever install a different copy of the IBM Data Studio IDE on your workstation or engage the services of other personnel to work with you on your projects. To export a project from a workstation, perform the following steps:

1.   Select the project you want to export (for our example, DatabaseJournalProject), right-click, and select Export. For example:

2.   Select File System and click Next:


If you don’t see the File System folder in the default expanded tree view, you might have to expand the Other folder to find this option.

3.   Select the data development project that you want to export from the left side of the File system page of the Export wizard, and in the right pane optionally select the components of the project that you want to export. For example, on the following page I’ve only chosen to export the FEMALEPERSONNEL SQL statement along with the project’s metadata:

4.   Type a target directory for the project in the To directory field.

5.   Select any options that you want to apply to this export operation in the Options box. For this example, the defaults are fine; click Finish.

To import your exported project into a new data development project, perform the following steps:

1.   Select the destination project, right-click, and select the Import option. (You can see in the following figure that I’ve created a new data development project with the same name as the previous one.)

2.   Select File System and click Next:

3.   The Import wizard opens. Select the project in the left pane of the File system page and the components of this project that you want to import into the new data development project. For this example, select everything in the import file as shown below, and then click Finish.

As you can see, the elements have been imported into the Data Project Explorer view in the data development project that you specified:

Note that if you imported a stored procedure or a user-defined function into your new data development project, these objects aren’t created in the database that the new project is linked to (assuming it’s a different database). You’d have to deploy these objects. In this example, all my data development projects connect to the SAMPLE database, so I wouldn’t have to rebuild any routines if I had them in this imported project.

» See All Articles by Columnist Paul C. Zikopoulos


IBM, DB2, and z/OS are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.

Other company, product, or service names may be trademarks or service marks of others.

Copyright International Business Machines Corporation, 2008.



The opinions, solutions, and advice in this article are from the author’s experiences and are not intended to represent official communication from IBM or an endorsement of any products listed within. Neither the author nor IBM is liable for any of the contents in this article. The accuracy of the information in this article is based on the author’s knowledge at the time of writing.

DB2 Archives