Data type Bigint

[Peter Bjernetun]

Hi,

I have developed a database model within Visio and from
this model I have generated a database script for creating
a database in Microsoft SQL.

This works fine, but now I need to convert some of my
columns from data type "int" into data type "bigint".
I do however not find any possibility to configure my
columns as "bigint" and if I am trying to create my own
data type named "bigint" the database creation fails.

Does anyone have any suggestion for how to work with data
type "bigint" in Visio?

Regards

Peter

 

[Scot Becker]

This works fine, but now I need to convert some of my

columns from data type "int" into data type "bigint".
I do however not find any possibility to configure my
columns as "bigint" and if I am trying to create my own
data type named "bigint" the database creation fails.

The default driver for SQL server is, for some reason, 7.0, which does not
support the bigint type. You'll need to first configure the driver options
to 2000, and then you should be able to use that type.

Hope that helps,
Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com