How setup server repository?????

[sonny]

Hi Folks

I just want to setup SQL Server database and then connect to this database repository for design purpose.

could any one know or have any document or guide to setup this..functionality..

Please help..

Regards

[kgish]

You'll need to create a table, download the example sql-file provided somewhere as a download on this site, import/run that script in order to create all of the tables and their contents. Afterwards, create a dummy EAP-file (for example, based on the EABase template), and then when that is all done, choose Tools | Data Management | Data Transfer ... | .EAP to DBMS, choosing the dummy EAP-file as input and the newly created table as output.

Kind of a alot of steps for something so simple, but I understood from the kind folks here that they would be implementing it in an upcoming version.

Have fun.

[moses]

just a few notes :-)
- replace "table" with database in the previous post
- don't forget about setting proper security on the database ... the user that wants to import must be at least a "ddl_admin" (a MSSQL inbuilt role)
- you need a "higher" EA version - don't remember the name now, sorry
- in case you use a different language in your model, you better have a look at the collation settings in the script

i suggest you read this :
http://sparxsystems.com.au/resources/corporate/sql_server_instructions.html

it is easy :-) good luck, moses