Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - hd

Pages: 1 [2] 3 4 ... 21
General Board / Re: Glossary Export?
« on: March 01, 2017, 07:38:46 am »
Ribbon > Start > Search > Search in Model.  Third icon after the Go arrow to get to the SQL Scratch Pad.

As well as replacing the square brackets with double quotes, CONCAT could also be the problem. Maybe ...
Code: [Select]
SELECT CONCAT(t_object.ea_guid, t_object.Name)or...
Code: [Select]
SELECT t_object.ea_guid || t_object.Nameor...
Code: [Select]
SELECT t_object.ea_guid, t_object.Name

General Board / Re: Upgrade to 13 with Postgres db
« on: December 07, 2016, 07:33:19 am »

Grant users ALTER permission on the t_image table...
Code: [Select]
GRANT ALTER ON [dbo].[t_image] TO <eauser>;
Image IDs are unique, t_image.ImageID is an IDENTITY column, and inserting an image into the t_image table therefore requires execution of SET IDENTITY_INSERT t_image ON/OFF, which requires ALTER permission on the table.

General Board / Re: Database Engineering
« on: October 06, 2016, 01:12:44 pm »
1. Is it possible to generate DDL without having a active database connection? How?

2. Can I import DDL into the Database Builder package?.

3. I am having problems creating views. Is there anyone that has blogged or written any instructions on how to do this? I am thinking drag-and-drop database classes from the repository and link them together graphically. Is that possible.

General Board / Re: Change pfK to PK column type.
« on: April 19, 2016, 07:50:12 am »
Is the column also part a foreign key? That's what pfk means.

Suggestions and Requests / Re: Alter Table (SQL DDL)
« on: December 19, 2004, 05:25:48 pm »
We are considering adding ALTER TABLE DDL generation in the future. An option to compare the existing data model with an ODBC source will be included - would that satisfy your needs?

Suggestions and Requests / Re: DDL to manage a changing schema
« on: August 30, 2006, 03:26:41 pm »
Unfortunately, it won't be available for 6.5. :(

As Michael pointed out, simple Alter is not viable if data is to be preserved. I think most users would want the alter DDL statements to preserve data in the target DB.

Also, there is referential integrity to consider, as well as dependent views and stored procedures. Do we do like SQL Server and simply warn that dependent objects may break, or do we parse all objects and make the appropriate changes?

Any comments would be welcomed.  :)

Suggestions and Requests / Re: DDL to manage a changing schema
« on: May 11, 2006, 03:23:41 pm »
Currently under development...  :)

Suggestions and Requests / Re: DDL to manage a changing schema
« on: February 01, 2006, 01:16:16 pm »
No update yet  :(

Suggestions and Requests / Re: DDL to manage a changing schema
« on: November 21, 2005, 01:43:44 pm »
There are plans in the pipeline to add such a feature.  :)

We envisage that when generating the DDL script, the user will have the option to generate an "ALTER" script instead.

EA will then connect to the target database through ODBC and make a comparison with existing objects and prompt the user to resolve any conflicts.

Any comments/suggestions would be appreciated.

Suggestions and Requests / Re: Support Repository on Firebird Database
« on: April 07, 2008, 08:24:20 am »
InterBase and Firebird are not supported repositories.

Suggestions and Requests / Re: EA Remote Repository for Oracle 9i
« on: March 23, 2006, 02:54:00 pm »
1. Oracle seed script.  The necessary sequences for the repository are not in your script that you direct people to.  I've put together a script that creates them and I'd be willing to post it here for inclusion in updated scripts.

There's no need for sequences in the script. The Data Model Transfer deletes and recreates them on the fly.

Pages: 1 [2] 3 4 ... 21