OpenDBiff Work Item Rss Feed

Created Issue: Erro on database comparison [9079]

skidancer — Fri, 30 Oct 2009 14:47:48 GMT

The comparison starts to run and then fails with the error message "Invalid database connection. Please check the database connection. The method or operation is not implemented"

Closed Issue: Returning the script through command prompt execution. [5453]

Grimpi — Sat, 17 Oct 2009 10:55:38 GMT

I like this tool very much.
A function that would be really useful would be to return the script using the command prompt and providing the connection strings as parameters. It would be interesting for the installer generation created using MSBuild or NAnt, then you could update even the test DB environment.
I would like to contribute to this project, especially for this functionality´s implementation.
Comments:

Closed Issue: Constraints not appearing in the 'Old Object' window. [7919]

Grimpi — Sat, 17 Oct 2009 10:55:13 GMT

When I view a table, the Constraints appear in the 'New Object', but are missing from the 'Old Object' (This happens even if the Source and Destination are the same database). The actual comparision routine appears to be correct as the 'Synchronized Script' is empty.

From stepping through the source code, it would appear that it is calling the Database.Clone method ( origenClone = (Database)origen.Clone(null);) which does not clone the Constraints.

Also, whilst debugging this I got into a sceneraio where it repeatedly called the comparsion routines. It was calling the ProgressForm_Activated event, so I think the last line in the following section of code set IsProcessing true rather than false.

