Wednesday, April 30, 2008
Sunday, April 20, 2008
Here are some of the screenshots of it:
1) Login screen
2) Main GUI with MSSQL 2005 in action
3) Main GUI with MySQL 5.0 in action
4) Object scripting
5) Dependency viewer
For this version, it will suport MSSQL 2000 & 2005, MySQL 5.0. I am planning to include PostgreSQL connector in the next version. The features include in this version are :
- (IDE-wise) Open/Save/Drag-and-Drop file
- (IDE-wise) query pane and result pane
- (MS SQL 2000 & 2005) Object browser for system objects (Scalar function, Stored procedure, System table, Table function, Trigger, User table, View)
- (MS SQL 2000 & 2005) Object browser for security (Users, Roles, Schemas)
- (MS SQL 2000 & 2005) Object browser for constraints, columns, parameters (Columns, Keys, Constraints, Triggers, Indexes, Parameters)
- (MS SQL 2000 & 2005) Dependencies viewer for objects (Scalar function, Stored procedure, System table, Table function, Trigger, User table, View)
- (MS SQL 2000 & 2005) Object scripting for non-encrypted objects (Scalar function, Stored procedure, Table function, Trigger, View)
- (MySQL 5.0) Object browser for system objects (Scalar function, Stored procedure, System table, Trigger, User table, View)
- (MySQL 5.0) Object browser for security (Users, Privilege)
- (MySQL 5.0) Object browser for constraints, columns (Columns, Keys, Triggers)
- (MySQL 5.0) Object scripting for non-encrypted objects (Scalar function, Stored procedure, Trigger, View)
Since parts of the source code is came from MSDN, thus I think it's good to release it under Microsoft Public license (Ms-PL) to prevent any infringement, though the chance are very little.
Since I am not an expert on database, feel free to give to any constructive comment and recommendation. I will try to improve it.
Friday, April 18, 2008
Actually I first come out the idea on last year, when I was involved in a business project interface with different kind of RDBMS databases, eg. MSSQL, MySQL, FireBird, Oracle, OleDB, ODBC, .... Due to some personal reason, I was unable to continue it. With more exposure on interface design, suddenly I found it's interesting to start this project on my own. With the classes in namespace System.Data.Common, the ADO .NET programming becomes easier. Now It support MSSQL and MySQL. PostgreSQL is my next target.
While developing it, I also found few famous tools available on the market, like myLittleAdmin, Red-gate software. I hope one day my SQL tool can on-par with them. By the way, myLittleAdmin costs US$299.00.
Forget about the intro, let you all see some screenshot of it.
- MSSQL 2005
- MSSQL 2000
- MySQL 5.0
The full-source version 0.1 should be ready to download within these two weeks.
Monday, April 7, 2008
But in MSSQL 2000, this is not the case. After changing the new AD password, the MSSQLSERVER & SQLSERVERAGENT will not be updated and it will give you error message (if you start it from SQL Server Enterprise Manager: Server Group->[Instance]->Management->SQL Server Agent):
If you start it from Services.msc(Go to command prompt, type: "services.msc"), you will get the same logon error:
Due to the login account has changed, now MSSQL and SQL Server Agent cannot identify you correctly anymore, since the password it keeps is the one you saved last time. You must change the password to let it works.