Older versions of Database Manager (DBM) stored music marker values in two metadata locations:

  • as entry properties and
  • as a special type of subclip (with subclip types 'MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')

These special subclips are obsolete and should be deleted.

Microsoft SQL database server

Execute following script in e.g. MS SQL Management Studio.

Replace

  • DigaSystem with the name of your database
  • Table with the name of your table
DELETE
FROM [DigaSystem].[david].[Table_C]
WHERE RESERVE1 IN ('MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')
CODE

MySQL database server

Execute following script in e.g. MySQL Workbench.

Replace

  • DigaSystem with the name of your database
  • Table with the name of your table
DELETE
FROM DigaSystem.Table_C
WHERE RESERVE1 IN ('MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')
CODE

Oracle database server

Execute following script in e.g. SQL Developer.

Replace

  • DigaSystem with the name of your database
  • Table with the name of your table
USE DATABASE DigSystem;
DELETE
FROM Table_C
WHERE RESERVE1 IN ('MarkIn_1', 'MarkOut_1', 'LinkIn_1', 'LinkOut_1', 'FadeIn_1', 'FadeOut_1', 'Intro_1', 'Intro2_1', 'Outro_1', 'Outro2_1', 'HookIn_1', 'HookOut_1')
CODE

MS Access database

Execute a SQL delete command in SqlHelper.exe from DAVID Systems.

You can get this software from DAVID Support Team, just contact support@davidsystems.com 

  1. Start SqlHelper.exe


  2. Select "Access (ODBC)" as Provider
  3. Enter the path to your Access database (mdb file) in Server/DataSource.
  4. Click "Connect"


  5. Navigate to the SQL tab
  6. Select a DigaSystem table, e.g. "Local"
  7. Select "Delete obsolete music markers" from Templates


  8. Click "Execute Query"