Messages

1

General Board / HierarchyID SQL Server 2008 data type DDL issue

« on: April 29, 2010, 08:42:55 am »

The new SQL Hierarchy data type in SQL 2008 is pretty cool but I have yet to discover how to set up an EA Table attribute to allow me to model the Hierarchy level, the node works since it is a datatype but the Level is a computed column.

Here is an example Create Table sql statement and the issue is how can I get EA to create the "lvl" attribute which is computed off the HierarchyID column im my DDL output?

Code: [Select]

CREATE TABLE dbo.Employees
(
  empid   INT NOT NULL,
  hid     HIERARCHYID NOT NULL,
  lvl AS hid.GetLevel() PERSISTED
  empname VARCHAR(25) NOT NULL,
  salary  MONEY       NOT NULL
)
Any help is much appreciated.

If anyone is interested in this new datatype, have a look at http://blogs.technet.com/andrew/pages/sql-server-2008-hierarchy-id-data-type.aspx for a good example.

2

General Board / Re: DDL generation for SQL - Schema other than dbo

« 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.

3

General Board / 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