I have been moving over the data from one database to another. Issue came when data was entering in a table where idetity of a column was enable and I needed to enter the data as it is in identity column. I found solution.

SET IDENTITY_INSERT tablename ON

insert statement comes here

SET IDENTITY_INSERT tablename OFF