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
16
Suggestions and Requests / Re: DDL to manage a changing schema
« on: May 11, 2006, 03:23:41 pm »
Currently under development...  :)

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

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

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

20
Suggestions and Requests / Re: EA Remote Repository for Oracle 9i
« on: March 23, 2006, 02:54:00 pm »
Quote
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.

21
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".

22
Suggestions and Requests / Re: Issues with MySQL code generation
« on: August 30, 2006, 03:17:40 pm »
Quote
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.

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

Add a new MySQL datatype...

UNSIGNED INTEGER

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

HTH...

Henk

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

24
No ETA yet  :(

25
 
Quote
It sure would be nice if the Data Modeling in EA supported Views natively with SQL DLL generation, etc.  Are there any plans for this feature?


Yes - but I don't have an ETA.

26
Suggestions and Requests / Re: Oracle 10G EE as EA repository
« on: June 14, 2006, 11:25:44 pm »
Yes - use the 9i scripts to create the tables.

27
EA can be used with SQL Server 2005 Express as a repository. We have not come across any problems as yet.

EA is also capable of reverse engineering SQL Server 2005 Express, although thorough testing has not yet been completed.


28
Suggestions and Requests / Re: Import DDL Schema from a sybase ase database
« on: February 01, 2006, 01:15:49 pm »
No update yet  :(

29
EA is not yet able to import from ASE 12.5, but it is in the pipeline. As yet we do not have a delivery date.

30
Suggestions and Requests / Re: DDL generation
« on: December 13, 2005, 01:59:25 pm »
Quote
1) how to include the 'ON DELETE CASCADE' clause of foreign key definition into generated DDL script for MS SQL Server?

Open Operation Properties (select the table and press F10). Highlight the FK operation and select the Extended Properties... button.

Quote
2) how to exlude the note text of an operation with stereotype <<trigger>>, to not appear in generated script?

Currently the note field is the trigger body. In the future the trigger body will be entered in the Initial Code field of the Behaviour tab, and the note field will become the trigger comment.

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