Release Automation

Expand all | Collapse all

Migrate MS SQL Database to new Instance

Jump to Best Answer
  • 1.  Migrate MS SQL Database to new Instance

    Posted 06-06-2018 06:52 AM

    Hi,

     

    we need to migrate our current MS SQL 2012 Database to a 2016 one.

     

    I would like to know, if there is a "How to" somewhere, that explains the switch of a database for CA Release Automation?

     

    I thought I've seen this in here already somewhere, but I can't find it right now.

     

    Thanks,

    Michael



  • 2.  Re: Migrate MS SQL Database to new Instance

    Broadcom Employee
    Posted 06-08-2018 12:18 AM

    Hi Michael, 

     

          Below document has the information related to Backup and Recovery  .

     

    Release Automation KB: Disaster Recovery 

     

    Regards

    Vimal



  • 3.  Re: Migrate MS SQL Database to new Instance

    Posted 06-11-2018 02:48 AM

    Hi Vimal,

     

    this KB only says that it is recommended to do regular backups.

     

    It has no information on how to move the Database from one server to another.

     

    regards

    Michael



  • 4.  Re: Migrate MS SQL Database to new Instance

    Posted 06-13-2018 03:47 AM

    has no one information on that topic?

     

    what configuration do I need to change, when I have a new database server?



  • 5.  Re: Migrate MS SQL Database to new Instance

    Posted 06-13-2018 03:54 AM

    hope just switching the host settings in here is all I have to do

    Install for a Distributed Environment - CA Release Automation - 6.5 - CA Technologies Documentation 



  • 6.  Re: Migrate MS SQL Database to new Instance
    Best Answer

    Broadcom Employee
    Posted 06-13-2018 09:30 AM

    Hi Michael,

     

    The "manually configure communication with the database" section on that page are the steps I would follow (after stopping services). Since it is the same underlying database (MSSQL) you should be able to skip the database.properties entries since that specifies the driver to use. 

     

    Cheers,

    Gregg



  • 7.  Re: Migrate MS SQL Database to new Instance

    Posted 06-14-2018 01:42 AM

    Hi Gregg,

     

    yes, changing the server and port was enough for the switch.

     

    thanks,

    Michael