ProjectTransfer keeps asking for password

[Zvolensky]

Hello
I'm working on a small script which will perform automatic daily project transfer from BDMS to a local EAP file.
it is a small VB script where I'm using the method
ProjectTransfer (string SourceFilePath, string TargetFilePath, string LogFilePath)
For the access to database I'm using connection string with integrated security.
Issue is I'm getting a pop up window asking me for a password.
Is there a way around? I need this to be fully automated, no human interaction.
Thx for help

[qwerty]

This is probably for the target repository which has security turned on. You could try to run

Code: [Select]

Repository.Execute("DELETE FROM t_secpolicies")with the target prior to the transfer. This will turn off security.

q.

[Zvolensky]

Hello
Thank you, will try it out.
But on the other hand, the target file does not exists (as it is not required based on the documentation) so I'm not sure if I will be able to execute that command.

[Geert Bellekens]

If you get a dialog asking for just a password, then that means that it can't find the database.
The same happens when you cut the network connection.

Geert

[qwerty]

Well, I did not cross check, but the target database must exist. It just must not contain data. But the structure must be present. For EAP there is the base EAP which will be copied (on new operations). And for RDBMS Sparx offers the various creation scripts.

q.

[Zvolensky]

Hello
thank you all for help
The problem was as Geert anticipated in the connection to the database.
Script is running fine if the source file is a local file. So I need to work a bit on my connection string.
@qwerty, from the documentation: In automation, the target file does not have to exist. The file path is enough; Enterprise Architect creates a new, empty Base.EAP file and transfers the source project into it.

True you need it if performing project transfer manually, but in this case (and I have tested it) it does not need to exist

[qwerty]

Ah. Thanks for clarification. I usually worked with a transfer to a RDBMS and only the source was EAP.

q.