SSMS Add-in User manual

28 Jan 2021 701 views 0 minutes to read Contributors

  

image

 

 

 

 

  

 

User manual

        SQL Server Management Studio

Add-in

 

                 

 

 

 

 

 

 

image


1.1         Requirements

SQL Server Management Studio

  • Installed on the computer before the installation of SQLTreeo SSMS AddIn.

  • SQLTreeo will be installed in all locally installed SSMS versions.

  • SSMS 2005, SSMS2008, SSMS2008R2, SSMS2012, SSMS2016, SSMS2017, SSMS2018, SSMS2019 and up.

Windows

  • Minimum .Net version: .Net 4.0.
  • Minimum Windows version: Windows XP with additionally installed .Net 4.0.
  • Minimum Windows version with pre-installed .Net 4.0: Windows 8 / Latest Windows Server (all editions).
  • HDD footprint is about 4MB.

SQLTreeo


·         Registered user account

·         Trial license key or Subscription license key

References

 

  1. 1.2         Quick installation guide

    Prerequisites:

    -          Close any open SSMS application or service.
    Steps

    1.       Extract the SQLTreeoDBASuite.zip file.
    2.       Login with your SQLTreeo account.
    3.       Hover on the SSMS Addin module and select download.
    4.       Follow the installation wizard instructions.
    5.       Launch any version of SSMS 2005 or higher.
    6.       Navigate to Tools à SQLTreeo à License.\
    7.       Press “Add license”.
    8.       Enter  your license key.
    9.       Press OK .
    10.   Restart SSMS.


    1.3 License overview

    Licenses can only be purchased from SQLTreeo at Products or registered Resellers and distributors

    Licenses are stored in your personal management panel accessible only from Login on www.sqltreeo.com
    Purchased licenses require activation before they can be activated in SSMS. Enabeling the license can be done in your personal SQLTreeo environment under the purchase history tab. 
    Pressing the + sign in the Disable/Enable column starts or pauses the license timer.

SQLTreeo  SSMS Addin comes in 3 different plans:

a) Trial license

Trial license is received after succesfully registering and downloading the SSMS Addin software.
Trial is time-limited for a period of 30 days from the moment it is enabled.        
Trial contains full features without restrictions or limitations.

b) Business license

Business license is received after succesfully registering and downloading the SSMS Addin software.
Business license is time-limited for a period of 365 days from the moment it is enabled.
Business license contains full features without restrictions or limitations.


c) Corporate license
nee
Corporate license is time-limited for a period of 365 days from the moment it is enabled.
Corporate license contains full features without restrictions or limitations.
Supports cloud storage sharing options



  • 1.4         Specifications

The SQLTreeo SSMS Addin extension enables the following features:

  • Create static folder
  • dynamic folder
  • objects
  • Quick filter
  • Object information summary
  • Collapse all
  • Script CREATE/INSERT TO
    Manage folders

1.5         Version

SQLTreeo Static Folders
Available from SSMS version 2005 and up.
SQLTreeo Dynamic Folders
Available from SSMS version 2016 and up.
SQLTreeo Compare(Requires Seperate Compare module)
Available from SSMS version 2016 and up.


 

SQL Server version/

Function

2008

2008R2

2012

2014

2016

2017

2018

2019

Static folder

x

x

x

x

x

x

x

 

Dynamic folder

 

 

 

 

x

x

x

 

Compare

 

 

 

 

x

x

x

 

Quick filter

 

 

 

 

x

x

x

 

Object information

x

x

x

x

x

x

x

 

Collapse/script/manage

x

x

x

x

x

x

x

 

 

1.6         Compatibility


SQLTreeo SSMS Addin software is an extension on the Microsoft build SQL Server Management Studio application. The extension allows you to create custom folders inside the Object explorer tree and organize objects.SQL Server Management Studio allows for multiple extensions to run simultaniously in which each extension is developed for compatibility with SSMS.

Running multiple extensions in the same session may cause conflicts and degrade the functions of 1 or more extension.
The compatibility between other extensions in the same session is not measured.

1.7         Docs

SQLTreeo has published several technical and general articles related to the SSMS Addin.The following link contains the informational topics.

SQLTreeo - SSMS Addin docs


1.8        EULA (End User License Agreement)


End User License Agreement (EULA) for SQLTreeo SSMS Addin® 
This SQLTreeo End User License Agreement ("EULA") is a legal agreement between you and SQLTreeo for the software product identified above, which includes computer software and may include associated media, printed materials, and "online" or electronic documentation (collectively, the "SOFTWARE"). PLEASE READ THIS EULA CAREFULLY BEFORE COMPLETING THE INSTALLATION PROCESS AND USING THE SOFTWARE.  

By installing, copying, or otherwise using the SOFTWARE, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, then do not install or use the SOFTWARE.


SOFTWARE LICENSE
 


 

DEFINITIONS 

(a) "SQLTREEO" means SQLTreeo. 

 

