Version

Update Data and Stored Procedures

Before You Begin

In Ultimate UI for ASP.NET 2009.2, the stored procedures for the SQL data base have changed. If you are using data from the WebSchedule2.sql data file prior to 2009.2, you need to update the stored procedures.

Ultimate UI for ASP.NET 2009.2 ships with the following 2 SQL scripts:

  • WebSchedule2.sql – data base creation file updated with new and modified stored procedures.

  • Upgrade2to9.2.sql – data base update file to update existing data base.

What You Will Accomplish

You will learn how to update your existing data base to use the updated stored procedures.

Follow these Steps

  1. Locate the Upgrade2to9.2.sql file in the following paths:

    • Windows XP — C:\Documents and Settings\All Users\Documents\Infragistics\2023.1ASP.NET\WebSchedule\Data

    • Windows Vista or later-- C:\Users\Public\Documents\Infragistics\2023.1ASP.NET\WebSchedule\Data

  1. Double-click the file to open it in SQL Server. If you are using SQL Server Express, you need SQL Server Management Studio Express to open the file.

  2. Execute the script.

  3. Verify that you do not encounter any errors from executing the script. Your existing SQL stored procedures are now updated.