To All,
My test database has the same structure as my production database. I
want to copy just the data from the production database to the test
database. I am going to use the DB2MOVE command. My question is: will
the DB2MOVE command with the LOAD option take care of adhering to all
constraints (primary key, unique key, foreign key, and check)? And, do
I have to worry about triggers? Also, I know I will have to reset all
sequences.


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page