Utility SQL Bin (v3.3)

1. UtilitySQL Bin (v3.3)

2. Agenda • Purpose • Target User • Benefits • System Requirement • User Guide • Introduction • Navigation • Add New SQL • Add New Version of SQL • Delete Existing SQL • Delete Existing Version of SQL

3. Purpose SQL Bin utility is designed to store all SQL statements at one place for quick and easy reference. User-friendly GUI and Version control features are its spotlight.

4. Target User • Data Conversion & Migration Team • Application Maintenance Team • Database Administration Team

5. Benefits • Version Control • Users can store multiple versions of the same SQL. • This helps users to refer the history of changes made to the SQL. • User-Friendly GUI • No need to store SQL statements in text files. • SQL Bin provides interactive and user friendly interface to store and retrieve SQL statements in organized fashion. • Users can add/delete SQL and add/delete versions of existing SQL statements with few clicks. • Portability • Due to less than 500KB size, SQL Bin is easy to share over emails. • MS Office Platform • No installation is required. • This tool is build on MS Excel. Wide acceptance of MS Office tools enable high availability of the tool as well.

6. System Requirements • Windows XP or higher. • MS Excel 2003 or higher. • Macros should be enabled in MS Excel. • Please note that Openoffice Spreadsheet is not supported.

7. Developed in MS Excel VBA environment SQL Bin is designed with the help of macros. MS Access Database SQL Bin uses MS Access Database (.mdb file) to store details in the background. It is required to keep the .mdb file at the same location as .xls file. Version Control If any change is made to the SQL statement, simply add new version for that SQL entity. This helps in tracking the changes made over the period. User Guide - Introduction

8. Navigating across SQL of different entities Using ‘Entity’ drop-down Using ‘<‘ (previous) and ’>’ (next) buttons against entity User Guide – Navigation

9. Navigating across versions of SQL statements of same entity Using ‘Version’ drop-down Using ‘<‘ (previous) and ’>’ (next) buttons against version User Guide – Navigation (…Contd)

10. Adding SQL Statement for new entity Click ‘Add’ button against ‘Entity’. This will open a new window ‘SQL Bin – Insert Entity’. Provide necessary details and click ‘Save’ Close the window. You will be redirected to main window. User Guide – Add New SQL

11. Adding new version of SQL Statement for existing entity Select the entity and click ‘Add’ button against ‘Version’. This will open a new window ‘SQL Bin – Insert Version’. Provide necessary details and click ‘Save’ Close the window. You will be redirected to main window. User Guide – Add New Version

12. Deleting SQL Statement for existing entity Select the entity and click ‘Del’ button against it. This will delete the selected entity and all its version. User Guide – Delete Existing SQL

13. Deleting specific version of SQL Statement for existing entity Select the entity. Select the version to be deleted. Click ‘Del’ button against it. This will delete the selected version. User Guide – Delete Existing Version

14. Thank you !