You have two choices:If you want to keep the same ID's, do the following:SET IDENTITY_INSERT pricing_new ONINSERT INTO pricing_new (ID,FK_PRODUCT_ID,FK_TYPE_ID,FK_SUBTYPE_ID,COST,color_type)SELECT ID,FK_PRODUCT_ID,FK_TYPE_ID,FK_SUBTYPE_ID,COST,color_typeFROM database1.dbo.pricing_new
If you want to automatically assign new id values in the pricing_new table, do thisINSERT INTO pricing_new (FK_PRODUCT_ID,FK_TYPE_ID,FK_SUBTYPE_ID,COST,color_type)SELECT FK_PRODUCT_ID,FK_TYPE_ID,FK_SUBTYPE_ID,COST,color_typeFROM database1.dbo.pricing_new
In either case, you have to explicitly list the columns.