Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML DA with Sql server db : CREATE DATABASE permission can only be granted in the master database.
DA with Sql server db : CREATE DATABASE permission can only be granted in the master database.
CMS-XML Connection to SRA fails with 404 error if non-default SQL Server dbname used
Connection to SRA fails with 404 error if non-default SQL Server dbname used
CMS-XML DA: What is the recommended collation sequence when using MS SQL Server
DA: What is the recommended collation sequence when using MS SQL Server
CMS-XML SRA / SDA upgrade 4.5 to 5.1
We can use "Use existing settings" option for other than Derby database, like SQL server .
CMS-XML DA 6.1.5: Published Views tutorial
Please note there have been some fixes made to the Oracle and SQL Server DDL files, are contained in the attached file: view_schema_fix.zip
CMS-XML SDA: TIPs on Maintaining an SDA Database
Background In the case of SQL Server and Oracle we would expect someone at the customer site to act as DBA for the database and perform installation, setup and routine maintenance of the database over time.
PDF 11019235233eed01603902280f007a42#CM 14.4 Install DA Demo App on PostGreSQL.pdf
However, DA does not currently support the PostgreSQL database platform, and it is no longer possible to install DA as part of the CM server install. It is possible however to install DA as a separate installation to use the CM Tomcat installation and utilise a supported database platform ( SQL Server , Oracle or Derby). This will therefore mean DemoApplication and its associated artifacts will not be loaded into the database.
CMS-XML Creating database views to use for running Deployment Automation reports
To create the SQL Views, execute the ddl to create the views in your database according to the steps required for your DBMS. For Oracle and SQL Server view the Serena Central Blog Post . For example, for Derby, use the following steps:
CMS-XML The silent installer option IS_DESTINATION is no longer included; it is replaced with ServerDetailsInstallLoc
Examples are given for Oracle and SQL Server as those are expected to be used in a production environment.
PDF 1101920157869d8016021cd97f5007e41#SDA 6.1.5 DA Views Tutorial.pdf
SDA 6.1.5 DA Published Views Tutorial Page 5 SQL Server database  From commandline use the sp_help to show the view information sqlcmd -U sa -P sa -W -S stl-pc-w12 -d serena_ra -Q "sp_help 'view_app_proc_requests’;"
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs