Using MySQL Workbench to create the Novell Service Desk schema

  • 7012316
  • 25-Jan-2011
  • 29-May-2013

Environment

Novell Service Desk

Situation

This documents how to use the MySQL Workbench application to create the Novell Service Desk schema

Resolution

Here are the steps to create the Novell Service Desk Schema using MySQL Workbench:

  1. Copy all the 'Create Schema' text from the Database tab in Novell Service Desk.
  2. If using the same machine that is running MySQL Workbench, this can be pasted straight in, but otherwise this text needs to be pasted into a plain text document and saved with a file name using a .sql extension.
  3. Open MySQL Workbench and go to the Home tab
  4. If there is a connection listed for the MySQL server in question under SQL Development, select it. Otherwise, select the New Connection to create it first and then select it.
  5. Once connected a list of the databases is on the left side. If the database in question has not been created yet, right click in the white space on the left side and select Create Schema to create the database.
  6. Above this list, it says 'Default:'. Using the drop down next to that, select the database this schema is to be created on.
  7. If pasting the text, paste it into the query window in the upper right of the screen. If opening a saved script, use the Open button on the toolbar at the top of the screen.
  8. Double check the correct database appears next to 'Default:' and then click the Lightning button to Execute the script.

This creates the schema on the database.

Additional Information

Formerly known as 1001414

Feedback service temporarily unavailable. For content questions or problems, please contact Support.