Upgrading xConnect from Sitecore 9.1.0 to 9.1.1 - Database Upgrade Script missing?












2















I'm in the process of upgrading a Sitecore 9.1.0 instance to 9.1.1. The Sitecore upgrade itself is done, but I need to upgrade xConnect as well.



Following the Sitecore 9.1.1 Upgrade Guide, it states:



Before you upgrade xConnect:




  1. Download the packages for XP Single – Sitecore 9.1.1 rev. 002459 (WDP XP0
    packages).zip – and unpack the zip file.
    To upgrade xConnect, you need the following file:
    o Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip

  2. Unpack the Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip file.

  3. Unpack the Database Upgrade Script.zip file. It contains several database upgrade scripts including:


    • SXP_marketingautomation.sql

    • SXP_referencedata.sql

    • SXP_processing_pools.sql

    • SXP_collection.sql

    • SXP_collection_AE_Part1.sql

    • SXP_collection_AE_Part2.sql

    • SXP_collection_GrantPermissions.sql

    • SXP_processing_engine_tasks.sql

    • SXP_mongodb_collection.js




So I did. But the Database Upgrade Script.zip file is nowhere to be found. Either that or I'm missing something.



This is what I downloaded:



enter image description here



And this is what's in the mentioned Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip archive (well some of it, but the Database Upgrade Script.zip isn't there, nor are the mentioned files):



enter image description here



Is the script missing, or is there somewhere else I should be looking for these upgrade scripts?










