EA shuts down on Data Transfer to SQL (Again)

[weekitb]

I am getting "Enterprise Architect has experienced a network error and will close down" when I try to transfer from a .EAP file to SQL 2000 Server repository.
Either i set up the schema.And import to the New Database.

Has anyone else experienced this and worked through it?

Thanks,
Vee

[thomaskilian]

Pls. search this forum for "SQL SERVER". You will find a lot of threads dealing with that...

[weekitb]

I try to search but it does not work. . .  

[«Midnight»]

Vee,

Have you first performed a data transfer to your new database? This needs to be done before you do an import.

You will find this under the main menu: Tools / Data Management / Data Transfer... In the dialog you will want to choose EAP to DBMS.

Before you do the transfer you need to have an EAP file to transfer. [don't you hate it when people give you instructions in reverse order? Sorry about that.] You need to create a base project using the EAP (Jet) repository, either empty or set up with your base corporate configuration - glossary, stereotypes, whatever. This file will be used to 'bootstrap' the DBMS with necessary core data. There are additional fields that need to be populated, but EA will handle all that when you build the base file.

Now, back to the Data Transfer dialog. You will have to point to your base model and the SQL Server database. The process is the same as you have done in the past. Then fire up the transfer and away you go..

Please note that there has been a problem reported with base files created with the wizard. If you expreience this, you might want to download an empty project from the Sparx resource page.

Once you have completed the Data Transfer procedure, you should be able to open your new SQL Server database and perform your import.

Note that you can create an empty database in SQL Server and do the data transfer from that platform too.

Please let us know if this does not solve the problem.

David

[weekitb]

Thanks for all reply.
In the finally i found the problem.User that i use log in no have authoriy to do that .


Vee
Web Dev./Tester

[«Midnight»]

And that's just the kind of thing that can sneak by you when you've done everything else right...

[weekitb]

I know that but i'am not sysDBA.Can not do anything in data base  (-_-'').

thanks Midnight,
Vee
EA Very Very Newbie

[«Midnight»]

That's what I meant Vee. Everything's done, all the dials and knobs are set right, and all the hard problems solved.

Then at the last minute somebody drops by to say "By the way, you don't have permission to do that. Is there something else we can offer you?"

You're left desperately trying to remember why you showed up in the first place.

Mother always said there were going to be those days...

David

[«Midnight»]

Vee,

On a more serious note:

Surely if you have the ability to do anything with a shared model there must be some middle ground. Perhaps you can work with your DBA to build a corporate (or whatever) 'reference' model in the DBMS. Then you could arrange to have them copy the reference model via something along the lines of an ETL (Extract, Transfer, Load) script when a new EA repository is created.

If that could be arranged you would have a new model that behaved as if the data transfer had already been performed. From the point of view of the DBA this means you (the user) only need to be given the privileges necessary to work with the model through EA.

David