Go to Main page..
Old articles you may read here
Go to Main page
SQL Dynamite , Microsoft SQL Server
| good day I want to introduce you to my SQL program Dynamite, which can do a search for objects and line entries in the following DBMS: - MSSQL 2000, 2005, 2008, 2008 R2 - Oracle 9, 10, 11 - DB2 9.x - PostgreSQL 8.x or higher - MySql 5.x - Firebird 2.x - Sybase ASE 12, 15 - Sybase Anywhere from 5.5 to 12 - Ingres 9, 10 System requirements: MS Windows XP / Vista / 7 or MS Windows Server 2003/2008: Microsoft .NET Framework 4.0, Microsoft F # Redistributable 2.0 Linux: Mono Framework version 2.6.x, F # 2.0 or higher Mac OS X: Mono Framework version 2.6.x, F # 2.0 or higher The program itself is absolutely free and you can download it at this address. http://rghost.net/22582161 I will attach the site to it later. Who needs to take, reviews are attached |
|
| The program is really convenient. For a long time I was going to write something similar myself. Thank you very much. The only thing is, either link to the f # distribution or include the necessary libraries in the archive. And then I had to look ...
And why decompile it? |
| And why do you need to decompile the program? |
| to make sure it doesn’t include malicious code? |
| Of course, it would be necessary to transfer it from the file storage to the official site so that the people would not strive so much Already made a site - while it is empty http://firelizardsoftware.com/ |
And the source is easier to understand than to arrange quarantine. This is not to mention the fact that it is impossible to correct errors, expand the functionality, support the crutch (so simple). Not open source somehow looks strange. Or do you want to monetize? I even thought about the licensing of Mono, but there it seems MIT, so it seems like the source can not spread. Or not (i.e. must)? In copywriting is not strong. |
| Honestly, I’m thinking about monetizing in the future. I hope you do not see anything wrong with that. |
| Laid out the new version, it does not require F # Redistributable and can work with SQL Azure Now on the official site http://firelizardsoftware.com/ |
| Between messages, an interval of more than 1 year. |
| Version 1.2 released - SQLite and Informix support added http://habrahabr.ru/company/host-tracker/blog/210434/ Download here: http://www.host-tracker.com/SqlDynamite |
|
On the website, the link for downloading the installer is incorrect - it points to https://bitbucket.org/temofey/sqldynamiteinstall/downloads/SqlDynamiteSetup.exe , but you need to https://bitbucket.org/temofey/sqldynamiteinstall/downloads/SQL Dynamite 1.2.5320.35162 .exe The author would attend to this fix. |
Well, and further: the first thing I found right away - for databases with case-insensitive collation, the Match Case daw does not work, because judging by the contents of MsSqlMetadataFinder.GetNameByTextColumns, the search is done by clicking on syscomments (and also by other methods on the name field in syscolumns , sysobjects, etc.) in combination with coercion / non-coercion to one register - but for case-insensitive collation case when 'ABC' like 'abc' then 1 else 0 end select case when 'ABC' like 'abc' then 1 else 0 end issues 1. In this case it is collation_name from sys . select collation_name from sys . name = 'stuff' database where name = 'stuff' collation_name And yes, since this thing is under Fw 4.0 and WPF - would it not be difficult to set in the window markup TextOptions.TextFormattingMode = "Display" UseLayoutRounding = "True"- otherwise the default blur of fonts in WPF somehow hurts the eye |
| Thank you very much for the comments, I did not even know about this joke with Collation. As for fonts: indeed, the whole program is written for WPF, but the control with syntax highlighting is a user control from Windows Forms because WPF backlight is terribly slow (namely, the ApplyPropertyTag method, if interested). And I certainly will continue to develop the program, taking into account the wishes of users. PS Link to download also fixed. |
| Laid out version 1.5 - added support for heaps of OLE DB drivers, the configuration window became more convenient, and fixed a couple of bugs. In version 1.6 I hope to add Interbase. |
| 1. It would be necessary to improve the interface of the dialogue of the connection to the server, first you need to make a choice of server type, after that for each type of server to give a specific dialogue, and not try to stick everything into a universal dialog for all occasions. 2. after launching, I tried to give a line to search and search, I could not immediately understand that I had to again (?!) in the search id DB line to select the name of the sql server instance, what for it was a mystery, because I had already chosen it when I connected. If there was a base in mind, then you should show a list of databases, which would be logical, and not the server instances. In addition, after connecting, it is not clear in which database the search is done. 3. Search the list of databases? accordingly show on the left another column Base 4. It would be nice to make an additional column the number of occurrences found. 5. It would be nice to add Search options for sure, search for a whole word, etc. |
| Made version 1.6, added support for Interbase and search for synonyms and types Also corrected point 2 from the last post. Take in the same place. |
| Good day everyone Released version 1.6.1 (mostly bug fixes, also added support for the Sybase ASE OLE DB Provider). Take in the same place. |
| Released version 1.6.2 - changes for the Windows version only (highlighting the entries) so that the Linux / Mac versions are not touched. Take in the same place. |
| Good stuff. Fit. Respect, countryman. |
| Thanks for the warm feedback. In version 1.7, a search by SSRS reports has been added, as well as a search in JOBS for MSSQL, Oracle, Ingres, MySQL and SQL Anywhere. Take in the same place. |
| Version 1.7.1 with bug fixes - take it there. |
| Fixed the latest bugs noticed by users (mainly related to MSSQL and Interbase) Take in the same place. |
| The next release - 1.7.3 - to take there. |
| and how to connect it? Installed on the same machine on which MS SQL 2008. Does not want to connect with all sorts of options to configure the connection. |
| RizONE show a screenshot please (windows with connection parameters and windows with an error) By the way, I updated the program to version 1.7.4 - now generation of scripts for creating CLR procedures, functions and triggers is supported. SQL Server 2000 from this version is no longer supported. Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| In version 1.7.6, syntakis highlighting has been improved and DDL generation of aggregate functions has been added in MSSQL. Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| In version 1.7. 7 fixed bugs with generation of DDL indexes and primary keys in MSSQL and Sybase. The rest is unchanged. Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| In version 1. 8 fixed bugs with generation of DDL indexes and primary keys in MSSQL and Sybase. The rest is unchanged. Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| Damn skopipasti not :) In version 1. 8 added a class generator for C #, VB.NET and F #. Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| Meet version 1.9 1) Added support for UltraLite DBMS 2) Added Schema Comparison Wizard (currently only basic functionality and only for Oracle, MSSQL, SAP ASE and SAP SQL Anywhere) 3) DSN is no longer needed to connect to SAP SQL Anywhere Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| 11 years after the start of development, version 2.0 was released Fixed bugs and added support for the first database NoSQL - MongoDb Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/SqlDynamiteSetup.exe |
| Version 2.1 released Added support for HPE Vertica DBMS for Big Data Take here: https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
what about support for postgresql? |
Supported by |
| Looks like a bug. Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 10586:) table Test ( create table Test ( Testfield int ) When searching by the word TestField, the table falls into the results: when enabled, that when the "Tables" option is disabled |
Many thanks for the bug report, the next version will be fixed. |
| Bug fixed. It also seems that the program will need to be renamed to NOSQL Dynamite because support for Cassandra and Redis has been added. Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| Version 2.1.2 released with support for Azure Redis Cache Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| Dark Elf, When searching Cannot resolve collation conflict between "Cyrillic_General_CI_AS" and "Cyrillic_General_CS_AS" in the UNION ALL operator occurring in ORDER BY statement column 2. Base "Cyrillic_General_CS_AS" If you uncheck "Jobs" then everything is OK. |
| Thanks for the bugreport In version 2.1.2.1 this bug is fixed. https://bitbucket.org/temofey/sqldynamiteinstall/downloads |
| Version 2.1.2.2 fixes 2 past bugs related to Sybase and SQL Server Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| Version 2.1.2.3 fixes user interface related bugs and Interbase Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| In version 2.1.2.4, to connect to Ingres DBMS, DSN is no longer needed Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| In version 2.1.2.5, the display of stored procedures / scripts for SSRS reports in the case of using SQL Server 2016/2017 has been fixed. Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| Between messages, an interval of more than 1 year. |
| Version 2.1.3 adds support for Sybase Advantage Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| Version 2.1.3.1 released with improved support for Redis and bug fixes Take in the same place https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| Win XP, when installing from the account without admin rights, does not create the installation directory, if the directory is created by hand, it does not copy files there, but the installer correctly completes without any errors and warnings. |
| This is most likely because I started using NSIS 3 to create an installer for Windows. Now I have assembled the installer using NSIS 2.46 and laid out the old one. Would you like to try installing it again? https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
Why NSIS? some kind of perversion ... |
| Chet did not help this witch, does not swear |
| What do you propose instead of NSIS? |
WiX hands to do, anyway all sorts of svoyadt everything to this. Can Wix # take: http://www.csscript.net |
| Laid out the new installer under Windows (made without NSIS). Maybe it will work fine under Windows XP. |
Yes, now before installing the installer checks the rights, if not the admin - sends the forest |
| Thanks for the feedback, subsequent installers will be created using Inno Setup. |
not one garbage, so another  In WiX, the admin rights problem (see previous messenger) is solved in one line, but you persist with all sorts of lotions |
| Version 2.1.3.2 released with bug fixes related to Firebird and Interbase Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| In version 2.1.3.3 added support for Firebird 3, Interbase 2017 and MongoDb 4 Firebird versions below 2.5 and versions of MongoDb below 3.4 are no longer supported. Take in the same place: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
| The second release today (this time 2.1.3.4), which fixed errors that occurred when working with Interbase / Firebird / SAP Anywhere / SAP Advantage / SAP Ultralite / SQLite Take as always here: https://bitbucket.org/temofey/sqldynamiteinstall/downloads/ |
Old articles you may read here
Go to Main page