elayaraja007 / sql-dbdiff

Automatically exported from code.google.com/p/sql-dbdiff
0 stars 0 forks source link

comparing two databases does not work on v0.4 #42

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
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 brian.mc...@gmail.com on 14 Dec 2010 at 4:19