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

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

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

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

50
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

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

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

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

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

55
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

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

57
General Board / Re: sqlserver 2008 support
« on: January 06, 2012, 01:38:21 pm »
Quote
We need to connect to a SQLServer 2008 instance to reverse engineer from database schema to UML data model.

Supported - use SQL Native Client for the ODBC driver.

58
General Board / Re: sqlserver 2008 support
« on: January 06, 2012, 07:59:49 am »
SQL Server 2008 repository is supported...
http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts

NB: The update patch is only for existing repositories created prior to 10 Feb 2010.

59
General Board / Re: Default database for new DDL tables
« on: January 03, 2012, 07:59:15 am »
You can set a default database at Tools | Options | Code Editors | Default Database

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

60
General Board / Re: Oracle 10g ODBC Connection
« on: January 03, 2012, 07:53:47 am »
I use ODTwithODAC1110720 - works perfectly...
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

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