Here are my tables:
CREATE TABLE TestCustomer
(
CustomerID INTEGER IDENTITY CONSTRAINT IX_TestCustomer_00 PRIMARY KEY CLUSTERED,
CustomerCode VARCHAR(10),
CustomerName VARCHAR(100),
Active CHAR(1)
)
GO
CREATE UNIQUE INDEX IX_Customer_01 ON TestCustomer(CustomerCode,CustomerID)
go
CREATE TABLE TestCustomer1
(
CustomerID INTEGER IDENTITY CONSTRAINT IX_TestCustomer1_00 PRIMARY KEY CLUSTERED,
CustomerCode VARCHAR(10),
CustomerName VARCHAR(100),
Active CHAR(1)
)
GO
CREATE UNIQUE INDEX IX_Customer_01 ON TestCustomer1(CustomerCode)
After I import the tables I get more than one primary key
. It seems to be a bug in the import tool. I am still using v1.6.0