Messages

1

Bugs and Issues / Re: EA 14 Import DB fails

« on: June 23, 2018, 03:03:08 am »

BTW, I chose Differences under Database Builder and it failed with the same error. In the Differences with Options dialog there is no Sequences option to turn off.

You guys have to do some analysis and identify all the spots where sequences are queried and turned them off for those RDBMSes that don't have sequences. Otherwise it is a mickey mouse functionality.

2

Bugs and Issues / Re: Saving long urls

« on: June 23, 2018, 02:52:02 am »

These are intranet links. Can I used them with such a service?

3

Bugs and Issues / Re: EA 14 Import DB fails

« on: June 23, 2018, 02:50:28 am »

Yes, this worked. Perhaps sequences should be set to false for SQL Server?

4

General Board / Mind map connectors

« on: June 21, 2018, 07:52:12 am »

Hi,

I created a mind map and I noticed that when I move the topics I created, the connectors are not re-arranged optimally. It is a bit hard to explain in words. Let's say I have Topic 1 above Topic 2 and I connect them with a connector. Everything looks fine. But as soon as I move Topic 2 above Topic 1 the connector moves the connection point with Topic2 properly  (i.e. it is on the bottom edge of Topic 2 rectangle), but the connection with Topic 1 also remains on the bottom edge of Topic 1, so the connector crosses the Topic 1 rectangle. In my minde the connector's connection point with Topic 1 should have been moved to the top edge of Topic 1.

As such, I find myself spending too much time (imo) re-arranging connectors to look pretty. Also the bezier connectors start having these weird shapes instead of becoming shorter.

Is there a way to tell EA to optimize this connectors positioning (i.e. use the shortest path between two topics)?

Thanks

5

Bugs and Issues / Re: EA 14 Import DB fails

« on: June 21, 2018, 07:09:43 am »

I ran a trace and the last query that is executed and which fails in SQL Server 2008 R2 is:

Code: [Select]

Select seq.SEQUENCE_SCHEMA, seq.SEQUENCE_NAME, ISNULL(com.value,'') As remarks,
   ('CREATE SEQUENCE ' + seq.SEQUENCE_SCHEMA  + '.' + seq.SEQUENCE_NAME + CHAR(13) + CHAR(10) +     ' AS ' + seq.DATA_TYPE + CHAR(13) + CHAR(10) +     ' START WITH ' + CONVERT("nvarchar", seq.START_VALUE) + CHAR(13) + CHAR(10) +     ' INCREMENT BY ' + CONVERT("nvarchar", seq.INCREMENT) + CHAR(13) + CHAR(10) +     ' MINVALUE ' + CONVERT("nvarchar", seq.MINIMUM_VALUE) + CHAR(13) + CHAR(10) +     ' MAXVALUE ' + CONVERT("nvarchar", seq.MAXIMUM_VALUE) + CHAR(13) + CHAR(10) + CASE WHEN seq.CYCLE_OPTION = 1 THEN ' CYCLE ' ELSE ' NO CYCLE ' END ) As seq_definition
From INFORMATION_SCHEMA.SEQUENCES seq, (select id, [name] from sys.sysobjects where name like 'seq%') sysseq
Left JOIN ( SELECT major_id, [value] From sys.extended_properties Where name = 'MS_Description' and minor_id = 0 ) com
    ON  ( sysseq.id = com.major_id )
Where seq.SEQUENCE_NAME = sysseq.[name]
And sequence_schema IN ('dbo')
and sequence_schema not in ('','INFORMATION_SCHEMA','sys')

There is no INFORMATION_SCHEMA.SEQUENCES view. I don't have SQL server 2014 or 2016 server to see if the view works but if you go to https://docs.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/system-information-schema-views-transact-sql?view=sql-server-2017 there is no SEQUENCES view.

So, this looks to me clearly that it's a bug. Please fix it.

Just to make sure there is no confusion, the model I want to import into is a Basic SQL Server 2008 Model.

6

Bugs and Issues / Saving long urls

« on: June 21, 2018, 06:58:47 am »

I created a mind map and I wanted to associate some http urls pointing to OneNote files stored in SharePoint. I selected Type = Web Address but when I try to save I get the message below. The url has 318 characters. You should allow for up to 512 or 1024 chars .

DAO.Field [3163]
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

If I try to paste less data the url won't work. The suggestion is dumb.

Thanks

7

Bugs and Issues / Re: EA 14 Import DB fails

« on: June 21, 2018, 06:49:48 am »

The user account I am using to reverse engineer the data is dbo in the database.

 Any other tool I have (Toad Data Modeler, Power Designer Data Architect) works fine when it comes to reverse engineering tables.

8

Bugs and Issues / Re: EA 14 Import DB fails

« on: June 20, 2018, 04:07:13 am »

I have the same issue when I try to import a SQL Server 2008 R2 database. Honestly it is disappointing - it's basic functionality in my mind.

9

General Board / Re: Classic menu bar

« on: January 14, 2017, 05:38:24 am »

I've been restrained in my last message and I didn't say exactly what I think about ribbon menus. Hint: !@#$%^&

That's too bad. I guess I will turn them off as suggested by KP  and use the find command feature.

10

General Board / Re: Classic menu bar

« on: January 12, 2017, 10:29:01 am »

Can you please (* 100  ) add it back, with the option of having mixed case labels?

IMO, ribbon menus are not user friendly to say the least, and I don't understand why every company jumps to include unconditionally this design in their software, because it doesn't make things better vs. the classic menu.

I like very much though the Find Command feature.

Thanks

11

General Board / Classic menu bar

« on: January 11, 2017, 09:22:32 am »

Is there way to turn off the ribbon menu and use the classic menu bar?

Thanks