TSQL Easy is a plugin for Sublime Text editor (ver. 2/3) that adds possibility to read/write/execute sql requests to Microsoft SQL Server and some IDE-like functionality. Server connections based on pyODBC library.
- Manage connections to SQL Servers.
- Execute sql requests on SQL Server.
- Completions of table names from server.
- Completions of table columns from server.
- Possibility to receive code of procedure, functions by text under cursor.
- Possibility to open local files with the same name as stored procedure (function, etc.): ProcedureName -> ProcedureName.sql.
- Improved syntax highlighting for TSQL.
Warning! Require server connection for work or use fake server with empty driver value for work offline without completions, etc.
Now, package includes pyODBC (3.0.7) binaries:
- Windows: ST2/3 x32/x64
- Linux: ST2/3 x64
- Pull requests are welcome! :)
The easiest way to install this is with Package Control.
- If you just went and installed Package Control, you probably need to restart Sublime Text before doing this next bit.
- Bring up the Command Palette (Command+Shift+p on OS X, Control+Shift+p on Linux/Windows).
- Temporary! Select "Package Control: Add Repository" and add
https://github.com/tosher/TSQLEasy.git
- Select "Package Control: Install Package" (it'll take a few seconds)
- Select TSQL Easy when the list appears.
Package Control will automatically keep TSQL Easy up to date with the latest version.
First find your Sublime Text 2 Packages folder:
- OS X: ~/Library/Application Support/Sublime Text 2/Packages/
- Windows: %APPDATA%/Sublime Text 2/Packages/
- Linux: ~/.Sublime Text 2/Packages/
If you have Git, you can clone this repo to "/packages-folder/TSQLEasy/"
git clone --recursive git://github.com/tosher/TSQLEasy.git
or,
Download this repo using the "ZIP" button above, unzip and place the files in "/packages-folder/TSQLEasy/"