I tried with DTS. It accepts a SELECT query for table migration and it migrates the rows of the table based on the condition. It does not migrates the dependant tables based on the condition specified to the relationship table. I need to migrate all its(the table for which condition is set) dependant tables based on the condition.

MiraJ