SQL Database Studio

SQL Database Studio
Original authorJan Prochazka
Stable release
3.6.2 / May 10, 2017; 9 years ago (2017-05-10)
Written in.NET WPF C#
Operating systemWindows
Available inEnglish
TypeDatabase management
Websitesqldatabasestudio.com

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. 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 4.5.

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
  • Database projects
  • SQL Editor with auto complete
  • Run SQL commands in transaction
  • Run SQL commands on multiple connections simultaneously
  • Import and export to/from formats 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 is opensource project for database operation automation)

Supported databases

References

[1] [2]

  1. ^ "SQL Database Studio". SQL Database Studio. Retrieved 2016-08-18.
  2. ^ Vladan SEGET (2014-11-19). "Another Alternative to Microsoft's SQL Management Studio - ESX Virtualization". Vladan.fr. Retrieved 2016-08-18.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.