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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

DB2

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:

C:\CaptureWizPictures\2008-03-23_14-30-32-091.png

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

Trademarks

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.

 

Disclaimers

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.