We often use the SQL Compare command line application to deploy changes from one SQL Azure Database to another. In some cases, when deploying a change to a user defined table type, the dependencies are are not properly deployed resulting in an error. The example we have seen several times is that a stored procedure referencing a user defined table type is not dropped before dropping the user defined table type. We have encountered this error several times during deployments, but attempts to reproduce this error in a test environment have failed. The command we run is similar to the one below:
"C:Program Files (x86)Red GateSQL Compare 11SQLCompare.exe" /Server1:<Server> /UserName1:<username> /Password1:<password> /Database1:<sourcedb> /Server2:<server> /UserName2:<username> /Password2:<password> /Database2:<destinationdb> /Exclude:TABLE:[dbo].[__RefactorLog] /Force /Report:<reportpath> /ReportType:Interactive /ScriptFile:<scriptpath> /Options:IgnorePermissions,IncludeDependencies,IgnoreWhiteSpace
"C:Program Files (x86)Red GateSQL Compare 11SQLCompare.exe" /Server1:<Server> /UserName1:<username> /Password1:<password> /Database1:<sourcedb> /Server2:<server> /UserName2:<username> /Password2:<password> /Database2:<destinationdb> /Exclude:TABLE:[dbo].[__RefactorLog] /Force /Report:<reportpath> /ReportType:Interactive /ScriptFile:<scriptpath> /Options:IgnorePermissions,IncludeDependencies,IgnoreWhiteSpace