Go to Main page..

SQL Dynamite , Microsoft SQL Server





SQL Dynamite [new]
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
Re: SQL Dynamite [new]
Dark elf
Who needs to take, reviews are attached
Where's the repo link? And then "decompile" somehow reluctantly.
Re: SQL Dynamite [new]
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 ...


author
And then "decompile" somehow reluctantly.


And why decompile it?
Re: SQL Dynamite [new]
And why do you need to decompile the program?
Re: SQL Dynamite [new]
to make sure it doesn’t include malicious code?
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
Zaitsev Fedor
bad code
Moreover, the hazards are very diverse.
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.
Re: SQL Dynamite [new]
Honestly, I’m thinking about monetizing in the future.

I hope you do not see anything wrong with that.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
Dark elf
Download here:

http://www.host-tracker.com/SqlDynamite
What is it ? Oops, you've found a dead link.
Re: SQL Dynamite [new]
LSV
What is it ? Oops, you've found a dead link.

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.
Re: SQL Dynamite [new]
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 
-------------------------------
SQL_Latin1_General_CP1251_CI_AS

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
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
Good stuff. Fit.
Respect, countryman.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
Version 1.7.1 with bug fixes - take it there.
Re: SQL Dynamite [new]
Fixed the latest bugs noticed by users (mainly related to MSSQL and Interbase)

Take in the same place.
Re: SQL Dynamite [new]
The next release - 1.7.3 - to take there.
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
Version 2.1 released

Added support for HPE Vertica DBMS for Big Data

Take here:

https://bitbucket.org/temofey/sqldynamiteinstall/downloads
Re: SQL Dynamite [new]
Dark elf
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?
Re: SQL Dynamite [new]
Rolg Hupin

what about support for postgresql?


Supported by
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
Noskov
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.
Re: SQL Dynamite [new]
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
Re: SQL Dynamite [new]
Version 2.1.2 released with support for Azure Redis Cache

Take in the same place

https://bitbucket.org/temofey/sqldynamiteinstall/downloads
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
Thanks for the bugreport

In version 2.1.2.1 this bug is fixed.

https://bitbucket.org/temofey/sqldynamiteinstall/downloads
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
Version 2.1.2.3 fixes user interface related bugs and Interbase

Take in the same place:

https://bitbucket.org/temofey/sqldynamiteinstall/downloads/
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
Version 2.1.3 adds support for Sybase Advantage

Take in the same place:

https://bitbucket.org/temofey/sqldynamiteinstall/downloads/
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
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.
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
Dark elf
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 ...
Re: SQL Dynamite [new]
Chet did not help this witch, does not swear
Re: SQL Dynamite [new]
What do you propose instead of NSIS?
Re: SQL Dynamite [new]
Dark elf
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
Re: SQL Dynamite [new]
Laid out the new installer under Windows (made without NSIS). Maybe it will work fine under Windows XP.
Re: SQL Dynamite [new]
Dark elf
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
Re: SQL Dynamite [new]
Thanks for the feedback, subsequent installers will be created using Inno Setup.
Re: SQL Dynamite [new]
Dark elf
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
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
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/
Re: SQL Dynamite [new]
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






ZZZZZZZZZZZZ