Messages

1

General Board / MySql Database Import

« on: October 03, 2006, 11:08:00 am »

I am becoming increasingly dissatisfied with EA's ability to import MySql database structures.  It consistently drops datatypes (timestamp, mediumtext, unsigned int, undoubtably others), and loses foreign key constraints.  Is there anything that can be done, on the user end, to improve this situation?

As an example, I created the following four tables and specified their relationships in EA, generated the ddl, created them in MySql, and then attempted to import those tables back into EA.  The results were almost unrecognizable:


CREATE TABLE table3_table2_table1_rel
(

mId INT UNSIGNED NOT NULL AUTO_INCREMENT,

table3_id INT UNSIGNED NOT NULL,

table2_id INT UNSIGNED NOT NULL,

table1_id INT UNSIGNED NOT NULL,

client_ip INTEGER NOT NULL,

user_agent VARCHAR(255) NOT NULL,

ts_created TIMESTAMP NOT NULL,

PRIMARY KEY (mId),

KEY (table1_id),

KEY (table2_id),

KEY (table3_id)
)
;


CREATE TABLE table3
(

table3_id INT UNSIGNED NOT NULL AUTO_INCREMENT,

flags TINYINT NOT NULL,

state TINYINT NOT NULL,

ts_created TIMESTAMP NOT NULL,

PRIMARY KEY (table3_id)
)
;


CREATE TABLE table2
(

table2_id INT UNSIGNED NOT NULL AUTO_INCREMENT,

label VARCHAR(50) NOT NULL,

cdata TEXT NOT NULL,

ts_created TIMESTAMP NOT NULL,

PRIMARY KEY (table2_id)
)
;


CREATE TABLE table1
(

table1_id INT UNSIGNED NOT NULL AUTO_INCREMENT,

flags TINYINT NOT NULL,

PRIMARY KEY (table1_id)
)
;





ALTER TABLE table3_table2_table1_rel ADD CONSTRAINT FK_table3_table2_table1_rel_table1

FOREIGN KEY (table1_id) REFERENCES table1 (table1_id)
;

ALTER TABLE table3_table2_table1_rel ADD CONSTRAINT FK_table3_table2_table1_rel_table2

FOREIGN KEY (table2_id) REFERENCES table2 (table2_id)
;

ALTER TABLE table3_table2_table1_rel ADD CONSTRAINT FK_table3_table2_Rel_table3

FOREIGN KEY (table3_id) REFERENCES table3 (table3_id)
;

2

General Board / Globally define datatype for MySql

« on: September 19, 2006, 04:18:59 pm »

I have figured out how to define missing data types (ex. ENUM, SET, INT UNSIGNED) on a per project basis, what I would like to do is define those globally, so that these data types would be available immediately when I start a new project.  Is this possible? If so, how? Inquiring minds want to know!

TIA
-Ian

3

General Board / Re: EA crash when importing from MySql

« on: June 20, 2005, 10:03:36 am »

This may be an issue with the local server. I set up a connection to the remote server that has the same database on it and it imported it without a hitch. *shrug*
-Ian

4

General Board / Re: EA crash when importing from MySql

« on: June 20, 2005, 09:55:35 am »

Updating to build 767 makes no difference to me. It still crashes out when import MySql databases.  Works fine for Sql Server, just not MySql.
-Ian

5

General Board / EA crash when importing from MySql

« on: June 19, 2005, 03:37:12 pm »

After  upgrading to EA 5 I am unable to import database structures from MySql.  The import will proceed part way and then EA crashes out.  Is there a known work around for this issue?

I'm using:
EA Version: 5.00.766 (Build 766)
MySql ODBC Driver 3.51
Windows 2000 professional sp3

TIA,
Ian

6

General Board / Re: RTF Documentation ugliness

« on: April 16, 2004, 10:42:44 am »

...
You can choose to switch off that frame somewhere in Options/Diagram (not sitting at my machine right now). There are two checkboxes: one for frame generation to clipboard copy and second for frame generation during writing the diagram to file. This second option *may* be relevant for the RTF generated diagram as well.

Thanks. That appears to have done the trick
-Ian

7

General Board / RTF Documentation ugliness

« on: April 15, 2004, 03:21:55 pm »

I have noticed something new about generated RTF docs from EA 4 that I dislike intensely (at least, I think it's new.... don't recall ever seeing it before).  All the diagrams are set inside a cheesy-looking, file-folder-like border.  Try as I might, I could not find an option to turn this feature off. Is it possible to eliminate this border? How?

Whacks with clue sticks will be appreciated.
-Ian

8

General Board / parameterized stored procedure

« on: May 01, 2003, 12:58:31 pm »

I've use EA to create simple sprocs like:

create procedure sp_mysproc
as

select * from mytable
;


but I've been unable to figure out how to create one that has parameters, for example:

create procedure sp_mysproc
(
  @input_param  varchar(12)
  @output_param varchar(50)   output
)

Select * from mytable
;


Anyone have any hints?
Thanks,
-Ian