Zurück
-
Titel
How to exclude the comment block header in the Script using CLI? -
Beschreibung
In ApexSQL Script, Is there a way to exclude the comment block header in the Script while using CLI (Command Line Interface) and if possible what is the parameter to be used in the CLI script?
-
Ursache
N/A -
Lösung
The comment block header in the script can be excluded using the below parameter,
/no_format_scr_header
Here is an example:
To include comment block :-
@echo off"C:\Program Files\ApexSQL\ApexSQL Script\ApexSQLScript.com" /server:"SGBSMSSSQL" /database:"AdventureWorks2016" /no_transaction_handling /no_scr_use_db /no_format_comments /no_format_prints /no_format_scr_header /script_header:"C:\Users\Administrator\Documents\ApexSQL\ApexSQL Script\Script_header_20210326_09-03-53.sql" /mode:structure /scr_ex_properties /output_type:sql /db_compatibility_level:"Sql2016" /encoding:Unicode /output_name:"C:\tempScript\ApexSQLScript\Script_20210326_09-03-45.sql" /create_file /inc:8:Employee /verbose /force@echo ApexSQL Script return code: %errorlevel%
To exclude comment block :-
@echo off"C:\Program Files\ApexSQL\ApexSQL Script\ApexSQLScript.com" /server:"SGBSMSSSQL" /database:"AdventureWorks2016" /no_transaction_handling /no_scr_use_db /no_format_comments /no_format_prints /mode:structure /scr_ex_properties /output_type:sql /db_compatibility_level:"Sql2016" /encoding:Unicode /output_name:"C:\tempScript\ApexSQLScript\Script_20210326_08-41-49.sql" /create_file /inc:8:Employee /verbose /force@echo ApexSQL Script return code: %errorlevel%