Using Corporate Edition with SQL Server

[gdrauch]

I am new to EA and have a question about using it with SQL Server.  I lead a team of developers and want to generate a new Project in SQL Server.  When I click Create a New Project I get a dialog box asking for a name for the .EAP file.  However, I want this new project to be in a database I created on SQL Server.  When I created this new database, I followed the instructions and ran an SQL script that I downloaded from the EA site.  Do I have to first create it as a local file and then upload it to SQL Server?  Also, when I select Open a Project File, I only have to option to load a local .EAP type file.  Once I've built my project/model, how do I get the other members of my team to open it?

Sorry if these questions sound so basic, but we all have some familiarity with UML but none with EA.  We are a bit pressed for time and need to start doing productive work with this tool as soon as possible.

Thanks.
Greg Drauch
ASI Corporation

[«Midnight»]

No problem Greg,

We've all been there before; everyone has to start sometime.

Once you've created the target database - you have done this already - EA needs some basic information loaded so it can be 'sane' when it uses the repository. You do this by copying a 'seed' project into the repository.

Open EA to do this. You do not need to open a project.

From the EA main menu choose Tools | Data Management | Project Transfer. The resulting dialog has several options, but the default EAP to DBMS is what you want. Using the browse ("...") buttons point EA to the EAP file you will use to seed the repository. Then point EA at your newly created repository. You will get a series of standard Windows dialogs, from which you can either choose or create an OLE (or ODBC) data source to point to your SQL Server database.

When you've answered the dialogs you will be returned to the EA Project Transfer dialog click Transfer and wait until things are done, then close the dialog.

Now click the Open button (or choose File | Open from the menu) and you will see Open Project dialog. At the top right, check the Connect to Server button, then once again click the browse button. Follow the same procedure to point to your repository (this time you will select the data source you created earlier).

When you've selected the data source and returned to the Open Project dialog, click Open.

Voilà!

HTH, David

[bmioch]

There is also a Connect to Server... link on the start page (bottom left).

But my favourite is to connect to the server, then go File | Save Project As... and then save an EAP file.

This EAP file is very small and only contains your connection string. This saves you doing the Connect to Server.. and subsequent dialogs every time you want to connect to your database.

[Dave_Bullet]

One you connect to the SQL Server via the dialogues, you'll notice the connection is remembered in the most recently used list in the start page.  That is how I reconnect to my database. (One click and it opens).

Cheers,
David.

[gdrauch]

Thanks for your help!