I need a VS 2017 project that creates an add-in for SSMS 2018 to show history of the execution of scripts and periodic time views of the sql code changes in the code editor.
These two events need to be captured.
1. Each time a SQL statement(s) are executed in the code editor, the SQL statements will be written to the database based on what was selected for execution.
2. A user specified threaded timer to monitor activity of the code editor, if changes have occured based on the timer option, it will store SQL in the code editor to the database. A tool bar menu option will allow user to specific timer interval.
A custom add-in window on the right will allow users to review what has been stored in the database.
the set timer to capture and display in custom window the history of query activity at 3 minute intervals. In addition to history being maintained in the add-in window, the history will be written to a local sql server database file. The table only needs to have the following columns, servername, dbname, timestamp, and sqlquery.
When a query is executed, the add-in will automatically add to the history window. Each entry in the history window will have the timestamp associated with it and stored in the local SQL database.
VS 2017 Solution for SSMS 2018
-Project for SQL Addin
-Project for installer
Written in C#
Compatible with SSMS 2018
Developer needs to have experience with this SQL or VS addins, if you do not have experience, then do not bid.
There are examples of this type of addin on the internet and many commercial add-ins have this feature.
19 фрилансеров(-а) в среднем готовы выполнить эту работу за $217
I am a professional in sql server and vb.net c# I hope to get a chance for this job I am a specialist in databases and I hope you visit my portiflo