sql server 导出数据 表自增列 问题处理

[size=large][color=red]当数据库表中有自增列时，由一个数据库向另一个数据库导出数据时会出现如下报错信息：[/color][/size]

[img]http://dl.iteye.com/upload/attachment/266039/bb34764d-f37b-3dee-9cd5-ad1ad0f17512.png[/img]

[color=green][size=large]一、sql2008中的处理，到此步骤时，点击【编辑映射】：[/size][/color]

[img]http://dl.iteye.com/upload/attachment/266041/d1339a22-c894-3566-96e1-f2b4947420ed.png[/img]

[color=green][size=large]勾选【启用标识插入】[/size][/color]

[img]http://dl.iteye.com/upload/attachment/266043/78ce748c-aef3-389d-b851-b2a290381909.png[/img]

[color=green][size=large]二、sql2005中的处理，到此步骤时，点击【编辑】：[/size][/color]


[img]http://dl.iteye.com/upload/attachment/266045/93cf7af0-28d2-3285-b3db-1693005bb60b.png[/img]

[color=green][size=large]勾选【启用标识插入】[/size][/color]

[img]http://dl.iteye.com/upload/attachment/266047/04e1cc65-429a-3917-82c0-ead59f23045f.png[/img]


[color=green][size=large]三、sql2000中的处理，到此步骤时，点击转换--【...】：[/size][/color]

[img]http://dl.iteye.com/upload/attachment/266049/28a737d0-f2ad-39c9-a24e-78d65c198f2b.png[/img]


[color=green][size=large]勾选【启用标识插入】[/size][/color]

[img]http://dl.iteye.com/upload/attachment/266051/40589f12-efb3-3032-8906-fc20e2fc7e37.png[/img]


[color=red][size=large]主要作用点在于勾选【启用标识插入】，只不过版本不同选择进入此步的入口不同。[/size][/color]