Migrating to a New Database

Before you run the script, you must install the CCF Database. You must then run a script on the SQL Server to migrate data from the existing database to the new CCF database. The script moves data from the previous database to the new database, and edits the data as per CCF 2009 schema. You must back up the existing database before running this script.

Migrating a CCF 2009 Database

Machine: <SQLSvr>.

Login User: Local administrator.

To migrate a CCF 2009 Database to CCF 2009 SP1 Database:

1. Open SQL Server

2. Run the script Open Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.

3. Back up the existing CCF database.

4. Open the Update2009SP1DBWith2009Data.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:

6. • @locallogin: Enter the domain and the user name that can used to connect to the databases
   • @remoteUserName: Enter the domain and user name to connect to the old database.
   • @remoteUserPassword: Enter the password required to connect to the old database.

7. Save the file and run the script.

Migrating a CCF 2008 QFE Database

Machine: <SQLSvr>.

Login User: Local administrator.

To migrate a CCF 2008 QFE Database to CCF 2009 SP1 Database:

1. Open SQL Server

2. Run the script Open Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.

3. Back up the existing CCF database.

4. Open the Move2008QFEDatabaseTo2009SP1Database.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:

6. • @locallogin: Enter the domain and the user name that can used to connect to the databases
   • @remoteUserName: Enter the domain and user name to connect to the old database.
   • @remoteUserPassword: Enter the password required to connect to the old database.

7. Save the file and run the script.