Products
Enterprise Architect
What is new in v16.0
What was new in v15.2
What was new in v15.1
What was new in v15
Overview
Professional
Corporate
Unified
Ultimate
Compare Editions
Free Trial
Registered Downloads
Additional Info
30 Minute Tour
Release History
License Info
Floating Licenses
Academic Pricing
System Requirements
EULA
MDG Extensions
3rd Party Extensions
Pro Cloud Server
What is new in v5.0
What was new in v4.2
What was new in v4.1
What was new in v4
Overview
WebEA
Integrations
Floating License Server
Compare Editions
Free Trial
Downloads
Additional Info
30 Minute Tour
Release History
System Requirements
EULA
Prolaborate
What's new in 3.6
Overview
Introduction
Resources
Articles
Documentation
Release Notes
FAQ
Events
Videos
Free Trial
Downloads
Additional Info
Request a Demo
Proof of Concept
Prolaborate SaaS
EULA
System Requirements
Pricing
Enterprise Architect
Pro Cloud Server
Prolaborate
Support
Forum
User Guide / Help
Contact Us
Bug Report
Request a Feature
Change Your Email
Priority Bug Report
Email Support
Email Sales
FAQ
Support
Sales
Company Details
News Room
Resellers
Africa
Asia
Europe
Middle East
North America
Oceania
South America
Sparx Services
North America
Australia
Central Europe
Middle East
United Kingdom
Sisters Companies
Argentina
China
Central Europe
Middle East
India
Japan
Trainers/Consultants
Africa
North America
South America
Asia
Europe
Oceania
Middle East
Online
Resources
Video & Webinars
Demo Videos
Upcoming Webinars
Webinars Library
Sign Up
PDF Library
Fundamentals
Modeling
Collaboration
Publishing
Simulation
Project Management
View Entire Library
Other
Whitepapers
Tutorials
Case Studies
Learning Center
Diagram Gallery
Brochures
Registered Users
Enterprise Architect
Pro Cloud Server
All Users
Free Downloads
DBMS Repository Scripts
User Security Key
All Resources >
UML Tutorial
Community
Download Now
Enterprise Architect
Pro Cloud Server
Prolaborate
Login
Sparx Systems Forum
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Enterprise Architect 16.0
Pro Cloud Server 5.0
Home
Help
Search
Login
Register
Sparx Systems Forum
»
Enterprise Architect
»
General Board
»
DDL generation for SQL - Schema other than dbo?
« previous
next »
Print
Pages: [
1
]
Author
Topic: DDL generation for SQL - Schema other than dbo? (Read 1742 times)
Eamesy
EA Novice
Posts: 3
Karma: +0/-0
DDL generation for SQL - Schema other than dbo?
«
on:
March 25, 2010, 07:50:51 am »
I am using SQL 2008 and using EA to maintain and script a new data model using DDL script generator. The script it creates always has extented properties of "dbo" as the schema owner whereas I want to reflect a custom schema owner like the package name. This way the SQL script generates creates tables like "Security.User" rather than "dbo.User" in my db
Can't see this anywhere in Help....
Any suggestions?
Thanks
Logged
hd
EA Administrator
EA User
Posts: 312
Karma: +0/-0
Re: DDL generation for SQL - Schema other than dbo
«
Reply #1 on:
March 25, 2010, 07:56:12 am »
EA should generate a schema other than dbo, if you add the owner tagged value to the table.
http://www.sparxsystems.com/uml_tool_guide/data_modeling/settableowner.html
If it doesn't, I suggest you submit a bug report using the link below.
Logged
pocketom
EA User
Posts: 97
Karma: +0/-0
Re: DDL generation for SQL - Schema other than dbo
«
Reply #2 on:
March 26, 2010, 03:02:33 am »
Thanx, works fine! Perhaps EA should offer a standard field somewhere (e.g. in tab Table Detail beside 'Table Space'...). Would it make easier to find.
Logged
Eamesy
EA Novice
Posts: 3
Karma: +0/-0
Re: DDL generation for SQL - Schema other than dbo
«
Reply #3 on:
March 26, 2010, 08:17:13 am »
Thanks HD, works for me too, I agree with Pocketom's comments. At least add it in the help file index somewhere! Hope others find this helpful.
Logged
RoyC
EA Administrator
EA Practitioner
Posts: 1297
Karma: +21/-4
Read The Help!
Re: DDL generation for SQL - Schema other than dbo
«
Reply #4 on:
March 26, 2010, 08:57:15 am »
I have added permutations of 'Schema Owner' to the index entries for that topic. The changes should be visible in the Help for the next release of EA.
Logged
Best Regards, Roy
Print
Pages: [
1
]
« previous
next »
Sparx Systems Forum
»
Enterprise Architect
»
General Board
»
DDL generation for SQL - Schema other than dbo?