Difficulties in importing data from Oracle to SQLServer?

xiakeshu

Can I asks a question?
How to set a primary key or parameter in SQL Server to allow such primary key records to have the following records:

Primary key field a
'A000'
'A000'

Prompt duplicate primary key error.
But Oracle can. So oracle prompts duplicate primary key when importing data into SQLServer.

小老鹰

Use char () data type.

我是杀人狂

Convert to character type:

jimy2003

It doesn't work with char type

德鲁伊

not support!

德鲁伊

If lz wants to guide, I am afraid only to remove the primary key information