private void ProgressForm_Activated(object sender, EventArgs e)
{
if (!IsProcessing)
{
this.Refresh();
IsProcessing = false;
Comments:

Closed Issue: Database List not updated when changing "Server Host" (typing, not picking-from-list) [8866]

Grimpi — Sat, 17 Oct 2009 10:55:13 GMT

If I select a "Server Host" - see the list of databases in the list - good. Then I type in the name of a different "Server Host". If I drop down the list of databases, I see the list from the previous server. I can force the list to re-load by selecting a different Authentication (and then back to the one I want).

Looks like you have some logic tied to clicking a list item that needs to be run when changing the text in the combo.
Comments:

Closed Issue: "USE" Statement should include brackets [8865]

Grimpi — Sat, 17 Oct 2009 10:54:58 GMT

The Synch script should include brackets around the database name in the USE statement. For example, if my destination database has a period in it, the statement will be invalid.

For example,
USE MyDatabase_v2.0
GO

is not right, but:
USE [MyDatabase_v2.0]
GO
Comments:

Closed Issue: bookmarks for connection [7972]

Grimpi — Sat, 17 Oct 2009 10:54:49 GMT

A simple bookmark management dialog would be great.
This would reduce my typing work at the beginning of comapring of two databases each time.

perhaps i can helping by the little feature?

Are you planning to use source code control system of codeplex?

best regards
Christian
Comments:

Created Issue: Comparing a .dbproj VStudio Database project with a Database [8915]

michaelAngelo — Mon, 05 Oct 2009 15:25:13 GMT

Hello,
do you intend to implement a comparison between a database and a database project (.dbproj), which is generated using Visual Studio DBPro?

This is implemented in the SchemaCompare tool in that same package by Microsoft, but the feature i am looking for is the ability to generate a diff script, while the MS tools always generates a Create script..

The DB project creates a .dbmeta file. I don't know if this is helpful in this regard..

PS: i am refering to this
http://msdn.microsoft.com/en-us/teamsystem/cc308636.aspx

this is the new Microsoft environment for interacting with databases, but as you see it has its issues, if your program can accept input from dbproj that will be really helpful
Thanks

Created Issue: Database List not updated when changing "Server Host" (typing, not picking-from-list) [8866]

cjstremick — Mon, 28 Sep 2009 15:24:25 GMT

Created Issue: "USE" Statement should include brackets [8865]

cjstremick — Mon, 28 Sep 2009 15:17:00 GMT

Closed Issue: Treeview paint problem

Grimpi — Sat, 22 Aug 2009 15:59:08 GMT

Hello and good day

I´m opening this issues due to a treeview paint problem , i mean repeated elementos on same table

There is an attachment image
Comments:

Closed Issue: Compare method improvements

Grimpi — Sat, 22 Aug 2009 15:55:24 GMT

Playing around with your tool, it's pretty well thought out. Although for my situation to produce better results I added a few things to the Compare method that you may want to consider and add options to turn the features on and off with. Those being ignore whitespace and case insensativity. Here are the changes I made, the tool works even better than before.

//if (!this.ToSql().Equals(obj.ToSql())) return false;

//strip whitespace, ignore case
Regex whitespace = new Regex(@"\s");
string sql1 = whitespace.Replace(this.ToSql(), "");
string sql2 = whitespace.Replace(obj.ToSql(), "");
if (!sql1.Equals(sql2,StringComparison.OrdinalIgnoreCase)) return false;
Comments:

Closed Issue: SP not displayed and running on 64bit machine

Grimpi — Sat, 22 Aug 2009 15:54:58 GMT

Hi,

I think the reason some SPs cannot be displayed is that the have a commentary above the CREATE or ALTER statement like this:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[DELETE_CHANGE_LOG_ITEM_V1]
-- Add the parameters for the stored procedure here
@CL_ID RECORD_ID
AS
BEGIN
DELETE FROM [CHANGE_LOG_TAB] with (rowlock, updlock)
WHERE CL_ID = @CL_ID

select top 1 @@rowcount as RowsDeleted from [CHANGE_LOG_TAB]
for xml auto--, xmldata
END

Another issue is that the program will not start on my 64bit machine. Luckyly I could force the program to run at 32 bit with the following command:

"c:\Program Files (x86)\Microsoft Visual Studio 8\SDK\v2.0\Bin\CorFlags.exe" DBDiff.exe /Force /32bit+

regards,
Dashiel
Comments:

Closed Issue: Win32Exception

Grimpi — Sat, 22 Aug 2009 15:54:16 GMT

I download the Open DBDifference and build on my machine, i got the win32exception.. may i know also where do we get the scilelex.dll ?
Comments:

Closed Issue: SQL2005 to SQL2008

Grimpi — Sat, 22 Aug 2009 15:53:28 GMT

I met an issue when I have compared a DB where the origin is on SQL 2005 and the destination is on SQL 2008.
In class GenerateTables, TableIdIndex and other column indexes used by reader are declared static. So when the first call of InitTableIndex is made on the first connection, it sets the TableIdIndex for all other calls (TableIdIndex is different than -1).
Because TableIdIndex is different for SQL 2005 and SQL 2008 in query returned by GetTableDetail, Open DBDiff cannot parse correctly resultset.

I’ve solved the problem on my download by removing static declarations in class GenerateTables.
Comments:

Commented Issue: Constraints not appearing in the 'Old Object' window.

roblivermore — Fri, 21 Aug 2009 12:19:35 GMT

I get the same problem. The constraint attributes, index fill factor was different between databases and the option was missing in the report.

Created Issue: Filter Item Type

jberthaud — Sun, 26 Jul 2009 15:26:14 GMT

Hello,

SelectedIndex value in ComboBox does not match the ObjectType enumeration value when you create or update a filter. If you try to add a filter on table, trigger is selected.
I've change the selected option by using the parse method of Enum type to get the correct selected object type :

Regards,
JB

private void btnApply_Click(object sender, EventArgs e)
{
if (cboObjects.SelectedItem != null)
{
if (indexFilter == -1)
//sqlOption.Filters.Items.Add(new SqlOptionFilterItem((SqlOptionFilter.ObjectType)cboObjects.SelectedIndex, txtFilter.Text));
sqlOption.Filters.Items.Add(new SqlOptionFilterItem((SqlOptionFilter.ObjectType)Enum.Parse(typeof(SqlOptionFilter.ObjectType), cboObjects.SelectedItem.ToString(), true), txtFilter.Text));
else
{
sqlOption.Filters.Items[indexFilter].Filter = txtFilter.Text;
sqlOption.Filters.Items[indexFilter].Type = (SqlOptionFilter.ObjectType)Enum.Parse(typeof(SqlOptionFilter.ObjectType), cboObjects.SelectedItem.ToString(), true);
}
HandlerHelper.RaiseOnChange();
this.Dispose();
}
else
MessageBox.Show(this, "Must complete all fields", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}

Created Issue: SQL2005 to SQL2008

jberthaud — Sun, 26 Jul 2009 15:18:32 GMT

Commented Issue: Constraints not appearing in the 'Old Object' window.

BrianRo — Fri, 10 Jul 2009 20:39:36 GMT

I would consider this a high impact defect - primary keys are included in the comparison, so you cannot determine if the databases are an exact match if one of the dbs contains a primary key.

Commented Issue: bookmarks for connection

Grimpi — Mon, 06 Jul 2009 12:36:43 GMT

Yeah, I know.
If you want to collaborate, great!. I don't have too much time this days... :(

Created Issue: bookmarks for connection

Volleyknaller — Thu, 02 Jul 2009 17:48:15 GMT