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] 5 6 ... 21
46
Suggestions and Requests / Re: Bug: Renamed FKs not generated
« on: November 19, 2003, 01:39:26 pm »
Thank you for your feedback. A fix to restrict the length of the foreign key name, generated by EA, to 30 chars for Oracle, should be in the next release (654) of EA.

47
General Board / Re: How to use WAN Optimizer?
« on: November 24, 2015, 07:33:56 am »
Project Transfer over a cloud connection is not possible.

48
General Board / Re: use of  sql queries save  into 'Queries' 'pack
« on: July 10, 2015, 07:34:14 am »
Look for the SQL Query object's SQL tagged value. Open the tagged Value Window or open the SQL Query object properties | Tags tab.

49
General Board / Re: Import DB schema, Oracle 12C
« on: April 01, 2015, 07:40:15 am »
Support for Oracle 12C database engineering was introduced in EA 11.0 Build 1107. You will need to upgrade to the current release.

52
General Board / Re: Windows 7 / 64 bit  and Oracle database Driver
« on: June 27, 2012, 07:51:24 am »
Oracle Drivers must be 32-bit. Try ODTwithODAC112021...
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
It works for me on 64-bit Windows 7.

53
General Board / Re: EA 9.3 database upgrade
« on: May 25, 2012, 08:21:27 am »
You only need to upgrade if your repository was created with a script downloaded prior to 10 Feb 2010.

http://www.sparxsystems.com.au/resources/corporate/index.html#sql_scripts

Quote
Also listed with each DBMS are update scripts, designed to improve performance on model repositories which were created using scripts downloaded prior to February 10, 2010. The update scripts add indexes to the database schema.

There is no change of structure, just additional indexes.

54
General Board / Re: Oracle comments from model notes
« on: May 03, 2012, 12:56:34 pm »
Put comments in the Notes field of the table and column.

Select Comment Level: All on the Generate DDL dialog.

55
General Board / Re: Oracle Autonum Trigger Code Template
« on: May 02, 2012, 07:53:16 am »
There are no templates for DDL generation. Submit a feature request.

56
General Board / Re: Generating a data model from DDL
« on: March 27, 2012, 12:46:51 pm »
You cannot import a database schema from a DDL script.

You can import a database schema from a live database via ODBC...

http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/database_engineering/importdatabaseschemafromod.html

57
General Board / Re: Refresh project
« on: March 23, 2012, 08:00:02 am »
File | Reload Current Project.

58
General Board / Re: Data Model Question. Help
« on: March 16, 2012, 11:42:23 am »
Package context menu | Code Engineering | Reset DBMS Options...

59
General Board / Re: Error in loading Model from DBMS-sql server
« on: March 23, 2012, 07:57:29 am »
Correct. Each project transfer will blow away the existing SQL Server repository.

60
General Board / Re: Serial Data Type PostgreSQL
« on: March 22, 2012, 11:15:31 am »
Add the serial and bigserial data types to the PostgreSQL data types.

Settings -> Database Datatypes...

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