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
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.
» 
Comment and Contribute
