If you run the test case described by ADS #14901 on Sybase ASE, and then execute the script generated by Script Generator, you will see the generated script won't execute. This is because some SET commands have been executed in the original script that was used to create test objects, and the script generated by Script Generator does not script these SET commands which are required in order to get the generated script executed correctly.
In Schema Synchronization, we always generate the following SET commands before deployment script:
SET ANSINULL ON
SET ARITHABORT ON
SET ARITHIGNORE OFF
SET STRING_RTRUNCATION OFF
but above settings do not work for the case described by ADS #14901 which requires the following settings:
SET ANSINULL ON
SET ARITHABORT ON
SET ARITHIGNORE OFF
SET STRING_RTRUNCATION ON
Perhaps we should always generate above SET commands for Sybase ASE in Script Generator, similar to Schema Synchronization.
Some other servers supported by Schema Synchronization also script SET commands before the deployment script.
Issue #15425 |
New |
Completion |
No due date |
No fixed build |
No time estimate |