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

Pages: [1] 2
1
General Board / Re: Generating a data model from DDL
« on: March 28, 2012, 04:02:29 am »
Ugg..

Quote
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

2
General Board / Generating a data model from DDL
« on: March 27, 2012, 11:16:46 am »
I read the help file in EA and it tells me to select import DDL from the code generation menu which appears when I right click my package name.

I do not see the option for importing DDL, (EA 8.0). I have the DDL script, is there anyway I can just run it?

FYI, It would be really helpful if the help files had step by step instructions with screen shots.

3
General Board / Re: Help - Possible corrupt EAP File - Urgent
« on: March 17, 2012, 05:32:31 am »
Replying to my own post here, I was able to repair this with the EA repair tool.

Thanks!

4
General Board / Re: Help - Possible corrupt EAP File - Urgent
« on: March 17, 2012, 04:15:37 am »
The folder is backed up to nightly back ups, but it's a bit of hassle retrieving those.

Quote
If this is 3 months without backup then you have learned a lesson.

q.

5
General Board / Help - Possible corrupt EAP File - Urgent
« on: March 17, 2012, 03:54:41 am »
Last night my computer was rebooted while I was in the middle of working on a EA file.

After I tried to open it back up this morning I am getting the error "An error has occured: Unrecognized database format"

This is 3 months of work, PLEASE tell me this is not lost just because of a reboot?!

6
General Board / Re: Data Model Question. Help
« on: March 16, 2012, 09:22:24 am »
Replying to my own post here, as I believe I finally figured this out.

If you right click on a table element and go to properties, then click the 'Tagged Values' tab, there is a option for Owner.

Seems a bit of a odd place to put this, but so be it.

7
General Board / Data Model Question. Help
« on: March 16, 2012, 08:40:44 am »
Hi forums,

I've asked this before with no reply, hoping someone can help.

I rely on EA for data modeling and DDL generation. Is there an option to include the prefix [dbo] in front of CREATE TABLES. E.G, CREATE TABLE [dbo].foo

The problem I am having deals with the security policy at my work. If I do not include dbo it will create the tables with my username.

I have been manually searching and replacing each DDL script  :'(

I do see a "Include DBO" option, but that seems to do nothing?

Thanks!

8
General Board / Re: Deleting Elements from a Diagram
« on: March 16, 2012, 09:27:13 am »
Thanks, this makes sense.

Quote
The Project Browser shows the contents of your model, and the elements in your model can appear in zero, one, or more than one diagram. Selecting an element in a diagram and pressing Delete removes it from the diagram, but not the model. To remove it from the diagram AND the model, press Ctrl+Delete.

9
General Board / Deleting Elements from a Diagram
« on: March 16, 2012, 08:57:06 am »
Specifically with a Data Model, this is driving me bonkers.

I delete a table from my diagram, yet it stays in the right hand pane "Project Browser" - so when I generate the DDL, the table code still gets generated.

I have to select the table from the right hand side and delete it there.

Is this a bug?

10
General Board / Create Table w/DBO
« on: May 28, 2011, 04:44:24 am »
Is there a way to have EA natively precede the table names in the create statement script it generates with [dbo]?

11
General Board / Foreign Keys removing themselves when I save
« on: May 28, 2011, 04:24:30 am »
All,

I'm not sure if this is a bug with EA or if I am missing something but it's driving me crazy.

FYI, I have re-installed and started new diagrams and this continues to happen at random.

I have 2 basic tables, one with a primary key and one which will have a foreign key. I use the association line and select 'foreign key' and build it. It's reflected correctly right away, with the new FK being populated in the FK area of the table.

However, as soon as I save, the FK deletes itself!

What am I missing?


12
Bugs and Issues / This is driving me absolutely bonkers - Help!
« on: August 11, 2011, 03:32:39 am »
Would be great if an admin could respond. I've posted about this in the past and haven't gotten a response :(

This bug is totally random it seems.

When building a data model and connecting two tables with an association connector, I specify a FK relationship between the two. Everything works and looks fine, until I hit save, then the relationship is removed before my eyes.

I cannot for the life of me figure out what the hell is going on, but it's REALLY annoying.

Help?

13
Bugs and Issues / Image is being cut off when I generate a diagram
« on: June 01, 2011, 07:17:50 am »
I have a data model which contains about 100 tables. I cannot get it to generate an image without cutting of various parts of the diagram.

Am I missing something?

14
Bugs and Issues / Project Browser not refreshing
« on: May 28, 2011, 04:35:22 am »
Often, when I make a modification to the diagram, the Project Browser window is not refreshed. Is this the intended behavior?

E.G, In a data model, if I create a FK and then delete it it's still in the Project Browser

15
Bugs and Issues / Re: EA 7.5
« on: May 28, 2011, 04:31:50 am »
BTW Daniel,

The work around I came up with was to save the model after you delete the FK constraint, then add it and save it again.

The project Browser however is never updated, which must be a bug. I would expect if I remove something from my diagram that the project browser is updated, but it is not.

Pages: [1] 2