Error Import SQL database double Primary keys


Author
Message
Donovan Sobrero
Donovan Sobrero
StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)StrataFrame Novice (51 reputation)
Group: Forum Members
Posts: 17, Visits: 78
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 Sick. It seems to be a bug in the import tool. I am still using v1.6.0 w00t
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Donovan Sobrero - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Trent L. Taylor - 16 Years Ago
                         I have attached our test DB for you to test with.
Donovan Sobrero - 16 Years Ago
Dustin Taylor - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Dustin Taylor - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Dustin Taylor - 16 Years Ago
Dustin Taylor - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Donovan Sobrero - 16 Years Ago
Trent L. Taylor - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search