1

I'm doing a reverse engineer of a MySQL database to pass it to a Sybase database.

When I generate the Database Script (for the Sybase database), it gives me errors because it only allows a 30 length object name. The thing is, with ASE 15.X versions, we can have object names with 250 tops.

Is it possible to change the object name length allowed?

aF.
  • 64,980
  • 43
  • 135
  • 198

1 Answers1

2

From the Docs:

The database package name and code length is limited by the maximum length specified in the DBMS definition and in the naming conventions of the model options.

Length is specified in the DBMS definition, which can be found at

OBJECT > DB Package > MaxLen

Open the DBMS editor, with Database > Edit Current DBMS Then under Script > Objects.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34
  • I've already saw this in the docs but I don't know where this menu is located. (where is OBJECT) ? – aF. May 20 '13 at 09:27
  • 1
    It's `MaxLen` without space. Open the DBMS editor, with `Database > Edit Current DBMS`; then under `Script > Objects`. For a ASE 15.0, I have 9 entries for `MaxLen` (all set to 255 in my version). – pascal May 20 '13 at 14:24
  • Thanks @pascal, I missed that. Updated my answer with the details. – Mike Gardner May 20 '13 at 14:31