× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
funfun reported 2017-08-05T03:10:44Z  · nhilam last modified 2018-03-14T05:23:16Z

Script Generator: Provide SET commands before the generated script


PM
Dev
QA
Priority Low
Complexity Unknown
Component Tools - Schema Script Gen
Version Future

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

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017