Automation for DBMS to DBMS backup?

[Christian Freihoff]

We are running our repo on a ms sql database, the backup is just another database. We use the project transfer tool (DBMS to DBMS) to do the backup, but we would like to automate that.
Does anyone already have a scipt/tool available for this purpose?

If not, i am firm with java development and saw the projectTransfer method in the API documentation. But does this method also allow DBMS to DBMS?

Our version of SPARX EA is 12.0.1215, our project/repo has security enabled.

thanks in advance

[qwerty]

For a simple backup just use the native database tools. The project transfer is more meaningful if you transfer between different RDBMS.

q.

[Christian Freihoff]

That's the point. At the moment, the target database is on the same system, but this will change and the target will be different. Additionally, we are quite ... no, very ... restricted regarding the tools we are allowed to install and we have no admin permissions on the databases. I.e., we can not just click in the MS SQL Server Management Studio. So, having some kind of automated project transfer in SPARX would be preferred ...

[Geert Bellekens]

Christian,

You can use the operations in the API to transfer the project, that's no issue.
The problem is trying to run them on a server (without an actual user logged in)

Geert

[Christian Freihoff]

Geert, with actual user You refer to the repo-security-user? Does the API not support these logins?

[Geert Bellekens]

No I mean a Windows user needs to be logged on on the machine running the "backup" process.

Often on servers running batch jobs that is not the case, and it doesn't play nice with EA.

Geert

[Christian Freihoff]

Ah, okay. The transfer is run on a usual client machine with win7, so this should not be the problem.

Has anyone already tried the projectTransfer method?

[Geert Bellekens]

Ah, okay. The transfer is run on a usual client machine with win7, so this should not be the problem.

Has anyone already tried the projectTransfer method?

I haven't myself, but I know lots of people use it this way.

Geert

[smendonc]

I posted a little PowerShell snippet that does exactly this below.

http://sparxsystems.com/forums/smf/index.php/topic,2708.msg222357.html#msg222357

Stan.

[Christian Freihoff]

thanks, stan 

is there any documentation how to insert the database stuff as path?

[qwerty]

In the Open dialog of EA right click on one existing repo and you find Edit connection string. That's the ODBC connection string you need.

q.