Exception has been thrown by the target of an invocation.

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 #15480 | Release: None | Updated: May 13 at 10:59 AM by igitur | Created: May 12 at 4:43 AM by rashmikant_gadia

Error Loading Source Database (while Reading Index:

Open DBDiff Beta 0.9.0.0 Error Loading Source Database (while Reading Index: [Stg_ETL_PathSwitch_RowId]) NullReferenceException: Object reference not set to an instance of an object. at DBDif...

Id #15479 | Release: None | Updated: Apr 25 at 2:47 PM by igitur | Created: Apr 22 at 2:45 PM by samarsalica

Feature Request: Generate re-runnable code?

When creating the script, allow the user to select whether they need to be rerunnable or not. For example, the code for a table drop would look something like this: IF OBJECT_ID('table_name') IS...

Id #15478 | Release: None | Updated: Apr 1 at 4:17 PM by jspraul | Created: Apr 1 at 4:17 PM by jspraul

Filter Object by Name (crash)

Version 0.9.0.0 In Compare Options, Filter Object by Name, selecting an Object type of "Store Procedure" causes exception: System.ArgumentException: Requested value 'Store Procedure' was not fou...

Id #15477 | Release: None | Updated: Apr 7 at 5:29 PM by igitur | Created: Mar 14 at 12:00 PM by Yiman

existing function and view shown as new

The compare is generating a Create View and a Create Function for 2 objects in my database. The object both exist in both databases, so I would expect an Alter. After running the script and making...

Id #15476 | Release: None | Updated: Apr 8 at 9:18 AM by igitur | Created: Mar 1 at 7:21 PM by jspraul

Scripts only generated when the script view tab opened

If I select objects in the tree and switch to the 'Synchronized Script' tab, it displays the change script for the selected objects. If however I select objects and click 'Save As' without first ...

Id #15475 | Release: None | Updated: Apr 8 at 9:47 AM by igitur | Created: Feb 22 at 1:37 PM by GPWebb

Received error comparing databases.

Open DBDiff Beta 0.9.0.0 Error Loading Source Database (while initializing) SqlException: The SELECT permission was denied on the object 'system_sql_modules', database 'mssqlsystemresource', sche...

Id #15474 | Release: None | Updated: Apr 8 at 10:00 AM by igitur | Created: Feb 20 at 4:32 AM by klraghu

create vs. alter

DBDiff is a good tool, but the SYNC script generates a CREATE rather than an ALTER for existing objects. I'm running ver 0.9 - is there a newer version available that fixes this?

Id #15473 | Release: None | Updated: Apr 8 at 9:49 AM by igitur | Created: Jan 28 at 3:43 PM by tomster

Comments in a function causing strang behaviour

I have a function in one database that refused be captured properly by the compare. Every upper case S was replaced by the name of the function. Like so - the name of the function is "usp_Retriev...

Id #15472 | Release: None | Updated: Apr 8 at 10:23 AM by igitur | Created: Dec 15, 2015 at 11:38 PM by crwcordes

Permission differences (stored proc) are not shown in a synchronization script.

Example Database source add user x add stored procedure y add permission for a user x to "execute" procedure y Database destination add user x add stored procedure y Everything is che...

Id #15471 | Release: None | Updated: Nov 4, 2015 at 9:43 AM by LTronina | Created: Nov 4, 2015 at 9:43 AM by LTronina