Babelfish supported Cleaned DDL version of database DDL file

[amuja]

Hi,

Can we have compass to produce the supported version on DDL file as it accepts the input DDL file to produce the comptability output for the database, can this be further enhanced upon to convert the compatibility to actually DDL file for supported DDL's so customers can simply take this file and run against BBF endpoint rather having to do this manually by themselves.

Regards,
Asif

[brtrvn]

Babelfish Compass is designed as a compatibility assessment tool (hence the name COMPatibility ASSessment) not as a conversion tool. I will let the core maintainers comment on whether this feature request matches the roadmap and overall purpose for Babelfish Compass in the future.

[robverschoor]

Actually the next version of Compass (v.1.2) will provide a feature to rewrite certain statements and constructs which Babelfish does not support, with statements/constructs that are supported. This way, we can provide some mitigation to users while Babelfish itself is not yet fully there in some cases.
Constructs eligible for rewriting currently include: MERGE statement' ALTER TABLE..ADD for multiple items; WAITFOR DELAY; numeric DATETIME representation; and some selected builtin/ODBC functions.

As for the request above: there may be a better way to avoid raising unnecessary errors (like for ALTER DATABASE) by using the already existing 'escape hatch' mechanism in Babelfish.