SQLGate for MSSQL is a development tool for the Microsoft SQL Server that executes various SQL and manages the procedure conveniently and diversely.
SQLGate for MSSQL features
SQL Gate for MSSQL connects to the server in the OLE/DB form without installation of the MSSQL Server Client.
The tool makes managing a number of SQL servers easy because it provides functions of Import/Export/Query Builder and connects to several SQL servers at once.
SQLGate for MSSQL requires OLE DB installed on workstation.
In current versions of Microsoft Windows, as Windows 2000, OLE DB is already installed as a standard package.
However, it's highly recommended to download latest version (newer than 2.5) of
Microsoft Data Access Components (MDAC) at
http://www.microsoft.com/data
Connection to the SQL Server without installation of the SQL Server Client
Processing multiple queries by Multi-thread
Viewing/Editing information on the table (data/columns/indexes/ constraints/triggers/script)
Exporting data in 12 formats
( MS Excel, MS Word (RTF), HTML, XML, TXT, CSV, SYLK, DIF, LaTeX, SQL and Windows Clipboard )
Importing data from DBF, MS Excel, TXT, CSV
Query builder that creates SQL clauses simply by drag & drop
Converting results from processing SQL qyeries into the web script (ASP, JSP, PHP)
Two types of Table Reporting table schema; Report and Excel
Table Wizard that creates tables in an easy and simple way
Viewing schema by clicking a mouse anytime
Main Features
Login It is easy to Connect to the database server.
It shows the list connected in the past and provides a function to connect the server previously used.
Multi Query / Plan Developers and DBA can send a number of queries to the server and gett a number of results at the same time.
This function allows developers to veiw a number of conditions so that they can compare the data easily.