SQL Script to retrive DataBase settings before DB restore

select 'Update SysBCProxyUserAccount set SID = ''' + SID + ''' , NETWORKDOMAIN =''' + NETWORKDOMAIN + ''' , NETWORKALIAS = ''' + NETWORKALIAS + ''''
 from SysBCProxyUserAccount

 select 'Update SysWorkflowParameters set EXECUTIONUSERID = ''' + EXECUTIONUSERID + '''' from SysWorkflowParameters


 select 'Update SysServerConfig set SERVERID = ''' + SERVERID + '''' from SysServerConfig

 select 'Update BatchServerConfig set SERVERID = ''' + SERVERID + ''''  from BatchServerConfig

  select 'Update BatchServerGroup set SERVERID = ''' + SERVERID + '''' from  BatchServerGroup

 select Top 1 'Update Batch set SERVERID =''' + SERVERID + '''' from Batch

  select 'Update SYSEMAILPARAMETERS set SMTPRelayServerName = ''' +  SMTPRelayServerName +
''' , SMTPPortNumber = ''' +  Convert(varchar(10),SMTPPortNumber) +
''' , SMTPServerIPAddress = ''' + SMTPServerIPAddress +
''' , SMTPUserName = ''' + SMTPUserName +
''' , DNSServerName = ''' + SMTPUserName  + ''''

 from SYSEMAILPARAMETERS


select 'Update SysFileStoreParameters set FilePath = ''' + FilePath + '''' from SysFileStoreParameters


select 'Update BIANALYSISSERVER set Servername = ''' + SERVERNAME + ''' , DEFAULTDATABASENAME = ''' + DEFAULTDATABASENAME + ''''  from BIANALYSISSERVER


select 'Update BICONFIGURATION set PROJECTPATH = ''' +  PROJECTPATH +
''' , DATASOURCENAME = ''' + DATASOURCENAME +
''' , CONNECTIONSTRING = ''' +  CONNECTIONSTRING +
''' , LOGFILEPATH = ''' + LOGFILEPATH +
''' , PROJECTFILENAME = ''' + PROJECTFILENAME  + ''''

from BICONFIGURATION

select 'Update BICONFIGURATION set PROJECTFILENAME = ''' + PROJECTFILENAME  + ''''

from BICONFIGURATION



select  'Update SRSSERVERS set  SERVERID = ''' +  SERVERID +
''' , SERVERURL = ''' + SERVERURL +
''' , AXAPTAREPORTFOLDER = ''' +  AXAPTAREPORTFOLDER +
''' , REPORTMANAGERURL = ''' + REPORTMANAGERURL +
''' , SERVERINSTANCE = ''' + SERVERINSTANCE +
''' , AOSID = ''' + AOSID +
''' , CONFIGURATIONID = ''' + CONFIGURATIONID  + ''''
 from SRSSERVERS


select  'Update SRSSERVERS set CONFIGURATIONID = ''' + CONFIGURATIONID  + ''''
 from SRSSERVERS

 select 'Update SYSGLOBALCONFIGURATION set Value = ''' + VALUE + ''' where name = ''HelpServerLocation''' from SYSGLOBALCONFIGURATION where NAME = 'HelpServerLocation'

 select  'Update EPGLOBALPARAMETERS set HOMEPAGESITEID = ''' + Convert(varchar(100),HOMEPAGESITEID) +
''' , DEVELOPMENTSITEID = ''' + Convert(varchar(100), DEVELOPMENTSITEID) +
''' , SEARCHSERVERURL = ''' + Convert(varchar(100),SEARCHSERVERURL)  + ''''

 from EPGLOBALPARAMETERS


 select 'Update EPWEBSITEPARAMETERS set INTERNALURL = ''' + Convert(varchar(100),INTERNALURL) +
''' , SITEID = ''' + Convert(varchar(100), SITEID) +
''' , EXTERNALURL = ''' + Convert(varchar(100),EXTERNALURL)  + ''''
 from EPWEBSITEPARAMETERS