tools

How to inject the SqlShell admin tool to Sitecore 7

Sometimes, we want to execute the SQL script to get insight into the current status of our Sitecore instance. It will be easy peasy lemon squeezy if you can access the server database.

ss_6

Another way is to play around with SqlShell admin tool (we can execute the SQL script via Sitecore user interface) if you’re Sitecore admin + your Sitecore instance version is 8.1 Update 2 or later.

Our one is 7.2.0 and the Gatekeeper does NOT allow to access the database server. We have to go through the back-and-forth process to get the SQL query result so it takes quite much time and effort to do that.

Personally, I wanted to clear the obstacle above by injecting the admin tool SqlShell into our Sitecore 7 instance. It’s a tricky way so you should use it at your own risk 😀

ss_7

How did I do that?

  1. install a fresh Sitecore 8.1.2 instance so that I have a good chance to avoid compatibility issue of the latest versions
    • Note: should use SIM to install it very easily and quickly
  2. ensure to enable SqlShell admin tool
  3. create a Sitecore package so that I will be able to install it to Sitecore 7 later
    • Note 1: SqlShell is referring to Sitecore.ExperienceContentManagement.Administration.dll so we need to package that file as well
    •  

      This slideshow requires JavaScript.

    • Note 2: you can download SqlShell_AdminTool812_InstallationWizard.zip if you’re so lazy like me 😀
  4. install a fresh Sitecore 7.2.0 instance
    • Note: should use SIM to install it very easily and quickly
  5. (optional) install SqlShell_AdminTool812_InstallationWizard.zip to Sitecore 7 instance via Installation Wizard
  6. (optional) assume that the Gatekeeper does NOT allow to install Sitecore package so I need to download SqlShell_AdminTool812_FileExplorer.zip and then upload it to Sitecore via File Explorer:
    • dbi_6
    • ensure to select Website folder in the content tree and then click Upload button to upload SqlShell_AdminTool812_FileExplorer.zip
    • ss_4
    • after clicking Next button, I would see the following dialog, ensure to check Unpack ZIP files on the server checkbox  and then click Upload > button to complete
    • ss_5.png
  7. navigate to /sitecore/admin/sqlshell.aspx, I would see something like this
    • ss_3

My Suggestion

  • we should ensure to select override option if any so that we would NOT see the following error message if someone already installed it previously
  • Could not load file or assembly ‘Sitecore.ExperienceContentManagement.Administration_001’ or one of its dependencies
  • ss_8
  •  

    This slideshow requires JavaScript.

Thanks the awesome Sitecore Community and Happy Sitecore Playing!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.