Jump to content

SQL Database Studio

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by BG19bot (talk | contribs) at 06:08, 20 November 2014 (WP:CHECKWIKI error fix for #93. External link with double http:// Do general fixes if a problem exists. -, replaced: http://Http:// → http:// using AWB (10497)). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Template:Unreviewed

SQL Database Studio is professional client for Microsoft SQL Server developed by Jan Prochazka in Czech Republic. SQL Database Studio (SDS) is used by database developers for designing database and also by average users for browsing data. Its feature set is rich for advanced database operations and for advanced browsing data. SDS comes in two version. EXPRESS version is free even for commercial purposes but lacks some features that are in PRO version. SDS allows visualization of GPS data. It is built using WPF application running on Microsoft .NET Framework.

Feature summary

  • GPS Visualization allows showing location data in map and exporting map
  • SQL Query Designer
    • Support for SELECT, INSERT, UPDATE queries
    • Specific join operators - WHERE NOT EXISTS, CROSS APPLY, OUTER APPLY
  • Database schema visualization
  • Table column's filter
  • Storing database connections in projects
  • SQL Editor with auto complete
  • Run SQL commands in transaction
  • Rrun SQL commands on multiple connections simultaneously
  • Import and export to/from various formats such as MS Excel, CSV, DBF
  • Saving SQL scripts in projects not affecting database
  • Database configuration with setting risk levels (Development database, production database)
  • Data widgets (simple queries saved in database project, which are bind to some table, application than shows results of query while browsing table data)
  • Database Jobs designer
  • Switching between various GUI layouts
  • DbShell Console (DbShell is opensource project for database operation automation)

Supported databases

References

http://sqldatabasestudio.com/