1 Reply Latest reply: Apr 24, 2014 5:18 AM by Afzal Kaifi RSS

    Want to Upgrade UPK 3.6.1 to UPK 11.1.0.1

    EBS2014

      Hi, We want to upgrade UPK 3.6.1 to UPK 11.1.0.1. We use a SQL2005 server now. Is-it possible in one step or it need many migration?

      Thanks

      Hugues

        • 1. Re: Want to Upgrade UPK 3.6.1 to UPK 11.1.0.1
          Afzal Kaifi

          Its a one step to upgrade the server and the database, If you can run the setup program and select the existing virtual directory and database that contains your data. You can also manually update the database by running a script on the database server before you run the installer to upgrade the web server.

          To upgrade the database using the AlterDBObjects.sql script located in \db scripts\MSSQL\Developer\Upgrade in the software installation files, enter the following at the command prompt:

          sqlcmd - The command line application for the Microsoft SQL Server.

           

          Statement with generic parameters:

          sqlcmd -E -S <servername> -i <scriptfile> –v DBOwner="<VALUE1>" -v DBName="<VALUE2>"