SQL Record Transfer from one db to another instance having same table structure
You can use SET IDENTITY_INSERT my_table ON before performing the insertion of the data in you local table and on finish use SET IDENTITY_INSERT my_table OFF and your column will take the following value.

Example:

SET IDENTITY_INSERT [dbo].[table] ON

GO

INSERT INTO [dbo].[table] ([CustomerID] ,[FirstName]) VALUES (1 ,'qqq');

INSERT INTO [dbo].[table] ([CustomerID] ,[FirstName]) VALUES (2 ,'eee');

SET IDENTITY_INSERT [dbo].[table] OFF