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

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

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

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

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

51
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

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

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

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

55
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

56
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

57
General Board / Re: Oracle 10g ODBC Connection
« on: December 20, 2011, 07:57:49 am »
I believe you should be using Oracle's ODBC driver, not Microsoft's. See Notes at bottom of this page...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/database_engineering/importdatabaseschemafromod.html

58
General Board / Re: Generate DDL
« on: October 28, 2011, 08:09:38 am »
  • To generate DDL for a single table, right-click the table on your diagram and select Generate DDL.
  • To generate DDL for a package, right-click the package in the Project Browser and select Code Engineering | Generate DDL.

59
General Board / Re: Enterprise Architect runs very slowly
« on: January 12, 2011, 08:21:29 am »
Could be a compatibility problem.

In the properties dialog of EA.exe in the EA install folder (C:\Program Files (x86)\Sparx Systems\EA), select the Compatibility tab and uncheck "Run this program in compatibility mode for:". You might also check this for the EA shortcuts.

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