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 ... 21
1
General Board / Re: Reverse Engineering a MySql db (RDS on AWS)
« on: January 17, 2018, 12:42:33 pm »
Are you using the 32-bit MySQL ODB Driver?  See the first Note at the bottom of page...

http://www.sparxsystems.com/enterprise_architect_user_guide/13.5/model_domains/importdatabaseschemafromod.html

4
Diagram Properties | Elements | Show Compartments - disable Attributes.

5
General Board / Re: Database Builder: More than on connection
« on: June 09, 2017, 07:36:02 am »
No.  The Database Builder can only compare an EA data model with a live database...
http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_domains/import_schema_into_builder.html

6
Maybe you are using a 64-bit Oracle client.  EA only works with 32-bit clients.

7
General Board / Re: int, identity column
« on: March 29, 2017, 07:43:53 am »
Select your table in the Database Builder, select your identity column, set AutoNum to true in column properties list at lower left.

9
General Board / Re: Glossary Export?
« on: March 01, 2017, 07:38:46 am »
Ribbon > Start > Search > Search in Model.  Third icon after the Go arrow to get to the SQL Scratch Pad.

10
As well as replacing the square brackets with double quotes, CONCAT could also be the problem. Maybe ...
Code: [Select]
SELECT CONCAT(t_object.ea_guid, t_object.Name)or...
Code: [Select]
SELECT t_object.ea_guid || t_object.Nameor...
Code: [Select]
SELECT t_object.ea_guid, t_object.Name

11
General Board / Re: Upgrade to 13 with Postgres db
« on: December 07, 2016, 07:33:19 am »
Yes.

12
Grant users ALTER permission on the t_image table...
Code: [Select]
GRANT ALTER ON [dbo].[t_image] TO <eauser>;
Image IDs are unique, t_image.ImageID is an IDENTITY column, and inserting an image into the t_image table therefore requires execution of SET IDENTITY_INSERT t_image ON/OFF, which requires ALTER permission on the table.

13
General Board / Re: Database Engineering
« on: October 06, 2016, 01:12:44 pm »
Quote
1. Is it possible to generate DDL without having a active database connection? How?
Yes.  http://sparxsystems.com/enterprise_architect_user_guide/12.1/database_engineering/ddl_generation.html

Quote
2. Can I import DDL into the Database Builder package?.
No.

Quote
3. I am having problems creating views. Is there anyone that has blogged or written any instructions on how to do this? I am thinking drag-and-drop database classes from the repository and link them together graphically. Is that possible.
http://sparxsystems.com/enterprise_architect_user_guide/12.1/database_engineering/views.html

15
General Board / Re: Change pfK to PK column type.
« on: April 19, 2016, 07:50:12 am »
Is the column also part a foreign key? That's what pfk means.

Pages: [1] 2 3 ... 21