Book a Demo

Author Topic: Strange characters in generated DDL  (Read 3921 times)

ErikvanD

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Strange characters in generated DDL
« on: November 05, 2019, 09:30:28 pm »
Hi all,

My databasemodel has a pre statement query. In EA SQL Scratch pad it looks just fine but when the DDL is generated it places some extra characters on the first line preventing the DDL to run on my database engine. The characters are "!!||,"

Fragment of the  _PreStatements query in SQL Scratch pad:

Code: [Select]
---------------------------------------------------------------------------------------------------------
-- Auteur : Erik van Dongen
-- Datum : 25-10-2019
-- Betreft : PRE-DEPLOYMENTSCRIPT: aanmaken objecten die niet in EA zitten
-- Hoe? : Via opname in het _PreStatements sql script
---------------------------------------------------------------------------------------------------------

-- Aanmaken schema's (ZIT NIET IN EA!)
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name='BAG')
BEGIN
EXEC ('CREATE SCHEMA [BAG]');
END

Fragment of the generated DDL for my database:

Code: [Select]
/* ---------------------------------------------------- */
/*  Generated by Enterprise Architect Version 15.0 */
/*  Created On : 05-nov-2019 10:36:33 */
/*  DBMS       : SQL Server 2012 */
/* ---------------------------------------------------- */

/* Pre Statements */

!!||,---------------------------------------------------------------------------------------------------------

-- Auteur : Erik van Dongen
-- Datum : 25-10-2019
-- Betreft : PRE-DEPLOYMENTSCRIPT: aanmaken objecten die niet in EA zitten
-- Hoe? : Via opname in het _PreStatements sql script
---------------------------------------------------------------------------------------------------------

-- Aanmaken schema's (ZIT NIET IN EA!)
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name='BAG')
BEGIN
EXEC ('CREATE SCHEMA [BAG]');
END

Has anyone experienced the same bug? And found a solution? It's not a showstopper of course, but it's annoying all the same...

Thanks!

Erik