Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Editing the Data in the Tables in the restored Velocity Database

After restoring the Velocity database to the new system, perform the following procedure to edit the data in the SQL tables of the Velocity database.

  1. For Windows 10 type of machines, to locate the computer name of your system:

    1. Open Control Panel. Click System and Security System.

    2. On the View basic information, see the Full computer name under the Computer name, domain, and workgroup settings section. Visit Windows Support to check the computer name for other types of Windows versions.

  2. From the Windows desktop, select Start→ Microsoft SQL Server Tools 18→ Microsoft SQL Server Management Studio 18.
    The Microsoft SQL Server Management Studio opens.

  3. Login to SQL Server using your credentials.

  4. Expand the Databases folder to display the Velocity database in the Object Explorer navigation pane.

  5. Expand the Velocity database to display the Tables branch.

  6. Make the changes specified in the following table by right-clicking each database table and selecting Edit Top 200 Rows from the pop-up menu. (After each change, click outside the edited row for the changes to take effect.)

    Note: Be extra careful while editing the tables because accidentally editing the tables can corrupt the database.

    To add or edit the data in the SQL table properties, we have considered a scenario with examples that use a sequence of system names, such as vel1.server.system, vel1.local.system, vel1.remote.system etc., based on the entered data.

...