Move Aris9.8 BusinessPublisher SQL Database to other SQL Server

Marcel,

The question is not clear... if you want to change the database URL to Publisher, this is the command:

ACC+ localhost>reconfigure businesspublisher_m +bp.db.url="<new URL>"

The standard URL is as follows:

a) MSSQL server:

jdbc:sqlserver://<FQDN-hostname>:<port>;databaseName=<db-name>[;instance=MSSQLSERVER]

 

BR

AO

Hi André, thanks for you reply. I think it was a bit unclear. I ment I had to change the sql server computername into a sql server clustername. But the command you mentioned did the trick.

Now I have to the same for the Aris 9.8 Design Server.

The database location that I entered in the setup was also a sqlserver computername and this one must be changed to a sqlserver clustername also.

Do I need to run this command:

register external service db url="jdbc:sqlserver://SqlClusterName:1433;DatabaseName=ARIS9DES;instance=MSSQLSERVER"  ?

Thanks

Hi Marcel,

Sorry for delay I don't getting any update when post is updated.. I have to check this afterwards...



In that case you can use this one:



Syntax MSSQL server:

ACC+ localhost>update external service db<service-id> +url="jdbc:sqlserver:@<mssql server>:<listener-port>;DatabaseName=<Databasename>;instanceName=<instancename>" +host=<mssql-server> 







BR

AO

Hi all, we found the correct command to get if fixed. Thanks.