Upgrading a Graffiti Database

When you upgrade your version of Graffiti, you will also need to upgrade your database. Use the DataMover.exe utility to migrate your database to or from one of the following platforms:

  • VistaDB
  • Microsoft Access
  • MySQL

 

Graffiti uses VistaDB as its default database, so when you install Graffiti8, an empty VistaDB is loaded onto your server. If you use Microsoft Access or SQL Server as your database platform, you will have to update your database provider.

SQL Server and MySQL

You can upgrade your database by running upgrade scripts or using the DataMover utility.

Procedure

  1. Back up your database.
  2. Do one of the following:

To run the upgrade script:

    • SQL Server located in /Data/Utility/SQL_1.1_Upgrade.sql.
    • MySQL located in /Data/Utility/MySql_1.1_Upgrade.sql.

When the script is complete, the database upgrade is complete. You do not need to complete the remaining steps.

To run the DataMover utility:

    • From the parent file of your upgraded version of Graffiti, navigate to \Data\Utility\Migrations.

Complete the remaining steps of this procedure.

     3.  Double-click DataMover.exe to launch the application. The Data Mover screen opens.

clip_image002

     4.  Do the following:

    • Select MySQL or SQL Server in the Source and Destination Database fields.
    • Enter a connection string or browse to select your source and destination databases.
    • Click Copy Data.

     5.  Close the window when the database migration is complete.

     6.  Navigate to your destination folder.

     7.  Select your database and move it to \Web\App_Data.

VistaDB and Microsoft Access

Procedure

  1. Copy your database to your computer.
  2. From the parent file of your upgraded version of Graffiti, navigate to \Data\Utility\Migrations.
  3. Double-click DataMover.exe to launch the application. The Data Mover screen opens.

clip_image002[1]

     4.  Do the following:

    • Select VistaDB or Microsoft Access in the Source and Destination Database fields.
    • Enter a connection string or browse to select your source and destination databases.
    • Click Copy Data.

     5.  Close the window when the database migration is complete.

     6.  Navigate to your destination folder.

     7.  Select your database and move it to \Web\App_Data.