Code Monkey home page Code Monkey logo

sql-dbdiff's People

Watchers

 avatar

sql-dbdiff's Issues

Error on startup.

What steps will reproduce the problem?
1.Copy app files into folder c:\DBDiff
2.Run DBDiff.exe
3.

What is the expected output? What do you see instead?
Error dialog.  Text of dialog is listed below.

What version of the product are you using? On what operating system?
0.2

Please provide any additional information below.
Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, 
Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its 
dependencies. The system cannot find the file specified.
   at DBDiff.Settings.Project.GetLastConfiguration()
   at DBDiff.Front.PrincipalForm.Form_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& 
m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)


Original issue reported on code.google.com by [email protected] on 24 Mar 2010 at 3:50

Object Filtering Combo Box doesn't populate correct value

What steps will reproduce the problem?
1. Comapre Options
2. Filter By Name
3. Add
4. Type in a filter patter
5. Select [Table] as object type
6. Apply

What is the expected output? What do you see instead?
Expected: Object Type = Table
Actual: Object Type = CLR Trigger


What version of the product are you using? On what operating system?
0.4 : Windows 7

Please provide any additional information below.

This is potentially an incorrect index (where the index of the data in the 
combo box, doesn't match the selected value)

Original issue reported on code.google.com by [email protected] on 20 Aug 2010 at 12:34

comparing two databases does not work on v0.4

What steps will reproduce the problem?
1.
create two similar databases, but remove a table from one, change some 
constraint/default names, add some more columns to tables...etc.
2.
attach both databases to the same sql server instance, using different database 
names, under sql server managment studio
3.
using sql-dbdiff v0.4 compare both databases


What is the expected output? What do you see instead?

I expect to see some sort of difference between the old and new tab windows, 
but I see the same script in both windows for every entry that I click on, in 
the left hand tree. 

I also expect to see some sort of difference in the "Visual Diff" tab, but 
again I see exactly the same scipt in both windows - I can verify the 
difference in sql server managment studio, but sql-dbdiff doesn't show it.

If, in sql-dbdiff, I swap the databases around, then compare, again I see no 
differences, as described above.

Saying that though, the synchronized script seems to change between the 
databases correctly, as far as I can tell, so far..

What version of the product are you using? On what operating system?

sql-dbdiff v0.4
WinXP Professional
Microsoft SQL Server Management Studio  10.0.1600.22 
((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework    2.0.50727.3615
Operating System    5.1.2600

Please provide any additional information below.
using the free version of SQL Server Express

Original issue reported on code.google.com by [email protected] on 14 Dec 2010 at 4:19

Comparing 2000 & 2005 Database objects

What steps will reproduce the problem?
1. Compare 2000 & 2005 Database objects

What is the expected output? What do you see instead?
It should show the diff. 
Error:
'SCHEMA_NAME' is not a recognized function name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at DBDiff.Schema.SQLServer.Generates.Generates.GenerateRules.Fill(Database database, String connectionString)
   at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.set_Active(Boolean value)
   at System.Windows.Forms.Form.WmActivate(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
V0.4.0.0 & Windows 2003

Please provide any additional information below.
Program is executed on WinXP 

Original issue reported on code.google.com by [email protected] on 14 Jul 2010 at 3:01

[Patch:] Permissions implementation

What steps will reproduce the problem?
1. Permissions are not scripted

What version of the product are you using? On what operating system?
Revision #37

Please provide any additional information below.
I've implemented permissions diff on Tables. If this patch is accepted, I'll 
work on other objects.

Original issue reported on code.google.com by [email protected] on 2 Oct 2010 at 5:07

Attachments:

Problem to connect to remote sql server by using named pipe and server name.

What steps will reproduce the problem?
1. to connect to remote sql db
2.
3.

What is the expected output? What do you see instead?
connected to the remote sql server db. Error message. Could not connect to 
the target sqlserver db

What version of the product are you using? On what operating system?
version 0.3.0.0 on Windows XP SP3

Please provide any additional information below.
problem to connect to the remote sql server by using named pipe.
Could not connect to remote sql server by server name instead of ip address 
and alias. 

Original issue reported on code.google.com by [email protected] on 26 Mar 2010 at 3:23

Attachments:

Incorrect Old object script being generated for Tables

What steps will reproduce the problem?
1.Add a column in a table having Primary Key Constraint in the Source DB.
2.
3.

What is the expected output? What do you see instead?
Expected output:
1.The old object script should not show the Newly added column
2.The new object script should show the newly added column

Actual output:
1.The old object script did not show the Newly added column
2.The new object script did show the newly added column
3.The new object script also showed the following
CONSTRAINT [PK_ConstraintName] PRIMARY KEY CLUSTERED
    (
      [PrimaryKeyColumnName] ASC
    ) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)


What version of the product are you using? On what operating system?
I am using v3.0 in XP SP3

Please provide any additional information below.



Original issue reported on code.google.com by [email protected] on 25 Mar 2010 at 5:30

An error message appears at start and on using the Compare button indicating some file or assemblies could not be loaded

What steps will reproduce the problem?
1.Unpack the files from the zip
2.Run the program directly from the extracted files.
3.A message appear on the screen 'Could not load file or assembly
'System.Data.SqlServerCe'

What is the expected output? What do you see instead?
Once i close the message when i click on the Compare button it appear the
message again.

What version of the product are you using? On what operating system?
SQL-DBDiff 0.2.0.0, Windows XP

Please provide any additional information below.
I am running on a XP SP3 developer machine with Microsoft Visual Studio
2005 installed.

Original issue reported on code.google.com by [email protected] on 24 Mar 2010 at 3:47

Attachments:

Invalid object name 'sys.databases'.

What steps will reproduce the problem?
1. enter source database user/pw
2. click database dropdown list

What is the expected output? What do you see instead?
Expecting list of databases to select from.  Instead, getting following 
error:

Invalid object name 'sys.databases'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, 
Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 
exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, 
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet 
bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader 
ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, 
DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior 
behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at 
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.FillDatabase
()
   at 
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.cboDatabase_D
ropDown(Object sender, EventArgs e)
   at System.Windows.Forms.ComboBox.OnDropDown(EventArgs e)
   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
   at System.Windows.Forms.ComboBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& 
m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)


What version of the product are you using? On what operating system?
0.3 on win2003 server SE SP2

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 24 Mar 2010 at 10:12

Compare Options: Filter By Name wrong values

What steps will reproduce the problem?
1. Go to Compare Options
2. Go to thye 'Filter By Name' tab
3. Click 'Add' button
4. Add a filter pattern like "test"
5. Select the object type "Store Procedure"
6. Click 'Apply' button
7. Look at the list, you will see : "Test ---- AssemblyFile"

What is the expected output? What do you see instead?
7. I would expect : "Test ---- Store Procedure"

What version of the product are you using? On what operating system?
0.4.0.0 on XP SP3

Original issue reported on code.google.com by [email protected] on 1 Nov 2010 at 11:29

Command Line support

If this tool had a command line support it could be used in a
msbuild/deployment environment.

Original issue reported on code.google.com by [email protected] on 17 Apr 2010 at 1:20

Compare button error

What steps will reproduce the problem?
1.Enter Reference Database
2.Enter a Target Database
3.

What is the expected output? 
To see schema differences

What do you see instead?
See attached screen shot:

What version of the product are you using? On what operating system?
v0.4.0.0

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 23 Apr 2012 at 4:45

Attachments:

Synchronized Script panel does not resize with main application window..

What steps will reproduce the problem?
1.while viewing synchronized script tab resize the entire application 
window.
2.Reduce the size until the scroll bar of the synchronized script panel 
disappears.
3.

What is the expected output? What do you see instead?
It is expected that the panel would resize and keep the scroll bar visible.

What version of the product are you using? On what operating system?
0.2/Windows XP

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 24 Mar 2010 at 4:03

Error when Compare selected for two DBs on one SQL Server

What steps will reproduce the problem?
1. Define source and target DBs (mine are on the same SQL Server)
2. Click Test for both (both passed)
3. Click Compare

What is the expected output? What do you see instead?
Diff window to populate with schema diffs.
Got Error window. See attached

What version of the product are you using? On what operating system?
0.3.0.0. WinXP SP3

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 25 Mar 2010 at 4:09

Attachments:

DB Diff does not copy Identity columns

When a table has an identity column, 

CREATE TABLE [dbo].[ABC](
    [UserID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
    [UserName] [nvarchar](50) NULL)


the IDENTITY(1,1) portion is not identified as a diff

Original issue reported on code.google.com by [email protected] on 23 Aug 2010 at 7:32

Visual Diff not working on tables

What steps will reproduce the problem?
1. compare to databases

What is the expected output? What do you see instead?
Both version (old and new) are equals. No differences appears on screen.

What version of the product are you using? On what operating system?
0.4

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 28 May 2010 at 9:37

Error at startup

What steps will reproduce the problem?
1. Unzipped the .ZIP file contents into a folder
2. Via Windows Explorer, double-click on DBDiff.EXE
3. Program appears to start but has Error window in foreground containing 
the following information:
An error has occurred:
Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, 
Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its 
dependencies. The system cannot find the file specified.
   at DBDiff.Settings.Project.GetLastConfiguration()
   at DBDiff.Front.PrincipalForm.Form_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& 
m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)

What is the expected output? What do you see instead?
See above

What version of the product are you using? On what operating system?
SQL-DBDiff v0.2, on Windows XP SP3

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 24 Mar 2010 at 2:42

Don't detecting clr aggregate function

Are not defined clr aggregate functions.

I have eliminated this error, I can send you an initial code if it is 
necessary. 
As I now work over compatibility with sql server 2000. If you it interests, we 
could develop this application together.

Excuse for my bad English. I from Russia.

Original issue reported on code.google.com by [email protected] on 31 May 2010 at 1:15

db-diff v4.0 release error on compare button click

What steps will reproduce the problem?
1.Open db-diff v4.0 release
2.select 2 databases (SqlServer2005-SqlServer2005) to compare 
3.click on compare button

I used db-diff v4.0 release on winxp professional (32bit).
It displays me the following error:

'SCHEMA_NAME' is not recognized as a function name.
   in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   in System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   in System.Data.SqlClient.SqlDataReader.get_MetaData()
   in System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   in System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   in System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   in System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   in System.Data.SqlClient.SqlCommand.ExecuteReader()
   in DBDiff.Schema.SQLServer.Generates.Generates.GenerateRules.Fill(Database database, String connectionString)
   in DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   in DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   in System.Windows.Forms.Form.OnActivated(EventArgs e)
   in System.Windows.Forms.Form.set_Active(Boolean value)
   in System.Windows.Forms.Form.WmActivate(Message& m)
   in System.Windows.Forms.Form.WndProc(Message& m)
   in System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   in System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   in System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Original issue reported on code.google.com by [email protected] on 10 Jan 2011 at 12:44

Role does not have password

What steps will reproduce the problem?
1. Add a role.
2.Compare DBs

What is the expected output? What do you see instead?

According to BOL, "CREATE ROLE" does not have "WITH PASSWORD" option and 
"CREATE ROLE xxx WITH PASSWORD" gives an error:
Incorrect syntax near the keyword 'with'. If this statement is a common table 
expression or an xmlnamespaces clause, the previous statement must be 
terminated with a semicolon.

Patch:
Index: DBDiff.Schema.SQLServer2005/Model/Role.cs
===================================================================
--- DBDiff.Schema.SQLServer2005/Model/Role.cs   (revision 37)
+++ DBDiff.Schema.SQLServer2005/Model/Role.cs   (working copy)
@@ -43,7 +43,6 @@
             string sql = "";
             sql += "CREATE " + ((type == RoleTypeEnum.ApplicationRole)?"APPLICATION":"") + " ROLE ";
             sql += FullName + " ";
-            sql += "WITH PASSWORD = N'" + password + "'";
             if (!String.IsNullOrEmpty(Owner))
                 sql += " ,DEFAULT_SCHEMA=[" + Owner + "]";
             return sql.Trim() + "\r\nGO\r\n";


What version of the product are you using? On what operating system?
Revision 37; windows XP;


Please provide any additional information below.
SQL Server 2005.

Original issue reported on code.google.com by [email protected] on 13 Sep 2010 at 9:48

crashess on 64bit OS immediately

I am using Windows 7 64bit, it immediately crashes, probably the same sql 
lite issue open dbdiff has.  Is sql lite even necessary for configuration?


Original issue reported on code.google.com by [email protected] on 1 Mar 2010 at 12:24

Dependent objects are not scripted in the sync script

What steps will reproduce the problem?
1.Create a Indexed View in the Source DB
2.Alter the Table schema of the table on which the Indexed view is 
dependent. You will be prompted by SSMS that the dependent views will have 
to be recreated. So, recreate the indexed views on the Source DB

What is the expected output? What do you see instead?
Expected Output:
1. The sync script should also generate the DROP + CREATE script for the 
dependent indexed views/ any other object.

Actual Output:
1. No such script was generated.

What version of the product are you using? On what operating system?
I am using v3.0 on xp sp3

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 25 Mar 2010 at 5:36

Centralize SQL Connection handling to allow use of web service

Monkey coding to get the SQLConnection creation in one place. This allows 
alternate methods of connecting to SQL (eg. web service calls) simply.

Also added vertical scroll bar between list and details (screws up icons on 
one of the tabs) & disabled global exception handler when debugger is 
attached.

Wanted to note that Affero GPL is probably incompatible with original 
project's GPL license as it is more restrictive and as far as I know is not 
considered a later version of the GPL.

Original issue reported on code.google.com by [email protected] on 23 Apr 2010 at 10:42

Attachments:

Please provide source in a zip

I'd like to see the source for this project, but don't want to mess with 
SVN. Can you provide this in a zip, or include the source in the download 
file?

Original issue reported on code.google.com by [email protected] on 7 May 2010 at 5:46

on Comparare

What steps will reproduce the problem?
1.entered reference database
2.entered target
3.clicked on compare

What is the expected output? What do you see instead?
'SCHEMA_NAME' is not a recognized function name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at DBDiff.Schema.SQLServer.Generates.Generates.GenerateRules.Fill(Database database, String connectionString)
   at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.set_Active(Boolean value)
   at System.Windows.Forms.Form.WmActivate(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
V0.4.0.0

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 6 Jul 2010 at 2:06

Synchronized Script Fails - does not show all the new views!

What steps will reproduce the problem?
1. Don't know. Always happens for me.
2.
3.

What is the expected output? What do you see instead?
I see 8 out of the 15+ new views that I am expecting.

What version of the product are you using? On what operating system?
Version 0.4.0.0, Windows 7, Sql Server 2008 RC1

Please provide any additional information below.

The views display correctly highlighted in the Schema list differences, but are 
not listed in the sync script.

Original issue reported on code.google.com by [email protected] on 29 Jul 2010 at 4:21

Invalid object name 'sys.databases'.

What steps will reproduce the problem?
1. entered SQL 2000 server name
2. selected SQL Server Authentication
3. username 'sa' and correct password.
4. 'test' button says 'sucess'
5. But drop-down from 'DataBase:' generates error.

What is the expected output? What do you see instead?
A list of Databases for the selected SQL Server.

What version of the product are you using? On what operating system?
v0.3.0.0

Please provide any additional information below.
ERROR:

Invalid object name 'sys.databases'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
   at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.FillDatabase()
   at
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.cboDatabase_DropDo
wn(Object
sender, EventArgs e)
   at System.Windows.Forms.ComboBox.OnDropDown(EventArgs e)
   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
   at System.Windows.Forms.ComboBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)

Original issue reported on code.google.com by [email protected] on 25 Mar 2010 at 7:39

  • Merged into: #9

DBDiff.exe crashed while comparing two databases

What steps will reproduce the problem?
1.select reference database
2.select target database
3.compare

What is the expected output? What do you see instead?
I expected to see the comparison results. Instead I saw this message:
Index_id
   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at DBDiff.Schema.SQLServer.Generates.Generates.GenerateIndex.Fill(Database database, String connectionString)
   at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.set_Active(Boolean value)
   at System.Windows.Forms.Form.WmActivate(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
version:0.4, win7 ent.

Please provide any additional information below.
sql database collation: SQL_Latin1_General_CP1254_CI_AS

Original issue reported on code.google.com by [email protected] on 22 Nov 2010 at 11:39

Error when i run DBDiff.exe

I get this when i run the program 

Unable to load DLL 'sqlceme35.dll': The specified module could not be 
found. (Exception from HRESULT: 0x8007007E)
   at System.Data.SqlServerCe.NativeMethods.DllAddRef()
   at System.Data.SqlServerCe.SqlCeConnection..ctor()
   at System.Data.SqlServerCe.SqlCeConnection..ctor(String 
connectionString)
   at DBDiff.Settings.Project.GetLastConfiguration()
   at DBDiff.Front.PrincipalForm.Form_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)


Original issue reported on code.google.com by [email protected] on 16 Mar 2010 at 8:06

UI Connection/Database Validation Usability Suggestion

With regards to the Source Database/Destination Database visible settings
on the form header and the program's behavior.
A minor suggestion...

The 'Database' dropdown list uses the database reference as part of the
connection.  When switching servers, that reference may no longer be valid
(because the newly specified sever  may not have a database with the same
name as previously specified).  Consequently, attempting to select a new
database from the drowpdown box will fail with an ugly error message.  The
user is forced to clear out the database to properly populate the dropdown
box.  

A suggested fix:

When the 'Server Host', 'Authentication', 'Username', or 'Password' is
changed, clear (or visually change/decorate i.e. italicise ) the setting
chosen for Database.  


wonderful software..both yours and grimpi's

Original issue reported on code.google.com by [email protected] on 2 Apr 2010 at 7:28

SqlDbDiff crashes on compare, the indexes step

What steps will reproduce the problem?
1.Set source to a database with non-dbo rights and unknown permissions
2.Set dest to a database with dbo rights
3.Change settings to ignore indexes (though the code still runs a comparison?)
4.Compare

What is the expected output? What do you see instead?
The expected outcome is a comparison of all objects other than indexes. 
Instead, I get this error message both on the original project and this branch. 
Will attempt to run in debug in VS2010 to troubleshoot.

What version of the product are you using? On what operating system?
0.4 on Win7 x64

Please provide any additional information below.
Will attempt to further debug and possibly submit a patch (if I can locate the 
issue)

Original issue reported on code.google.com by [email protected] on 9 May 2012 at 4:14

Comparison SQL 2005 -> 2008

What steps will reproduce the problem?
1.TRIED TO CONNECT AND COMPARE SQL 2005 AND 2008 DBS
2.
3.

What is the expected output? What do you see instead?
Cannot open database "MSAxis_Production" requested by the login. The login 
failed.
Login failed for user 'MINTEC\aobregon'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 
exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, 
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet 
bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean 
enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, 
Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
(String host, String newPassword, Boolean redirectedUserInstance, 
SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 
timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
(SqlConnection owningObject, SqlConnectionString connectionOptions, String 
newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor
(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, 
Object providerInfo, String newPassword, SqlConnection owningObject, 
Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection
(DbConnectionOptions options, Object poolGroupProviderInfo, 
DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions 
options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection 
owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection 
owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at 
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.FillDatabase
()
   at 
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.cboDatabase_D
ropDown(Object sender, EventArgs e)
   at System.Windows.Forms.ComboBox.OnDropDown(EventArgs e)
   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
   at System.Windows.Forms.ComboBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
V0.3.0.0

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 7 May 2010 at 5:40

Error when Compare button clicked

What steps will reproduce the problem?
1. Select two databases to compare
2. Click Compare

What is the expected output? What do you see instead?
The expected output is to see the difference of the databases
however what i have seen is as belows:

---
Index_id
   konum: System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   konum: System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   konum: System.Data.SqlClient.SqlDataReader.get_Item(String name)
   konum: DBDiff.Schema.SQLServer.Generates.Generates.GenerateIndex.Fill(Database database, String connectionString)
   konum: DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   konum: DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   konum: System.Windows.Forms.Form.OnActivated(EventArgs e)
   konum: System.Windows.Forms.Form.set_Active(Boolean value)
   konum: System.Windows.Forms.Form.WmActivate(Message& m)
   konum: System.Windows.Forms.Form.WndProc(Message& m)
   konum: System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   konum: System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   konum: System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

---

What version of the product are you using? On what operating system?
v0.4 on Windows 7 Ultimate

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 12 Aug 2011 at 1:45

Attachments:

few minor spelling problems

What steps will reproduce the problem?
1. Start the application.

What is the expected output? What do you see instead?
The term "Store Procedure" instead of "Stored Procedure" in used in the code 
and on the screen in every location the word is used in the application (e.g. 
the tree view that is populated after comparison and in the option forms).

Also, "Comparision" is the name of an option tab, should be "Comparison"

What version of the product are you using? On what operating system?
.4, Windows 7

Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 16 Jun 2010 at 1:59

Error on compare process

What steps will reproduce the problem?
1.In compare process
2.
3.

What is the expected output? What do you see instead?
Referência de objeto não definida para uma instância de um objeto.
   em DBDiff.Schema.SQLServer.Generates.Generates.GenerateIndex.Fill
(Database database, String connectionString)
   em DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   em DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, 
EventArgs e)
   em System.Windows.Forms.Form.OnActivated(EventArgs e)
   em System.Windows.Forms.Form.set_Active(Boolean value)
   em System.Windows.Forms.Form.WmActivate(Message& m)
   em System.Windows.Forms.Form.WndProc(Message& m)
   em System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& 
m)
   em System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, 
IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
0.4.0.0

Please provide any additional information below.

SQL 2008 and WINDOWS 2003.


Original issue reported on code.google.com by [email protected] on 4 Jun 2010 at 3:20

Attempting to connect to a server

What steps will reproduce the problem?
1. Give the reference database fields a valid server address, and login
information, using SQL Server authentication.
2. Click to expand the blank database dropdown.
3. You will see the error.

What is the expected output? What do you see instead?
I expect it to either find databases on the server I give it, or if
information was entered in error, error gracefully.  Instead I see "an
error has occurred" and error output.

What version of the product are you using? On what operating system?
v0.4, Windows XP

Please provide any additional information below.

A network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured
to allow remote connections. (provider: Named Pipes Provider, error: 40 -
Could not open a connection to SQL Server)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
   at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject)
   at
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection 
owningObject,
SqlConnectionString connectionOptions, String newPassword, Boolean
redirectedUserInstance)
   at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
   at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
   at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
   at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
   at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.FillDatabase()
   at
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.cboDatabase_DropDo
wn(Object
sender, EventArgs e)

Original issue reported on code.google.com by [email protected] on 27 May 2010 at 3:48

SQL Server 2012 support

What steps will reproduce the problem?
1. Integrating Server 2012

What version of the product are you using? On what operating system?
0.4 on Windows XP Professional


Original issue reported on code.google.com by [email protected] on 7 Sep 2012 at 9:47

Unknown SCHEMA_NAME function

What steps will reproduce the problem?
1. Run comparison between Sql Server 2008 x86 and Sql Server 2000 x86.

What is the expected output? What do you see instead?
This error screen appears:
'SCHEMA_NAME' is not a recognized function name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at DBDiff.Schema.SQLServer.Generates.Generates.GenerateRules.Fill(Database database, String connectionString)
   at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.set_Active(Boolean value)
   at System.Windows.Forms.Form.WmActivate(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
SQL-DBDiff v0.4.0.0, Windows Server 2008 Enterprise without Hyper-V, SP1

Original issue reported on code.google.com by [email protected] on 21 Jul 2010 at 4:00

Saving comparison results to file like a summary report

What steps will reproduce the problem?
1. Just tried out use of tool to compare 2 DBs and checked what 
features/options were available.

What is the expected output? What do you see instead?

Option to save diff comparison results. Ideally like a comparison summary 
report in text, HTML format, etc. Useful when combined with a fix for issue 17. 
Would be nice to drill down summary for details of diffs but I think at basic 
level a summary report is good enough for saving.

What version of the product are you using? On what operating system?

Latest version to date, on Windows 2003, w/ SQL 2k5 express

Please provide any additional information below.

This is an feature/enhancement request, not a bug.

Original issue reported on code.google.com by [email protected] on 8 Nov 2010 at 2:46

Exception changing schema-view options

What steps will reproduce the problem?
1. Clicked on Show Existing Objects
2..
3..

What is the expected output? What do you see instead?
Object reference not set to an instance of an object.
   at DBDiff.Front.SchemaTreeView.RebuildSchemaTree()
   at DBDiff.Front.SchemaTreeView.chkShowExistingObjects_CheckedChanged(Object sender, EventArgs e)
   at System.Windows.Forms.CheckBox.OnCheckedChanged(EventArgs e)
   at System.Windows.Forms.CheckBox.set_CheckState(CheckState value)
   at System.Windows.Forms.CheckBox.OnClick(EventArgs e)
   at System.Windows.Forms.CheckBox.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?
.4.0.0

Please provide any additional information below.
.

Original issue reported on code.google.com by [email protected] on 29 Jul 2010 at 3:44

Blows up, running on Win7 64 bit

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?
ExecuteReader: CommandText property has not been initialized
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at DBDiff.Schema.SQLServer.Generates.Generates.GenerateIndex.Fill(Database database, String connectionString)
   at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnActivated(EventArgs e)
   at System.Windows.Forms.Form.WmActivate(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What version of the product are you using? On what operating system?


Please provide any additional information below.


Original issue reported on code.google.com by [email protected] on 22 Oct 2012 at 7:27

Main form sometimes minimizes

What steps will reproduce the problem?
1. Set up a project
2. Click 'Compare'
3. When process is done, the form sometimes disappears

What is the expected output? What do you see instead?

The form should probably keep having focus

What version of the product are you using? On what operating system?

v0.3 and v0.4 have this behavior on my Windows XP Service Pack 3

Please provide any additional information below.

I have .Net 1.1 and .Net 2.0, if this is important...

Original issue reported on code.google.com by [email protected] on 11 Jun 2010 at 4:49

Need Visual Diff

We need to be able to see the difference between the 2 files, in a WinDiff
style format.

Original issue reported on code.google.com by [email protected] on 7 Feb 2010 at 2:01

Compare fails with exception (DBDiff 0.4.0.0; SQL 2012)

What steps will reproduce the problem?
1. Setup Reference DB + Target DB, both Test-Btn's return success
2. Click Compare Btn
3. -

What is the expected output? What do you see instead?

DB Scheme Compare

What version of the product are you using? On what operating system?

DBDiff 0.4.0.0
MS SQL 2012

Please provide any additional information below.

Exception just after click on compare:

ExecuteReader: CommandText-Eigenschaft wurde nicht initialisiert.
   bei System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   bei System.Data.SqlClient.SqlCommand.ExecuteReader()
   bei DBDiff.Schema.SQLServer.Generates.Model.DatabaseInfo..ctor(String connectionString, Database database)
   bei DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   bei DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   bei System.Windows.Forms.Form.OnActivated(EventArgs e)
   bei System.Windows.Forms.Form.WmActivate(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Exception after click on red cross (X) to close the dialog:

Invalid database connection. Please check the database connection
Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei DBDiff.Front.PrincipalForm.btnCompare_Click(Object sender, EventArgs e)
   bei System.Windows.Forms.Control.OnClick(EventArgs e)
   bei System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   bei System.Windows.Forms.Control.WndProc(Message& m)
   bei System.Windows.Forms.ButtonBase.WndProc(Message& m)
   bei System.Windows.Forms.Button.WndProc(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Original issue reported on code.google.com by [email protected] on 5 Jun 2012 at 12:20

Visual Diff not working for Functions

What steps will reproduce the problem?
1.Loaded Source and Destination database (tested both)
2.Expanded Functions
3.Selected a function that was green

What is the expected output? What do you see instead?
Wanted to see what the Visual diff was...expecting a diff-tool like difference 
between function definitions

What version of the product are you using? On what operating system?
v0.4.0.0

Please provide any additional information below.
Visual diff showed two big red "X"es in old and new box and the following stack 
trace:
A generic error occurred in GDI+.
   at System.Drawing.Graphics.CheckErrorStatus(Int32 status)
   at System.Drawing.Graphics.DrawString(String s, Font font, Brush brush, RectangleF layoutRectangle, StringFormat format)
   at System.Drawing.Graphics.DrawString(String s, Font font, Brush brush, Single x, Single y, StringFormat format)
   at Menees.DiffUtils.Controls.DiffView.DrawString(Graphics G, String strText, Brush B, Int32 x, Int32 y)
   at Menees.DiffUtils.Controls.DiffView.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)
   at System.Windows.Forms.Control.WmPaint(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at Menees.DiffUtils.Controls.DiffView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Original issue reported on code.google.com by [email protected] on 9 Aug 2013 at 1:03

Attachments:

VisualDiff does not work for functions

What steps will reproduce the problem?
1. Compare two databases

What is the expected output? What do you see instead?
Text from old and new are different. But no Visual differences appear on screen.

What version of the product are you using? On what operating system?
0.4 (SQL 2005)



Original issue reported on code.google.com by [email protected] on 8 Jul 2010 at 12:08

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.