Nullability difference in Table creation:
While creating table in
Sybase, default nullability of the column is Not null.But in server
server the default nullability of the column is Null. That means if
the developer did not specify the nullability of the column while
creating table,sybase defines the column as Not Nullable and SQL
Server defines the column as Nullable.
You can see the example
for the default nullability value in the right side of the screenshot
for the corresponding database.
Sybase:
SQL Server:
While migrating ‘create
table statement’, we should give the NOT NULL for the columns
doesn’t have nullability in the column definition.
Please click here to know about sybase to sql server migration issues
Please click here to know about sybase to sql server migration issues
No comments:
Post a Comment