topic migrate database to Cluster in Fraud, AML and Security Intelligence

migrate database to Cluster

medhatmamdouh — Thu, 21 Apr 2016 15:02:04 GMT

hi we have sas 9.4 aml enviromnet

as 1 server app, 1 server for wep, 1 server for database MSSQL

however we need to move the database from MS SQL server to MS cluster

do i need to change anything on sas confgiuration file or just reconfigure ODBC connection

Re: migrate database to Cluster

LinusH — Thu, 21 Apr 2016 16:18:10 GMT

Is there any difference in functionality between the two?
If not I would suspect it would work - but of course it needs to be tested. I asume that you have a test environment...

Re: migrate database to Cluster

medhatmamdouh — Thu, 21 Apr 2016 17:11:06 GMT

no difference in functionality it's just the DR solution for DB server,
yes i have test environment but i need to see if there is a post or article from sas talking about this, i tried to search but with no luck .

Re: migrate database to Cluster

SASKiwi — Fri, 22 Apr 2016 00:37:00 GMT

How do you refer to your SQL server in your SAS database connections? Do you refer to it by the actual server name or do you use a CNAME. If you have a DR environment it is best practice to use a CNAME (a logical name) in database connections, as this will refer to your Prod environment normally but can be switched to DR by your IT guys and you don't need to change any connections.