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

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

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

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

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

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

54
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

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

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

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

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

59
General Board / Re: How to reverse-engineer DB schema from SQL Ser
« on: January 30, 2012, 12:37:16 pm »
Yes. The import takes care of the graphics. Just import into a class diagram.

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

60
General Board / Re: Oracle 11G as repository
« on: January 24, 2012, 08:37:00 am »
Oracle 11g is supported as an EA repository.

Report any problems to Sparx using the Report a Bug link below.

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