thanks beeb...
I am able to migrate the data after deleting data through delete statement rather than using Truncate statement
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/