Security Intelligence to prevent fraud, achieve compliance and preserve security.

migrate database to Cluster

Reply
Occasional Contributor
Posts: 8

migrate database to Cluster

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

 

Super User
Posts: 5,430

Re: migrate database to Cluster

Posted in reply to medhatmamdouh
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...
Data never sleeps
Occasional Contributor
Posts: 8

Re: migrate database to Cluster

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 .
Super User
Posts: 3,256

Re: migrate database to Cluster

Posted in reply to medhatmamdouh

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.

Ask a Question
Discussion stats
  • 3 replies
  • 297 views
  • 0 likes
  • 3 in conversation