Executing SQL scripts

End users and developers may request SQL scripts be executed on a target system's database. 

Follow this process to execute the script.

Retrieving the script

  1. Get the script name from the requestor. (Example: 076-KFS-1524.sql)
  2. Using Fisheye or SVN (Fisheye is usually easier) navigate to the script under the following directory /kuali/KFS/kuali/kfs/uconn_kfs_core/trunk/work/db/scripts
  3. Make sure the requested SQL has been checked in!
  4. Click the file and then choose the "download" icon to retrieve the latest version of the file from SVN via Fisheye

Example:

 

Executing the script

Once you have downloaded the requested SQL, execute the script on the target database.

 

  1. The script can be executed a number of ways, but SQL Developer Studio is the preferred method that will be documented here.
  2. Connect to the target database in SQL Developer (or create a connection if you do not have one to the target DB/schema)



  3. Select File -> Open and open the script from where you downloaded it to on your local system.



  4. Execute the script, review the output, and if there are no errors, complete the process by choosing Commit. If there are errors, contact the developer, otherwise the SQL execution is complete!
  5. Update your related JIRA ticket.

Â