(b) "SQLTREEO BETA TEST PROGRAMME" means the testing process by external entities of any software developed by SQLTREEO identified as Beta Test software. 

 

(c) "END USER PRODUCT" means data created by the SOFTWARE and distributed to any third party. 

LICENSE GRANTS 

This EULA grants you the following limited, non-exclusive rights subject to the terms and conditions set forth in this EULA: 

 

(a) Your license rights under this EULA are NON-EXCLUSIVE and NON-TRANSFERABLE. 

 

(b) You may install and use the SOFTWARE on one (1) single computer located at your premises for the sole purpose of automating index management for the duration of your license. 

LICENSE RESTRICTIONS 

(a) Other than as set forth in Section 2, you may not make or distribute copies of the SOFTWARE, or electronically transfer the SOFTWARE from one computer to another or over a network. 

 

(b) All copyright notices and web links within any END USER PRODUCT must be retained "as is" and may not be removed or obscured in any way. 

 

(c) You shall not use the SOFTWARE to develop any END USER PRODUCT having the same primary function as the SOFTWARE. 

 

(d) You may not alter, merge, modify, adapt or translate the SOFTWARE, or decompile, reverse engineer, disassemble, or otherwise reduce the SOFTWARE to a human-perceivable form. 

 

(e) You may not rent, lease, lend, sell, resell, or otherwise transfer whether for value or otherwise, the SOFTWARE to third parties without SQLTREEO’S written approval and subject to written agreement by the recipient of the terms of this EULA. 

 

(f) SQLTREEO may terminate this EULA at any time, without notice. In such event, you must destroy all copies of the SOFTWARE and END USER PRODUCT. 

 

(g)  declares to also purchase the software for their other database servers under the current license conditions. 

COPYRIGHT AND INTELLECTUAL PROPERTY RIGHTS 

The SOFTWARE is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. The SOFTWARE is licensed, not sold. Furthermore, this EULA does not grant you any rights in connection with any trademarks or service marks of SQLTREEO. SQLTREEO reserves all intellectual property rights, including copyrights, and trademark rights.

 

 

NO WARRANTIES 

YOU ACCEPT THE SOFTWARE "AS IS," AND SQLTreeo (AND ITS THIRD PARTY SUPPLIERS AND LICENSORS) MAKE NO WARRANTY AS TO ITS USE, PERFORMANCE, OR OTHERWISE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, SQLTreeo (AND ITS THIRD PARTY SUPPLIERS AND LICENSORS) DISCLAIM ALL OTHER REPRESENTATIONS, WARRANTIES, AND CONDITIONS, EXPRESS, IMPLIED, STATUTORY, OR OTHERWISE, INCLUDING, BUT NOT LIMITED TO, IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, SATISFACTORY QUALITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, AND NON-INFRINGEMENT. THE ENTIRE RISK ARISING OUT OF USE OR PERFORMANCE OF THE SOFTWARE PRODUCT REMAINS WITH YOU. 

LIMITATION OF LIABILITY 

THIS LIMITATION OF LIABILITY IS TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW. IN NO EVENT SHALL SQLTreeo (OR ITS THIRD PARTY SUPPLIERS AND LICENSORS) BE LIABLE FOR ANY COSTS OF SUBSTITUTE PRODUCTS OR SERVICES, OR FOR ANY SPECIAL, INCIDENTAL, INDIRECT, OR CONSEQUENTIAL DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, OR LOSS OF BUSINESS INFORMATION) ARISING OUT OF THIS EULA OR THE USE OF OR INABILITY TO USE THE SOFTWARE PRODUCT OR THE FAILURE TO PROVIDE SUPPORT SERVICES, EVEN IF SQLTreeo HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN ANY CASE, SQLTreeo'S (AND ITS THIRD PARTY SUPPLIERS' AND LICENSORS') ENTIRE LIABILITY ARISING OUT OF THIS EULA SHALL BE LIMITED TO THE AMOUNT PAID BY YOU FOR THE SOFTWARE THAT CAUSED SUCH DAMAGE. 

DOCUMENTATION AND EXAMPLES 

SQLTreeo BEARS NO LIABILITY FOR ANY TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS, OR FOR DAMAGES RESULTING FROM USE OF THE INFORMATION IN ANY PROVIDED DOCUMENTATION AND/OR EXAMPLES. 

SOFTWARE UPDATES 

This license does not grant you any right to any updates to the SOFTWARE, or any support services. The SOFTWARE has built in functionality to automatically check for updates by transmitting data to the SQLTREEO servers. You agree that SQLTREEO may transfer such data over your network and the internet to SQLTREEO servers, download updates and install them as part of the SOFTWARE. 

ASSIGNMENT 

The Licensee shall not assign or otherwise transfer all or part of the Software or this Licence without the prior written consent of the Licensor. 

LAW 

The parties hereby agree that the Licence concluded between them and constituted on these terms and conditions shall be construed in accordance with English Law. 

 

Copyright © 1998-2021 SQLTreeo. All rights reserved. 

 

 





 

 

In this article