Book a Demo

Author Topic: SqlServer 2012 Schema support  (Read 4392 times)

hugelsb

  • EA User
  • **
  • Posts: 20
  • Karma: +0/-0
  • Modelling is the future!
    • View Profile
SqlServer 2012 Schema support
« on: February 26, 2019, 03:44:20 am »
Does someone managed that the DDL Builder (version 14.1) generates valid DDL with schema support for SqlServer 2012?
Even setting the "Tablespace" Tagged Value (to "ana") does not change anything. The DDL statements doesn’t change (e.g.:
current result:
Code: [Select]
CREATE TABLE [SixidLogfile]should be:
Code: [Select]
CREATE TABLE [ana].[SixidLogfile]
Thanks for any hint!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: SqlServer 2012 Schema support
« Reply #1 on: February 26, 2019, 04:10:15 am »
You might need to change the DDL code generation template yourself.

Geert

ea0818

  • EA Novice
  • *
  • Posts: 8
  • Karma: +1/-0
    • View Profile
Re: SqlServer 2012 Schema support
« Reply #2 on: February 26, 2019, 04:23:26 am »
To have the script include the schema owner / db owner:  On the Tags tab, set OWNER to required value, not Tablespace

hugelsb

  • EA User
  • **
  • Posts: 20
  • Karma: +0/-0
  • Modelling is the future!
    • View Profile
Re: SqlServer 2012 Schema support
« Reply #3 on: February 26, 2019, 08:18:00 pm »
Hi ea0818
Thanks a lot for the solution!
Is there any documentation about this or I have to analyze the DDL templates?