Emerald DB : migrate to MS-SQL7 (b3) (Anyone else evaluationg S

Peter A. Sang ( (no email) )
Sat, 12 Sep 1998 11:53:37 +0200

Just an example of what I've found during test migration:
There seem to be a change in constraint handling, please note that I already
saw the second error (cannot define ... on nullable column) during a DB
transfer between two 6.5 SP4 servers.
**************************
CREATE TABLE ServerAccess
(
ServerID int NOT NULL ,
Port int NULL FOREIGN KEY (ServerID, Port) REFERENCES
ServerPorts(ServerID, Port) ,
AccountType varchar(15) NOT NULL REFERENCES
AccountTypes(AccountType) CONSTRAINT pk_ServerAccess PRIMARY KEY (ServerID,
Port, AccountType),
StartTime int NULL DEFAULT (0) ,
StopTime int NULL DEFAULT (0) ,
MaxSessionLength int NULL DEFAULT (0)
)
GO
**************************
returns
**************************
Msg 8140, Level 16, State 0
More than one key specified in column level FOREIGN KEY constraint, table
'ServerAccess2'.
Msg 8111, Level 16, State 1
Cannot define PRIMARY KEY constraint on nullable column in table
'ServerAccess2'.
Msg 1750, Level 16, State 0
Could not create constraint. See previous errors.
**************************
Everything else seem to work fine, I'll continue testing with Radius /
Emerald 2.5 and keep you posted.

Mit freundlichem Gruss,

Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
* Microsoft Solution Provider - Internet/Intranet Specialist *