469,657 Members | 1,841 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,657 developers. It's quick & easy.

copying data from one database to another database

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
1 8242
"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.

Similar topics

reply views Thread by berwiki | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.