By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

copying data from one database to another database

P: n/a
I want to copy data from our production database to the development
database. I want to move only the data. I do not need the table structure,
constrains or anything else.

I think I can use the db2move command to export out all the data like the
following:

db2move dbname export -tc schema1
When I load the data into our development database, will it recreate the
tables? My problem is that I do not want to recreate the structure. I want
to make sure that I am copying over only the data.

Is db2move the best utility to move the data between two databases without
making any structure changes to the target database?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Jani Tamminen" <jt*******@qwest.net> wrote in message news:<pG*****************@news.uswest.net>...
I want to copy data from our production database to the development
database. I want to move only the data. I do not need the table structure,
constrains or anything else.

I think I can use the db2move command to export out all the data like the
following:

db2move dbname export -tc schema1
When I load the data into our development database, will it recreate the
tables? My problem is that I do not want to recreate the structure. I want
to make sure that I am copying over only the data.

Is db2move the best utility to move the data between two databases without
making any structure changes to the target database?


db2move is an excellent choice for moving data from one database to
another. db2move 'import' will not create the tables unless you
specifically ask it to do so. If you specify the option '-io
replace_create' then you will get new tables created. Check the
command reference manual for more information.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.