7 comments found.
Nice work, but will like to know if you are open for further customization on the application for us
Hi! what kind of customizations do you need?
Oh thank you for your quick response. I want it to have an audit trail so that whatever query performed on the analyzer is being logged into a different database against the User
My email address is kayodejohnson@gmail.com you can send me your WhatsApp no., or skype for faster communication
Very nice work! Congrats!
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.
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 IObservableit 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
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/mrgz3wThanks 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..
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.
Does it work with Oracle?
It will support Oracle with the next update in 2 days.! thank you for your interest!
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!