Menu

#1 Allow inserting a db instance name in "compare" mode

open
nobody
None
5
2006-04-26
2006-04-26
Anonymous
No

The project is very nice.
However, it seems to lack some support when the user
wishes to manually write a server instance name in
the "compare" mode.
The main problem is caused because sometimes the
SQLDMO.Application does not list all available
servers. In addition, the user might want to set the
instance name manually, when it is not in the local
network (or not in the local machine).
To solve the issue, I suggest changing the code in the
ToolBar1_ButtonClick event (in frmDBCompare.vb,
located in DataBaseComparer folder) as follows:
Instead of:
''''begin''''
If cboServer1.SelectedIndex > -1 And
cboServer2.SelectedIndex > -1 Then
''''end''''

Replace with:
''''begin''''
If (cboServer1.Text.Length <> 0) And
(cboServer2.Text.Length <> 0) Then
''''end''''

And in the design view, change each combo's
DropDownStyle property to "DropDown" (instead
of "DropDownList")

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.