Hi,
Trialing liquibase with Sybase ASE and generate-changelog doesn’t seem to be working. Looks like its using information_schema which sybase doesn’t support.
After I run
liquibase generate-changelog --changeLogFile=db-changelog.yaml --username=username --password=*********** --url=jdbc:sybase:Tds:127.0.0.1:8100/database1 --defaultSchemaName=dbo --include-schema=true --database-class=liquibase.database.core.SybaseDatabase
The error i get is
[2023-04-04 15:46:56] SEVERE [liquibase.integration] Error executing SQL select CONSTRAINT_NAME, COLUMN_LIST as COLUMN_NAME, constraint_schema as CONSTRAINT_CONTAINER from information_schema.constraints where constraint_type=‘UNIQUE’ and constraint_catalog=‘database1’ and constraint_schema=‘dbo’ and table_name=‘Reports’ and constraint_name=‘Re_8640030781’: information_schema.constraints not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
liquibase.exception.CommandExecutionException: liquibase.exception.DatabaseException: Error executing SQL select CONSTRAINT_NAME, COLUMN_LIST as COLUMN_NAME, constraint_schema as CONSTRAINT_CONTAINER from information_schema.constraints where constraint_type=‘UNIQUE’ and constraint_catalog=‘database1’ and constraint_schema=‘dbo’ and table_name=‘Reports’ and constraint_name=‘Re_8640030781’: information_schema.constraints not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).