Versions Compared

Old Version 11

changes.mady.by.user Vinodhraj DP

Saved on

compared with

New Version Current

changes.mady.by.user Anand Rajaraman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel7
indent20px
class<div>

Overview

The computer from which you are transferring database files is called the source computer, and the computer to which you are transferring the database files is called the target computer.

The process of migrating your Velocity database to a different computer can be separated into three phases:

  • Preparing the computers for migration

  • Backing up current database files on your source computer

  • Restoring your existing Velocity database to the target computer and customizing the resulting database

If you are planning to upgrade Velocity, perform your upgrade, and then move your database.

Preparing the Computers for Migration

Before you begin this process, make sure you have fulfilled the following prerequisites:

...

 After you have fulfilled these prerequisites, you can perform the required procedures on the source computer.

Backing up the Current Database

The Velocity database file you will be moving is the backup file (.BAK). The database backup procedure differs depending on whether you are using:

Backing Up Using SQL 2012

If you are backing up the Velocity database using SQL 2012, use this procedure:

  1. Right-click on the Velocity Service Control Manager (SCM) icon on the source computer, stop all Velocity services, then select the Exit option to exit SCM.

  2. Open Microsoft SQL Server Management Studio; from the Windows desktop, select Start-> Microsoft  SQL Server 2012 -> SQL Server Management Studio.
    The Connect to Server dialog appears:

  3. Click Connect.

    The Microsoft SQL Server Management Studio screen appears:

  4. In the left tree pane, expand the Databases folder to reveal the Velocity database.

  5. Right-click on the Velocity database.

    A pop-up menu appears.

  6. Select Tasks -> Back Up...

    The Back-Up Database – Velocity dialog appears:

    If one or more backups are already displayed in the Destination pane, remove them by highlighting the device and clicking the Remove button.

  7. Click the Add... button to the right of the Destination pane.

    The Select Backup Destination dialog appears:

  8. Click to select the File name radio button.

  9. In the ‘File name’ field, place your cursor at the end of the path and type a name for the database file you are about to create. For example, Velocity_backup.bak.
    Make note of the path where this backup file is created, because you will need to access the file during a later step.

  10. Click OK to close this dialog and return to the Back Up Database –  Velocity dialog.
    The new file name now appears in the Destination pane.

  11. Click OK again.

    The current Velocity database is backed up to the selected destination. A message appears indicating that the database was backed up successfully.

  12. Click OK.

  13. Exit the SQL Server Management Studio.

Backing Up Using SQL 2014

If you are backing up the Velocity database using SQL 2014, use this procedure:

  1. Right-click on the Velocity Service Control Manager (SCM) icon on the source computer, stop all Velocity services, then select the Exit option to exit SCM.

  2. Open Microsoft SQL Server Management Studio; from the Windows desktop, select Start-> Microsoft SQL Server 2014-> SQL Server 2014 Management Studio.
    The Connect to Server dialog appears:

  3. Click Connect.

    The Microsoft SQL Server Management Studio screen appears:

  4. In the left tree pane, expand the Databases folder to reveal the Velocity database.

  5. Right-click on the Velocity database.

    A pop-up menu appears.

  6. Select Tasks > Back Up...

    The Back-Up Database – Velocity dialog appears:

    If one or more backups are already displayed in the Destination pane, remove them by highlighting the device and clicking the Remove button.

  7. Click the Add... button to the right of the Destination pane.

    The Select Backup Destination dialog appears:

  8. Click to select the File name radio button.

  9. In the ‘File name’ field, place your cursor at the end of the path and type a name for the database file you are about to create. For example, Velocity_backup.bak.
    Make note of the path where this backup file is created, because you will need to access the file during a later step.

  10. Click OK to close this dialog and return to the Back Up Database – Velocity dialog.
    The new file name now appears in the Destination pane.

  11. Click OK again.
    The current Velocity database is backed up to the selected destination. A message appears indicating that the database was backed up successfully.

  12. Click OK.

  13. Exit the SQL Server Management Studio.

Backing Up Using SQL 2017

If you are backing up the Velocity database using SQL 2017, use this procedure:

  1. Right-click on the Velocity Service Control Manager (SCM) icon on the source computer, stop all Velocity services, then select the Exit option to exit SCM.

  2. Open Microsoft SQL Server Management Studio; from the Windows desktop, select Start->Microsoft Server Tools 18->Microsoft Server Management Studio 18.
    The Connect to Server dialog appears:

  3. Click Connect.

    The Microsoft SQL Server Management Studio screen appears

  4. In the left tree pane, expand the Databases folder to reveal the Velocity database.

  5. Right-click on the Velocity database.
    A pop-up menu appears.

  6. Select Tasks -> Back Up...

    The Back-Up Database – Velocity dialog appears:

    If one or more backups are already displayed in the Destination pane, remove them by highlighting the device and clicking the Remove button.

  7. Click the Add... button to the right of the Destination pane.

    The Select Backup Destination dialog appears:

  8. Click to select the File name radio button.

  9. In the ‘File name’ field, place your cursor at the end of the path and type a name for the database file you are about to create. For example, Velocity_backup.bak.

    Make note of the path where this backup file is created, because you will need to access the file during a later step.

  10. Click OK to close this dialog and return to the Back Up Database – Velocity dialog.

    The new file name now appears in the Destination pane.

  11. Click OK again.
    The current Velocity database is backed up to the selected destination. A message appears indicating that the database was backed up successfully.

  12. Click OK.

  13. Exit the SQL Server Management Studio.

Backing Up Using SQL 2019

If you are backing up the Velocity database using SQL 2019, use this procedure:

  1. Right-click on the Velocity Service Control Manager (SCM) icon on the source computer, stop all Velocity services, then select the Exit option to exit SCM.

  2. Open Microsoft SQL Server Management Studio; from the Windows desktop, select Start->Microsoft Server Tools 18->Microsoft Server Management Studio 18.
    The Connect to Server dialog appears:

  3. Click Connect.

    The Microsoft SQL Server Management Studio screen appears

  4. In the left tree pane, expand the Databases folder to reveal the Velocity database.

  5. Right-click on the Velocity database.
    A pop-up menu appears.

  6. Select Tasks -> Back Up...

    The Back-Up Database – Velocity dialog appears:

    If one or more backups are already displayed in the Destination pane, remove them by highlighting the device and clicking the Remove button.

  7. Click the Add... button to the right of the Destination pane.

    The Select Backup Destination dialog appears:

  8. Click to select the File name radio button.

  9. In the ‘File name’ field, place your cursor at the end of the path and type a name for the database file you are about to create. For example, Velocity_backup.bak.

    Make note of the path where this backup file is created, because you will need to access the file during a later step.

  10. Click OK to close this dialog and return to the Back Up Database – Velocity dialog.

    The new file name now appears in the Destination pane.

  11. Click OK again.
    The current Velocity database is backed up to the selected destination. A message appears indicating that the database was backed up successfully.

  12. Click OK.

  13. Exit the SQL Server Management Studio.

Moving a Velocity 3.6 Database

Before proceeding, make sure you have installed Velocity 3.6 on the target computer using the instructions in the Velocity 3.6 Installation Guide.

...

The source database should now be running on the Velocity target computer.

Moving a Velocity 3.7 Database

Before proceeding, make sure you have installed Velocity 3.7 on the target computer using the instructions in the Velocity 3.7 Installation Guide.

...

The source database should now be running on the Velocity target computer.

Moving a Velocity 3.8 Database

Before proceeding, make sure you have installed Velocity 3.8 on the target computer using the instructions in the Velocity 3.8 Installation Guide.

...