Upgrading the CCF Databases

  • Article

Before upgrading your database, ensure you back up your existing database. After upgrading to CCF 2009 database, you have to remap the following mappings in the Admin Console:

  • Application Mappings
  • Channel Mappings
  • Skills Mappings

Before you run the script, you must upgrade the required CCF 2009 SP1 components except the database. These scripts updates the schema and tables of the existing database to suit CCF 2009 SP1.

Upgrading a CCF 2009 Database

During installation, ensure that you provide the existing CCF 2009 database server as the database server. For more information about installing CCF 2009 SP1, see Installing CCF. You must than upgrade the existing CCF 2009 database to the using the script provided.

Note

The script does not move data table from the AuditDataLog table of CcfInfrastructure database. The AuditDataLog table has a XML column, which is not supported in SQL Server Distributed Queries. You will have to move the AuditDataLog table data manually to the new database. For more information about Distributed Queries, see MSDN.

Machine: <SQLSvr>.

Login User: Local administrator.

To upgrade CCF 2009 Database to CCF 2009 SP1 Database:

  1. Open Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.
  2. Back up the existing CCF database.
  3. Run the script Update2009Data.sql from the folder <Install Dir>\Database Tools\.
  4. Run the script UpdateConfigServerDatabase.sql from the folder <Install Dir>\ Database Tools\.

Upgrading a CCF 2008 QFE Database

During installation, ensure that you provide the existing CCF 2008 QFE database server as the database server. For more information about installing CCF 2009 SP1, see Installing CCF. You must than upgrade the existing CCF 2008 QFE database to the CCF 2009 SP1 database using the script provided.

Machine: <SQLSvr>.

Login User: Local administrator.

To upgrade CCF 2008 QFE Database to CCF 2009 SP1 Database:

  1. Open Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.

  2. Back up the existing CCF database.

  3. Run the script Update2008QFEDatabaseSchema.sql from the folder <Install Dir>\ Database Tools\.

  4. Open the Update2008QFEData.sql file from the folder <Install Dir>\ Database Tools\ in SQL Server Management Studio or any other editor.

  5. Edit the following parameters in the script:

    • @previousWebServerName: Enter the previous web server name.
    • @newWebServer: Enter the web server name where CCF 2009 is installed.
    • @previousSqlServerName: Enter the previous SQL Server name.
    • @newSqlServerName : Enter the name of the SQL Server to be upgraded. Since, we are upgrading the same database @previousSqlServerName and@newSqlServerNamewill be the same.
    • @previousAzManXmlLocation: Location where the previous AzMan.xml file is located.
    • @newAzManXmlLocation: Location where the CCF 2009 AzMan.xml file is located.

  7. Save the file and run the script.