creating project using API

[bitskull]

Hi, we optimize our company's workflow . We want to store EA projects in database and create small company add-in for EA which will read approved requirements from our corporate IS. Now I need to solve how to create new empty project in database using EA's API without "Tools -> Data Management -> Project Transfer -> EAP to DBMS". Is it possible? If not is there any workaround (e.g. customizable SQL sequence which can create new empty project) ? Thanks for your time.

[«Midnight»]

I've asked this in past - as have others - and the answer was no, the feature is not available through the API.

[This might have changed though, so keep watching this thread.]

You might be able to do this by creating and loading a 'seed' project in SQL Server by hand. You could then transfer the project using a SQL Server ETL script. Of course you'll need to get you DBA involved, and you will have to write some code 'outside' of normal EA add-in operations, but this should not be too difficult.

Remember that creating a new project requires additional DBMS privileges beyond those normally granted to users in most shops.

David