Discussion on SQL Query Analyzer Form

gustav12

gustav12 supports this item

Supported

6 comments found.

Does it work with Oracle?

Thanks that is great. Couple of other questions 1) does it work with win7 & 2) does it come with source code.

Yes, it works on any Windows with .net framework from 2.0 to 4.5 and it comes with full source code

Now supporting Oracle!

is this a web base tool or client ? and what level of trust it works on

it’s a windows form client based tool, the trust level depends on your environment setup

can we create tables or modify tables

of course, you dont have any limitations, you can create tables, procedures, functions, the tool just executes any query against your DB, like you’d do it with official tools like SQL Server Managment Studio.

Nice application, looks like an app I would be considering to buy.

1) will it show all the assets of the db, Stored Procs, Functions, Views, Users etc, just like sql studio 2) will it also connect to mySql 3) can it create sql dynamically, see below examples.

These two are there some are pricey, some free

Free (pay for source code) http://tiny.cc/bvgz3w Free with watermark, paid for personal branding http://tiny.cc/mrgz3w

Thanks for your interest! at this momment it shows Stored procedures, functions and tables. But i will be extending the tool by adding Views and Users as you gave me the idea. And it can not create sql dinamically, you have to write it.

Gustav, thanks for the reply. I think it will be more useful and more people will purchase if you could put the dynamic sql creation. Can you please let me know if this is planned. -Dynamic SQL -Web MVC project sample – drag and drop table

Dynamic sql creation can be really useful, and i think i can start planning a new project like that. By now, i will add features like connect to MySQL and Access, and display some other db objects..

Hi, your comment said you will be extending it last year, and I purchased, but nothing as yet?

It would be move useful if you can give the developers

an abstract interface object with a collection to get 1) schema 2) tables 3) columns / corresponding data types in .NET C# and 4) with an observable change like IObservable
it will integrate well with the needs of developers and lot of code. For more application use, if you could give a table to store these values as a collection automatically it would be more practical to implement inside an application.
an a DAL object with a collection to SAVE/GET/EDIT persistence 1) schema 2) tables 3) columns / corresponding data types in .NET C# and 4) version information inside the DB

this would go farther

Does this support MySQL ?

i’ve never tried, but it should work as the sql queries used are the same for MySQL. You only need to add the connectrion string inside the .config file, and install the required libraries for mysql connections.

i’ve never tried, but it should work as the sql queries used are the same for MySQL. You only need to add the connectrion string inside the .config file, and install the required libraries for mysql connections.

Very nice work! Congrats!

by
by
by
by
by
by