share|improve this question



























    2















    I'm in the process of upgrading a Sitecore 9.1.0 instance to 9.1.1. The Sitecore upgrade itself is done, but I need to upgrade xConnect as well.



    Following the Sitecore 9.1.1 Upgrade Guide, it states:



    Before you upgrade xConnect:




    1. Download the packages for XP Single – Sitecore 9.1.1 rev. 002459 (WDP XP0
      packages).zip – and unpack the zip file.
      To upgrade xConnect, you need the following file:
      o Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip

    2. Unpack the Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip file.

    3. Unpack the Database Upgrade Script.zip file. It contains several database upgrade scripts including:


      • SXP_marketingautomation.sql

      • SXP_referencedata.sql

      • SXP_processing_pools.sql

      • SXP_collection.sql

      • SXP_collection_AE_Part1.sql

      • SXP_collection_AE_Part2.sql

      • SXP_collection_GrantPermissions.sql

      • SXP_processing_engine_tasks.sql

      • SXP_mongodb_collection.js




    So I did. But the Database Upgrade Script.zip file is nowhere to be found. Either that or I'm missing something.



    This is what I downloaded:



    enter image description here



    And this is what's in the mentioned Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip archive (well some of it, but the Database Upgrade Script.zip isn't there, nor are the mentioned files):



    enter image description here



    Is the script missing, or is there somewhere else I should be looking for these upgrade scripts?










    share|improve this question

























      2












      2








      2








      I'm in the process of upgrading a Sitecore 9.1.0 instance to 9.1.1. The Sitecore upgrade itself is done, but I need to upgrade xConnect as well.



      Following the Sitecore 9.1.1 Upgrade Guide, it states:



      Before you upgrade xConnect:




      1. Download the packages for XP Single – Sitecore 9.1.1 rev. 002459 (WDP XP0
        packages).zip – and unpack the zip file.
        To upgrade xConnect, you need the following file:
        o Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip

      2. Unpack the Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip file.

      3. Unpack the Database Upgrade Script.zip file. It contains several database upgrade scripts including:


        • SXP_marketingautomation.sql

        • SXP_referencedata.sql

        • SXP_processing_pools.sql

        • SXP_collection.sql

        • SXP_collection_AE_Part1.sql

        • SXP_collection_AE_Part2.sql

        • SXP_collection_GrantPermissions.sql

        • SXP_processing_engine_tasks.sql

        • SXP_mongodb_collection.js




      So I did. But the Database Upgrade Script.zip file is nowhere to be found. Either that or I'm missing something.



      This is what I downloaded:



      enter image description here



      And this is what's in the mentioned Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip archive (well some of it, but the Database Upgrade Script.zip isn't there, nor are the mentioned files):



      enter image description here



      Is the script missing, or is there somewhere else I should be looking for these upgrade scripts?










      share|improve this question














      I'm in the process of upgrading a Sitecore 9.1.0 instance to 9.1.1. The Sitecore upgrade itself is done, but I need to upgrade xConnect as well.



      Following the Sitecore 9.1.1 Upgrade Guide, it states:



      Before you upgrade xConnect:




      1. Download the packages for XP Single – Sitecore 9.1.1 rev. 002459 (WDP XP0
        packages).zip – and unpack the zip file.
        To upgrade xConnect, you need the following file:
        o Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip

      2. Unpack the Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip file.

      3. Unpack the Database Upgrade Script.zip file. It contains several database upgrade scripts including:


        • SXP_marketingautomation.sql

        • SXP_referencedata.sql

        • SXP_processing_pools.sql

        • SXP_collection.sql

        • SXP_collection_AE_Part1.sql

        • SXP_collection_AE_Part2.sql

        • SXP_collection_GrantPermissions.sql

        • SXP_processing_engine_tasks.sql

        • SXP_mongodb_collection.js




      So I did. But the Database Upgrade Script.zip file is nowhere to be found. Either that or I'm missing something.



      This is what I downloaded:



      enter image description here



      And this is what's in the mentioned Sitecore 9.1.1 rev. 002459 (OnPrem)_xp0xconnect.scwdp.zip archive (well some of it, but the Database Upgrade Script.zip isn't there, nor are the mentioned files):



      enter image description here



      Is the script missing, or is there somewhere else I should be looking for these upgrade scripts?







      xconnect






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 19 hours ago









      Mark CassidyMark Cassidy

      17.4k53782




      17.4k53782






















          1 Answer
          1






          active

          oldest

          votes


















          3














          You need to download Configuration Files for Upgrade.



          You find the link in the Upgrade Options section of page:



          https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/91/Sitecore_Experience_Platform_91_Update1.aspx



          enter image description here



          The configuration files zip contains Database Upgrade Script.zip



          enter image description here



          Inside the zip file you will find the sql files that you need:



          enter image description here






          share|improve this answer


























          • That is a very confusing bit in the upgrade.

            – Chris Auer
            16 hours ago











          • Yep, I totally agree.

            – Vlad Iobagiu
            16 hours ago











          • I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

            – Chris Auer
            16 hours ago











          • Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

            – Mark Cassidy
            16 hours ago












          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "664"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsitecore.stackexchange.com%2fquestions%2f18105%2fupgrading-xconnect-from-sitecore-9-1-0-to-9-1-1-database-upgrade-script-missin%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          3














          You need to download Configuration Files for Upgrade.



          You find the link in the Upgrade Options section of page:



          https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/91/Sitecore_Experience_Platform_91_Update1.aspx



          enter image description here



          The configuration files zip contains Database Upgrade Script.zip



          enter image description here



          Inside the zip file you will find the sql files that you need:



          enter image description here






          share|improve this answer


























          • That is a very confusing bit in the upgrade.

            – Chris Auer
            16 hours ago











          • Yep, I totally agree.

            – Vlad Iobagiu
            16 hours ago











          • I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

            – Chris Auer
            16 hours ago











          • Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

            – Mark Cassidy
            16 hours ago
















          3














          You need to download Configuration Files for Upgrade.



          You find the link in the Upgrade Options section of page:



          https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/91/Sitecore_Experience_Platform_91_Update1.aspx



          enter image description here



          The configuration files zip contains Database Upgrade Script.zip



          enter image description here



          Inside the zip file you will find the sql files that you need:



          enter image description here






          share|improve this answer


























          • That is a very confusing bit in the upgrade.

            – Chris Auer
            16 hours ago











          • Yep, I totally agree.

            – Vlad Iobagiu
            16 hours ago











          • I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

            – Chris Auer
            16 hours ago











          • Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

            – Mark Cassidy
            16 hours ago














          3












          3








          3







          You need to download Configuration Files for Upgrade.



          You find the link in the Upgrade Options section of page:



          https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/91/Sitecore_Experience_Platform_91_Update1.aspx



          enter image description here



          The configuration files zip contains Database Upgrade Script.zip



          enter image description here



          Inside the zip file you will find the sql files that you need:



          enter image description here






          share|improve this answer















          You need to download Configuration Files for Upgrade.



          You find the link in the Upgrade Options section of page:



          https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/91/Sitecore_Experience_Platform_91_Update1.aspx



          enter image description here



          The configuration files zip contains Database Upgrade Script.zip



          enter image description here



          Inside the zip file you will find the sql files that you need:



          enter image description here







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 16 hours ago

























          answered 16 hours ago









          Vlad IobagiuVlad Iobagiu

          13.8k21035




          13.8k21035













          • That is a very confusing bit in the upgrade.

            – Chris Auer
            16 hours ago











          • Yep, I totally agree.

            – Vlad Iobagiu
            16 hours ago











          • I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

            – Chris Auer
            16 hours ago











          • Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

            – Mark Cassidy
            16 hours ago



















          • That is a very confusing bit in the upgrade.

            – Chris Auer
            16 hours ago











          • Yep, I totally agree.

            – Vlad Iobagiu
            16 hours ago











          • I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

            – Chris Auer
            16 hours ago











          • Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

            – Mark Cassidy
            16 hours ago

















          That is a very confusing bit in the upgrade.

          – Chris Auer
          16 hours ago





          That is a very confusing bit in the upgrade.

          – Chris Auer
          16 hours ago













          Yep, I totally agree.

          – Vlad Iobagiu
          16 hours ago





          Yep, I totally agree.

          – Vlad Iobagiu
          16 hours ago













          I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

          – Chris Auer
          16 hours ago





          I’m going to forward this to the docs team and Martina. See if we can get it written more clearly.

          – Chris Auer
          16 hours ago













          Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

          – Mark Cassidy
          16 hours ago





          Yea that could definitely have been clearer. I guess - in retrospect - I should have found these files on my own, but the installation and upgrade guides are very specific and step-by-step-ish, so I tend to just follow them verbatim.

          – Mark Cassidy
          16 hours ago


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Sitecore Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsitecore.stackexchange.com%2fquestions%2f18105%2fupgrading-xconnect-from-sitecore-9-1-0-to-9-1-1-database-upgrade-script-missin%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          GameSpot

          connect to host localhost port 22: Connection refused

          Getting a Wifi WPA2 wifi connection