Database script

use <Target DatabaseName>
BEGIN TRANSACTION
...

SET IDENTITY_INSERT <table1> ON
INSERT INTO <table1>
(
id
,Column1
,Column2
,Column3
,Column4
,Column5
,Column6
,Column7
,Column8
,Column9
,Column10
,Column11
)
SELECT * FROM <Server>.<Old Database>.dbo.<table1>
SET IDENTITY_INSERT <table1> OFF

GO

INSERT INTO <table2>
(
Column1
,Column1
,Column2
,Column3
)
SELECT * FROM <Server>.<Old Database>.dbo.<table1>

GO
...

IF(@@error<>0)
    COMMIT TRANSACTION
ELSE
    ROLLBACK TRANSACTION