Incorrect identity column update script generated

A user reported the following script was generated: ALTER TABLE [dbo].[table_name] ALTER COLUMN [column_name] [bigint] IDENTITY (1,1) NOT NULL Causing the following error: Msg 156, Level 15, ...

Id #15463 | Release: None | Updated: Today at 3:09 AM by jspraul | Created: Today at 3:05 AM by jspraul

Error Loading Source Database in open db diff

I'm using open db diff.exe for comparing 2 database. in local it works fine .but when i work with server its shown an error messages like "Open DBDiff Beta 0.9.0.0 Error Loading Source Database (...

Id #15462 | Release: None | Updated: Jun 10 at 1:15 PM by jspraul | Created: Jun 9 at 12:03 PM by velmurugan7

Feature Request: Only View Different Objects

Your tool is great. I really like the synchronization scripts, and how you can select just the objects you want to synchronize. The only thing I really think it needs is a summary of the differen...

Id #15460 | Release: None | Updated: Jun 29 at 10:18 AM by iainrscott | Created: Apr 23 at 9:28 PM by adamvaul

Exception comparing SQL2000 to SQL2014

Picked the Source as a SQL Server 8.0.2055 (aka SQL Server 2000) Destination as a SQL Server 12.0.2000 (aka SQL Server 2014) Looks like the solution is to move the database up to SQL2014 and do ...

Id #15459 | Release: None | Updated: Mar 12 at 1:50 PM by jspraul | Created: Mar 11 at 1:34 PM by sheir

ENHANCEMENT: Pull Request 8082

Merging Pull request 8082 as described per jbanderson99: Added Comparison settings to control if a full compare is done after each Update Added single/line item Updating Changed Update Item bu...

Id #15458 | Release: Open DBDiff 0.9 | Updated: Mar 9 at 6:14 AM by jspraul | Created: Mar 9 at 6:14 AM by jspraul

ScintillaNET native dll breaking form designer

The form designer won't load due to ScintillaNET failing to load SciLexer.dll. The project has updated to include the dll as a resource and extract it to the temp folder on startup. I submitted a ...

Id #15457 | Release: Open DBDiff 0.9 | Updated: Mar 9 at 4:02 AM by jspraul | Created: Mar 9 at 4:01 AM by jspraul

SQL2014 compare against SQL2008 - statistics index compare bug

It seems that there is a bug in DBDiff tool when comparing two databases that are on different sql versions. In my case we have compared two identical DB on different sql versions - sql2008 vs sql2...

Id #15456 | Release: None | Updated: Apr 17 at 9:58 AM by Vertygo | Created: Mar 5 at 10:18 AM by Vertygo

InvalidCastException between UserDataType and Constraint

Open DBDiff Beta 0.9.0.0 Exception has been thrown by the target of an invocation. Error Loading Destination Database (while Reading Text Objects: [rsp_SelCtcPol]) InvalidCastException: Unable t...

Id #15455 | Release: None | Updated: Mar 12 at 2:24 PM by jspraul | Created: Feb 27 at 6:25 AM by rashmikant_gadia

FEATURE REQUEST: Generate script for only some tables

A common use-case for me is to only modify one or two tables at time. Our production environment usually contains several tables that don't match dev/test production because development is not don...

Id #15454 | Release: None | Updated: Mar 12 at 1:59 PM by jspraul | Created: Feb 23 at 1:43 PM by userseven

IndexOutOfRangeException loading index details

Open DBDiff Beta 0.9.0.0 Error Loading Source Database (while Reading Index: [index_52246220]) IndexOutOfRangeException: Index_id at DBDiff.Schema.SQLServer.Generates.Generates.GenerateIndex....

Id #15453 | Release: None | Updated: Mar 12 at 2:17 PM by jspraul | Created: Feb 17 at 2:47 PM by runner33