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

Suggestions and Requests / Re: Issues with MySQL code generation
« on: August 30, 2006, 05:13:40 pm »
You can export/import datatypes as follows...

Tools | Export Reference Data...

and select "Model Data Types - Code and DDL".

Suggestions and Requests / Re: Issues with MySQL code generation
« on: August 30, 2006, 03:17:40 pm »
2. There's no way to specify the length of integers. Unfortunately I am a right awkward bugger because I like to work at int(10).

Add a new MySQL datatype...

INT - and give it length 10.

3. Also with integers, I have found no way of specifying them as unsigned.

Add a new MySQL datatype...


You can do this from Settings | Database Datatypes...



Datamodelling view support for SQL Server, Oracle and Sybase ASE will be available in version 6.5.

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