1. 同时连接多种不同类型的数据库,
大型数据库如:Oracle,Sybase,MS SQL,DB2
中型数据库MS_Access,MySQL
桌面型数据库Paradox,DBF系列数据库,MS Execl,Text,可以直接托放解释
其他支持SQL 92标准的数据库 2. 遍历数据库中表、视图、存储过程、自定义函数.
系统表(仅支持MS SQL,Sybase)
同义词、程序包、动态性能视图(仅针对Oracle) 3. 内嵌本人开发的强大功能的SQL Builder & Parser
这是本软件的核心价值之一,参见SQLBuilder.chm 4. 生成表的数据字典信息,并输出为Excel 文件、Html文件
这是本软件的核心价值之二 5. 生成数据库对象的DDL,并可重建数据库对象,并可导出到SQL脚本文件
这是本软件的核心价值之三 6. 多语言版本,目前有简体中文、英文、繁体中文版本。
由于使用了比较好的接口,哪位好心的朋友可以帮忙翻译以下别的语言版本。
下载地址:http://SharkXu.cnblogs.com/admin/Shark_DB_Expert.zip
大型数据库如:Oracle,Sybase,MS SQL,DB2
中型数据库MS_Access,MySQL
桌面型数据库Paradox,DBF系列数据库,MS Execl,Text,可以直接托放解释
其他支持SQL 92标准的数据库 2. 遍历数据库中表、视图、存储过程、自定义函数.
系统表(仅支持MS SQL,Sybase)
同义词、程序包、动态性能视图(仅针对Oracle) 3. 内嵌本人开发的强大功能的SQL Builder & Parser
这是本软件的核心价值之一,参见SQLBuilder.chm 4. 生成表的数据字典信息,并输出为Excel 文件、Html文件
这是本软件的核心价值之二 5. 生成数据库对象的DDL,并可重建数据库对象,并可导出到SQL脚本文件
这是本软件的核心价值之三 6. 多语言版本,目前有简体中文、英文、繁体中文版本。
由于使用了比较好的接口,哪位好心的朋友可以帮忙翻译以下别的语言版本。
下载地址:http://SharkXu.cnblogs.com/admin/Shark_DB_Expert.zip
你的MySQL连接是自己写的吗?还是MySQL的哪个连接类?
关于:MySQL的连接, MySQL 官方网站上提供的。你可以去下载
对于ODBC数据源,使用了System.Data.ODBC.....,但是要得到ODBC中隐藏的数据表列表,却需要自己写。
对于Ms Access使用了System.Data.OleDB........
抽空来顶一下!
正确的是:
http://www.cnblogs.com/Files/SharkXu/Shark%20DB%20Expert.zip
怎么能骗人?
你下载的是这个地址:http://www.cnblogs.com/Files/SharkXu/Shark%20DB%20Expert.zip
首先,我又试过了一次,再没有弄清楚什么原因之前,最好不要下结论。
也许是你自己的解压出错。你是不是解压的时候,点中了setup.exe文件,如果这样的话,你重新解压一下。
如果你还有问题的话,我直接发MAIL给你,请留下你的EMAIL.
SQL Builder & Parser 说说实现,是去Parser SQL字符串吗?
怎么做得做Oracle的EMC,又像MS的Explorer.
用起来应该很方便吧.
使用帮助在哪?
我以前做过一个类似的绿色的东西,http://www.onlinedown.net/soft/8618.htm
现在这一个功能比以前的要多,而且修补了很多bug. 但是现在这个必须要安装了.NET Framework 1.1才可以使用。我也曾经想过做成delphi 版本的无需安装的软件,但是没有太多的时间。
1、支持SQL查询语句绝大部分语法
1.1 选择字段
1.1.1 Select [All] [Distinct];
1.1.2 特殊语法,记录条数限定Top(MS_SQL),Rownum(Oracle),
Limit(MySQL),Set RowCount(Sybase))
1.1.3 字段表达式或者计算字段
1.2 选择表 (From)
1.3 条件筛选 (Where)
1.4 分组 (Group By)
1.5 组内条件 (Having)
1.6 排序 (Order By)
1.7 数据表的内连接、外连接
1.7.1 SQL 92 标准:Inner Join、Left Join、Right Join、Full Join,
1.7.2 特殊语法:*=、=*、*=*(MS_SQL,Sybase),(+)(Oracle)
1.8 联合 (Union [All],Minus,Intersect)
1.9 字段别名,数据表别名
1.10 SQL子查询表,内嵌SQL子句 2、粘贴字段、系统函数(目前系统包括的函数包括Oracle、Sybase、MS SQL、Excel等) 3、SQL查询语句反向分析,
无论多么复杂的语句,都能分析得出来
包括上面提到的所有SQL语法 4、SQL文件拖放,然后反向分析 5、数据库视图创建和重建(目前仅支持Oracle,Sybase,MS_SQL) 6、SQL语句智能换行,尤其是外连接语法部分,结构非常清晰 7、多语言版本,支持VS.NET外接程序 8、其他功能
8.1 SQL文件保存、打开
8.2 SQL语句关键词高亮度显示
8.3 SQL查询语句转换为Delete,Update,Insert语句
8.4 复制为字符串(支持对Java、C#、Delphi、VB、PowerBuilder开发语言的支持)
8.5 查询结果输出为SQL脚本文件、Excel文件、文本文件、XML文件
http://www.cnblogs.com/images/cnblogs_com/sharkxu/62378/t_DBObjectList.bmp
http://www.cnblogs.com/images/cnblogs_com/sharkxu/62378/t_SQLBuilderParser.bmp
请参阅此消息的结尾。************** 异常文本 **************
System.NullReferenceException: 未将对象引用设置到对象的实例。
at Crownwood.Magic.Menus.PopupMenu.InternalTrackPopup(Boolean selectFirst)
at Crownwood.Magic.Menus.PopupMenu.TrackPopup(Point screenPos, Boolean selectFirst)
at Crownwood.Magic.Menus.PopupMenu.TrackPopup(Point screenPos)
at Shark.Tool.SQLBuilder.Form.TFormMain.ObjectList_PopUp(MouseEventArgs e)
at Shark.Tool.SQLBuilder.Form.TFormMain.ObjectList_MouseUp(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
just-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Invalid column name 'Name'.
Invalid column name 'ID'.
Invalid column name 'Name'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Shark.DbAccess.SqlDbAccess.Fill(IDbCommand dbCommand)
at Shark.DbAccess.SqlDbAccess.Fill(String sql, IDataParameter[] paramsArray, CommandType commandType)
at Shark.DbAccess.SqlDbAccess.Fill(String sql, IDataParameter[] paramsArray)
at Shark.DbAccess.SqlDbAccess.Fill(String sql)
at Shark.Data.DB.GetDataTable(String sQL)
at Shark.Data.DBInfo.ObjectDictionary.GetDictionaryInMSSQL()
--- End of inner exception stack trace ---
at Crownwood.Magic.Menus.PopupMenu.InternalTrackPopup(Boolean selectFirst)
at Crownwood.Magic.Menus.PopupMenu.TrackPopup(Point screenPos, Boolean selectFirst)
at Crownwood.Magic.Menus.PopupMenu.TrackPopup(Point screenPos)
at Shark.Tool.DBExpert.Form.FrmMDIParent.tvConnection_MouseDown(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.TreeView.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
DBExpert
Assembly Version: 1.6.0.0
Win32 Version: 1.6.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/DBExpert.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
MagicLibrary
Assembly Version: 1.7.4.0
Win32 Version: 1.7.4.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/MagicLibrary.DLL
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
Shark.Common
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Shark.Common.DLL
----------------------------------------
Shark.Windows.UI
Assembly Version: 1.0.2361.37796
Win32 Version: 1.0.2361.37796
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Shark.Windows.UI.DLL
----------------------------------------
DBExpert.resources
Assembly Version: 1.6.0.0
Win32 Version: 1.6.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/en-US/DBExpert.resources.DLL
----------------------------------------
DBExpert.resources
Assembly Version: 1.6.0.0
Win32 Version: 1.6.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/en/DBExpert.resources.DLL
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
Shark.Data
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Shark.Data.DLL
----------------------------------------
Shark.DbAccess
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Shark.DbAccess.DLL
----------------------------------------
Shark.Tool.SQLBuilder
Assembly Version: 3.0.0.0
Win32 Version: 3.0.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Shark.Tool.SQLBuilder.DLL
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
Shark.Tool.SQLBuilder.resources
Assembly Version: 3.0.0.0
Win32 Version: 3.0.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/en/Shark.Tool.SQLBuilder.resources.DLL
----------------------------------------
System.EnterpriseServices
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2300
CodeBase: file:///d:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
----------------------------------------
Accessibility
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///d:/windows/assembly/gac/accessibility/1.0.5000.0__b03f5f7f11d50a3a/accessibility.dll
----------------------------------------
Shark.Windows.UI.SQLEditor
Assembly Version: 1.0.2361.37798
Win32 Version: 1.0.2361.37798
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Shark.Windows.UI.SQLEditor.DLL
----------------------------------------
Interop.TTF160
Assembly Version: 6.1.0.0
Win32 Version: 6.1.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/Interop.TTF160.DLL
----------------------------------------
Shark.Data.resources
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///F:/Program%20Files/Shark/DB%20Expert/en/Shark.Data.resources.DLL
----------------------------------------************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.For example:<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
--Some Errors when get DDL of dtproperties
------------------------------------------------------
--Some Errors when get DDL of rp_activecustomer
------------------------------------------------------
--Some Errors when get DDL of rp_weeklysales
------------------------------------------------------
--Some Errors when get DDL of tbl_accrual
------------------------------------------------------
--Some Errors when get DDL of tbl_admin
------------------------------------------------------
--Some Errors when get DDL of tbl_admin_area
------------------------------------------------------
--Some Errors when get DDL of tbl_billing
------------------------------------------------------
--Some Errors when get DDL of tbl_billing_address
------------------------------------------------------
--Some Errors when get DDL of tbl_cardtype
------------------------------------------------------
--Some Errors when get DDL of tbl_customer
------------------------------------------------------
--Some Errors when get DDL of tbl_eigen_transaction
------------------------------------------------------
--Some Errors when get DDL of tbl_emailtask
------------------------------------------------------
--Some Errors when get DDL of tbl_function
------------------------------------------------------
--Some Errors when get DDL of tbl_intamac_hardware
------------------------------------------------------
--Some Errors when get DDL of tbl_intamac_property
------------------------------------------------------
--Some Errors when get DDL of tbl_intamac_task
------------------------------------------------------
--Some Errors when get DDL of tbl_intamac_transaction
------------------------------------------------------
--Some Errors when get DDL of tbl_kit
------------------------------------------------------
--Some Errors when get DDL of tbl_location
------------------------------------------------------
--Some Errors when get DDL of tbl_log
------------------------------------------------------
--Some Errors when get DDL of tbl_log_activity
------------------------------------------------------
--Some Errors when get DDL of tbl_log_detail
------------------------------------------------------
--Some Errors when get DDL of tbl_mdm_order
------------------------------------------------------
--Some Errors when get DDL of tbl_order
------------------------------------------------------
--Some Errors when get DDL of tbl_order_detail
------------------------------------------------------
--Some Errors when get DDL of tbl_pap_transation
------------------------------------------------------
--Some Errors when get DDL of tbl_payment
------------------------------------------------------
--Some Errors when get DDL of tbl_product
------------------------------------------------------
--Some Errors when get DDL of tbl_product_rate
------------------------------------------------------
--Some Errors when get DDL of tbl_product_type
------------------------------------------------------
--Some Errors when get DDL of tbl_promo_code
------------------------------------------------------
--Some Errors when get DDL of tbl_province
------------------------------------------------------
--Some Errors when get DDL of tbl_question
------------------------------------------------------
--Some Errors when get DDL of tbl_recurrence
------------------------------------------------------
--Some Errors when get DDL of tbl_report_function
------------------------------------------------------
--Some Errors when get DDL of tbl_report_permission
------------------------------------------------------
--Some Errors when get DDL of tbl_report_user
------------------------------------------------------
--Some Errors when get DDL of tbl_returncode
------------------------------------------------------
--Some Errors when get DDL of tbl_role
------------------------------------------------------
--Some Errors when get DDL of tbl_role_area
------------------------------------------------------
--Some Errors when get DDL of tbl_role_permission
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_activecustomer
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_csractivity
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_delayactivation
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_hardwaresales
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_monthservicerevenue
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_multilocation
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_promocodeuptake
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_telesales
------------------------------------------------------
--Some Errors when get DDL of tbl_rp_weeklysales
------------------------------------------------------
--Some Errors when get DDL of tbl_serial
------------------------------------------------------
--Some Errors when get DDL of tbl_status
------------------------------------------------------
--Some Errors when get DDL of tmp_location
------------------------------------------------------
--Some Errors when get DDL of tmp_order
------------------------------------------------------
--Some Errors when get DDL of tmp_order_detail
------------------------------------------------------
我晚上回去试了一下,没有发现你所说的问题。估计是有很特殊的情况,所以恳请你告诉详细地联系方式,以便与你取得联系,获取更详细当时的运行环境。谢谢!
Shark Xu
2006-07-03
还有个问题,为什么不支持ACCESS下的DDL生成。如果只能支持sqlserver的话,意义就不是太大了,因为MS已经做得很好了
有道理
另外希望几位给我提出Bug的朋友,能够给我Mail. 我想切实了解当时的非常具体的情况.
因为我自己没有发现这种情况,应该是我还有某些地方,没有考虑到.