Hi,
We are running a schema compare to deploy DB changes in VB and get the following error for a particular table :
'FK_ItemSubTypeID@JobItem' is not a constraint.
Could not drop constraint. See previous errors.
When we run again this works successfully, suggesting something in the first pass executed to allow this to proceed 2nd time,
If we run the compare and deploy via the SQL Compare application, this works OK straight away.
The only difference between the config of the app and VB is the app is exluding objects in a particular schema, however this does not account for the error,
I am assuming there is a dependency or setting that needs to be checked to fix this, but any assistance would be greatly appreciated!
We are executing the compare as :
Dim diff1 As Differences = fromDatabase.CompareWith(
targetDatabase:=toDatabase,
options:=Options.Default.Plus(
Options.IgnorePermissions,
Options.IncludeDependencies,
Options.DecryptPost2kEncryptedObjects,
Options.IgnoreWhiteSpace,
Options.IgnoreFillFactor,
Options.IgnoreWithNocheck,
Options.IgnoreFileGroups,
Options.IgnoreUserProperties,
Options.IgnoreWithElementOrder,
Options.IgnoreDatabaseAndServerName))
and the deploy as :
Dim work As New Work()
work.BuildFromDifferences(
differences:=Diff1,
options:=Options.[Default].Plus(Options.IncludeDependencies),
runOnTwo:=True)
' Output any messages and warnings
For Each message As Message In work.Warnings
setStatus(message.Text, False)
Next
Using execBlock As ExecutionBlock = work.ExecutionBlock
Dim executor As New BlockExecutor()
executor.Status = New StatusEventHandler(
Sub(sender As Object, e As StatusEventArgs)
If e.Message IsNot Nothing Then setStatus(e.Message, False)
End Sub)
executor.ExecuteBlock(block:=execBlock, server:=toConnProps.ServerName, database:=toConnProps.DatabaseName,
integratedSecurity:=False, userName:=toConnProps.UserName, password:=toConnProps.Password)
The application is configured as :
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<!--
SQL Compare
SQL Compare
Version:11.1.0.1-->
<Project version="3" type="SQLComparisonToolsProject">
<DataSource1 version="3" type="LiveDatabaseSource">
<ServerName>SERVER</ServerName>
<DatabaseName>SOURCEDB</DatabaseName>
<Username />
<SavePassword>False</SavePassword>
<Password />
<ScriptFolderLocation />
<MigrationsFolderLocation />
<IntegratedSecurity>True</IntegratedSecurity>
</DataSource1>
<DataSource2 version="3" type="LiveDatabaseSource">
<ServerName>SERVER</ServerName>
<DatabaseName>TARGETDB</DatabaseName>
<Username />
<SavePassword>False</SavePassword>
<Password />
<ScriptFolderLocation />
<MigrationsFolderLocation />
<IntegratedSecurity>True</IntegratedSecurity>
</DataSource2>
<LastCompared>04/22/2015 14:50:53</LastCompared>
<Options>Default, IgnorePermissions, IgnoreWithNocheck</Options>
<InRecycleBin>False</InRecycleBin>
<Direction>0</Direction>
<ProjectFilter version="1" type="DifferenceFilter">
<FilterCaseSensitive>False</FilterCaseSensitive>
<Filters version="1">
<None version="1">
<Include>False</Include>
<Expression>(@SCHEMA = 'meta')</Expression>
</None>
<Assembly version="1">
<Include>True</Include>
<Expression />
</Assembly>
<AsymmetricKey version="1">
<Include>True</Include>
<Expression />
</AsymmetricKey>
<Certificate version="1">
<Include>True</Include>
<Expression />
</Certificate>
<Contract version="1">
<Include>True</Include>
<Expression />
</Contract>
<DdlTrigger version="1">
<Include>True</Include>
<Expression />
</DdlTrigger>
<Default version="1">
<Include>True</Include>
<Expression />
</Default>
<ExtendedProperty version="1">
<Include>True</Include>
<Expression />
</ExtendedProperty>
<EventNotification version="1">
<Include>True</Include>
<Expression />
</EventNotification>
<FullTextCatalog version="1">
<Include>True</Include>
<Expression />
</FullTextCatalog>
<FullTextStoplist version="1">
<Include>True</Include>
<Expression />
</FullTextStoplist>
<Function version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</Function>
<MessageType version="1">
<Include>True</Include>
<Expression />
</MessageType>
<PartitionFunction version="1">
<Include>True</Include>
<Expression />
</PartitionFunction>
<PartitionScheme version="1">
<Include>True</Include>
<Expression />
</PartitionScheme>
<Queue version="1">
<Include>True</Include>
<Expression />
</Queue>
<Role version="1">
<Include>True</Include>
<Expression />
</Role>
<Route version="1">
<Include>True</Include>
<Expression />
</Route>
<Rule version="1">
<Include>True</Include>
<Expression />
</Rule>
<Schema version="1">
<Include>True</Include>
<Expression />
</Schema>
<SearchPropertyList version="1">
<Include>True</Include>
<Expression />
</SearchPropertyList>
<Sequence version="1">
<Include>True</Include>
<Expression />
</Sequence>
<Service version="1">
<Include>True</Include>
<Expression />
</Service>
<ServiceBinding version="1">
<Include>True</Include>
<Expression />
</ServiceBinding>
<StoredProcedure version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</StoredProcedure>
<SymmetricKey version="1">
<Include>True</Include>
<Expression />
</SymmetricKey>
<Synonym version="1">
<Include>True</Include>
<Expression />
</Synonym>
<Table version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</Table>
<User version="1">
<Include>True</Include>
<Expression />
</User>
<UserDefinedType version="1">
<Include>True</Include>
<Expression />
</UserDefinedType>
<View version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</View>
<XmlSchemaCollection version="1">
<Include>True</Include>
<Expression />
</XmlSchemaCollection>
</Filters>
</ProjectFilter>
<ProjectFilterName>Custom*</ProjectFilterName>
<UserNote />
<SelectedSyncObjects version="1" type="SelectedSyncObjects">
<Schemas type="ListString" version="2">
<value type="string">ZABiAG8A</value>
<value type="string">bQBlAHQAYQA_</value>
<value type="string">UgBlAGQARwBhAHQAZQBfAFMAUQBMAEMAbwBtAHAAYQByAGUAXwBEAGUAZgBhAHUAbAB0AF8AUwBjAGgAZQBtAGEA</value>
</Schemas>
<ZABiAG8A>SVf4LAbkZOZReZ4/g/rOVwMCAeSmKt3PXIQmZL+SEpjaj2gCAgEIDTsaj2epXQGwQXHcCOFNAgEBSh5tmo0hz/r62OanmXL/MgICAT8s/3U6Dg7AdFBnKXawnQACAgE/k2zdK5DYmKNKMTiseTDVAgIBcKxGCuD8+Hc9UBTRGpRBaQICAVn60K8bzH4uBFBl+ic6vE4DAQHM6+Mg6isSZK2Yub1YOVraAwIBgoCHnNhuG00VW8UyC1bP+wMBATpFXgP0zm5bxWYsc4LobFsDAgHC/mDWdk9GPRh1gKncM5ziAwIBM3LrAu8jS0oI294OpAN/LAMCAQQhGBH98saLwC3p2gGOwG8DAgG9mxMj/OQfAFnOJm4SXvfJAwIBws59RVJ6V5OBVdDFkwRU1gMBAaz36zaTeru8aMVvt1vY2mADAgEzsCbgYWDcgo77UT10ikKsAwIB10qodW8sprOkHnLQ2PJAJAMCAeEad9HWu7puMxBpB+0MvNkDAgGF/YxALwGYKEYgshJ4xWF4BAIBq096WygYLKYNFd+DCErCGAQCAQB+hCoCEIPN/8XUqCKK1f4CAwGbL2D3pfGL6nlMG78Bcb74AgMBRTmUVLyw1CcLiczwRWktUQIDAYRla5F6xHUr2xQNbScprxwCAwEE/puGxeBW5Q21OIYU3EosAgMBABL5QRaXkaYPpq/L8dygTgIDAc0jaU40gkB2k6Ny3DkJLJYCAwGM+k/bIn8iMILHdxebn/E2AgMBTqfHpe7MRSeoxewCQUKKsQIDASCMc2GzUTfhaHqbU/mU02ICAwG17xIOVxvEJY2yti3RfMz8AgMBI8ozKwUf/+B6AGAJa0gVmgIDAQ9/5h3SKhb6e/GnQvnMQ44CAwEfrQ51PKzUDnrBkhZfDr57AgMBP5JPdMy92z6E1kxsJZwLdAIDAYFizd6xUdHzu+pantDfjb4CAwHT9Z3G1gsw7IZn4OP4x7BQAgMBJe2XT8gEGhKl1UY0AoY8qQIDAWHP/IouqJY04Jzg055FAogCAwFrhxlk8mFGRfxntx6nVRHGAgMBZAByJbBVzjIDhoVEORcoowIDAegckNbbKoIItEMEWEL4yb0CAwFFTujZ9HRuEm9w9vneSWuKAgMBFvVBtsk3JC31Oie//EchDQIDAfYLCP70EVDIDO0qBBmu5JkCAwFZbDJkNz6YZbIsMWxqXZDXAgMB+hRaYEbNPzL5KM8GEuJRgQIDAabE5eguTyrYJzWUwbcSeWACAwHU7PM3Psum678WEPppT1AKAgMBQQr0VYAOK98bPiV5jICbYAIDAfNi3A8LmWTfMMPqoASON5wCAwE+8o7wZugyI/03Bo+mV9zoAgMBJMuAkN87tEARbv8VjEjVpgIDATRfku0n53KWFvNta4yk/2kCAwF+Nr+tOPp7U0ghInFMaGLJAgMBlw/e7gmn4iyICMYLhQyBqAIDAVa20n2ffe0g2U7m3gq5KFgCAwFdOHHD4EaboZlSo5QE3bsVAgMBe+6fCI+StufboTkWX61eUQIDAcfEByCiqza1BMya8GOaL8YCAwHU3NuymwrciD9s93yW/RDnAgMB4TrruJBw36kpQt4Pzu1R4AIDARjYUD5Cs9jybVIVs/BEJJ4CAwFQ7On5uUGimXiqMn9m99t0AwMBN0ph9oVhkV2ck8UTOgMVvwMDAVCv01WwYaq3THt21XIl4jQDAwGrn/h2/ygpcmqUNbQxYMEYAwMBHAMnjfOZN9JnUPeI3/quYQMDAeMOtuowcWbAhLL6tAe3PrIDAwHqyAqx5LHRl8MhRlphJ9aFAwMBLnpGXP+gwpM3W6PX4wP36AMDAZwvcBoHG8idPVqrE3o+6YMDAwEFxWUTqEb+/f4ycyVsVGd2AwMB/grmHBwJyrwRqdrn2nnirAMDAUwsZ7fS2JvTiQw+3Vh+fBEDAwHX6UAE4ny9DDqljyYpYP8YAwMBU9OLvCdKU63zD4SGuON8JgMDAabOb+lzM4Al+xkjT9sJ/5kDAwFYZaB6+6NICE1sBridO9eeAwMBdUUbZS4dAgt4hwHmB2EhCgMDAdzjlTvQkREyMomGA1Ioy0MDAwEWBYt6KusEYlt5dlVNKPVAAwMBgoyATQldKl/EzqXGLdpYFwMDAd2SF6yBBog6baSxNIlU9ZwDAwG5lWGyDu3IRtUzO0UBGkBqAwMBN0bXwfu6lUn2Ar2PXRsw/wMDAUhLTKQVhjSjNYwMRwhhICIDAwFh/547w8hkCT2AeeMcq3oKAwMBKSiofUb3a4R56mJjmOOf5QMDAbPSOMicf8kF3Fs4QZeE1wUDAwFKCJPL6TegPTlWBPvFxSGvAwMBzl6TtiyBdGn0de29mvBdGAMDAYgHwto3NB8t0WMdEoY8t8oDAwFx1m0nXr6AFyyB0mSaBdRJAwMB/OdyZcEdRz7kKiJeisjCIAMDAXUMTc8I+nen3+AAprNg5JgDAwH7lW/7QUZwnVk9L1hB0OWbAwMBVuNTL4XmlPy/dj1cb1HxNgMDARySMAzrNvD9hEYw7ih/Nl8DAwFuFCsVOiDczEBV5ItqKnOvAwMB+oRzczsTLu/sNQMPdJlizAMDAXkG/yNweHJotWQmo8sxzGADAwEI3nRtWMRQ8eB+z1Frs+GJAwMBNHYs29GEjMsa3XSd1ZDrBwMDAYYoB0LheW9PDxie37o6OWsDAwFZMqYMU6lmrv3AS8sC/D8WAwMBipy3fbFpcRDPmTbNt/aLnwMDAehqexi9MrQeBt6zz/4KAnoDAwELcaKLzbBhfWEFYn8ClBKBAwMBxw9mh4XEMVIWHFXqfzAVbwMDAe0tj0mbJ8PXaXSS9ageZ6YDAwE/W/88S9r+G507oTPiMCBQAwMBqPvuu2pUfQySxkqCJANnbQMDATbC1WrSFYdd33T3NwpxtAwDAwFFg8l0RU6VQ/4rgJsASuzVAwMBtaybehNAoE0x8VKnSRtWSQMDAYX9SCpKTkUNQiRKZNJ+eoIDAwFN16IWDzkuEz4wmIHaeRp6AwMBu0ZXWfMfNKPL+hWIWtQnpwMDAby846umLiaxZOIG/wIOJx4DAwFhgujIZKcM9Pknv2OEt/Q6AwMBDYkzXFDM/fBQHt3P/otqNQMDAX1e3stxnIS7tzOTS0f0wXgDAwEUKqCYvPxXtc5DizFYNCD9AwMB1tzbnr3Xg/KkepyjWZlVxwMDAY/gbZOlnfWRX3tv83iiGFoDAwGnTel2etW7qDe2XI5AxMPWAwMBBoKbv4UVlzkHPUfgUf4mTQMDAezUDNK0IhEcEu2LwOMk87QDAwEnID+tnXohokiDElTqisy2AwMBuBCF1ZyODKxAqd1nbV3aKgMDAWlaEZfnMLbJJ98JyIfYFtoDAwF9QJlDg2j+1XY94WAmxseqAwMBdRh+tW5jhm21/vON3F6MKAMDAfax9hfnx13kLCLmsrokuYoDAwEsDeNz/f1m9Lt9iWmdj0OzAwMBOxkLSYDTbsDj3kpZCsUtgwMDAd4at2WKBLEvvujbXiKYjS0DAwHUVM8ZsEsE9lvkfrFKVlV8AwMBZNhvYo6+AQpUc9YXWB2e1wMDAeFIpdvYd2cDjeIONElYCUwDAwEq9xmgtNcs9778XXvoqlwCAwMBANEo1MmB9Fr3PGsXegmTMQMDAa4tmy5PBe/HaNppbBsdjKUDAwG2fpr5FTN0APlT6UBAQiXrAwMBzSm0lhrmu3/ptJgZihvZDgMDATc403ifwQ2U/63r14zSZp4DAwEIuKKREeUn59eqCjyFKq/bAwMB8Eos32bduaUaY+RpnW/DoQMDAdfssAXaT/RR6q5G254eeKIDAwEUQv09MIhTGJhRtNZR91gtAwMBUyNccBVBsP/qDZHd7boEUAMDAd1QxSwXXwaJwwO2s3RWfdkDAwG8edoa+X2h7S4XahVtbNkPAwMBhEftjxwOHD+z9WCXOzHxTgMDAbyKb85yhwVWYqEIU/Q322QDAwGChW7fTiSOxP8nIsFal79UAwMBXb4Nf0S6KT3Bp1LcfUkBUQMDAcaPlkfKXEylLPt56slcGBYDAwEiZ8iZyk4t3/9w/P3xq/nVAwMBqadP4YIHXsMNWCZvEoTCZAMDAbSALRBORy5/yL+lMcWIMX4DAwFUMvZoY4xRCsZ2K//bL4eiAwMBQOatns7c0Lxrp3WF6s4bZgMDAaaM3O4BBagdO5MD4U3s+sUDAwG3VeD+mCJ4y0X5vnbeT/NmAwMB8z0Q+/bPC6ewx3Q08RXBDgMDAVX0XjT7gjGf9bKWuW6d7aMDAwFpHqSkzv0lQc/Wg0FzVA0qAwMBwQpp3RfkD9tov43tzsPM3QMDASAmhZejrjDqE0IpupTy06cDAwFDAYZxhDrxBNOicYeRppoKAwMByq3uPKWyIhtfuTXuDc3LBAMDATf1TAWFypspreN6oC7aRh4DAwGQ/qhq0TSoFmDRrbjyPjdCAwMBG6KGKrLFYe/nuIARKfcVogMDAc9tHhFu9CrEzemnexZqo0kDAwE+Qmkeyl7/Z76pPafHFVe5AwMBtK+MtrFN2Qa15kQt4rgpCAMDAdAhHkRcpGVhvhlPh2v/baADAwGH3ELmbNFSR0dtu7opRyr6AwMBEf0RaDjAZv/6Q/1mdumB2AMDAbBH/LA8gI+A+LMAzSGKcwoDAwHaUrjETxdRvuz6TXKojVrrAwMBy5bUp1gazn9hySN8M/du0wMDASrLvj5MEfsFgiHjWe3SDLMEAwHA3/RdiyvVFSL3Dpz1ahyyBAMB5m44DMFLrQJXxbIwkWGsBQQDASoRc35ZIZHahp1bI8smN5QEAwEjEI6kUxk0qMvqxFDykMIDBAMBmR2EkmBTSHtC66Xif+tlsAQDAVghT0vwOd6ninNu6tyMfFUEAwFJGygk9tHWPQ5Se3QyuOqOBAMBDBrQQ8tgu1Gtdeb223HaTAQDAQBWFEMxGMLsgqJxGXpMDf0EAwGfISVui61a8D3pU5j/yb9vBAMBlvmEFbAWONgLyZ4gt+yEqwQDAaB4HMTaiPoNSKBC7jiQAv8EAwEzxVv9YEN9TgCqqIxPygTNBAMBCuRNSX2YgC1OuyeZscQI8QQDAW2Kh1TOIuJZkk66T5pt0XIEAwEBaeBvtvSXZKE3bwsbTYhRBAMB0fmkuMp3NNeF5C419z05dQQDAezeOnsVcAC7g6Z+D26WqwUEAwHKKnYq7sJzoM70QHMfIekkBwMBVYGQxQbSYAX1y/MNqGGM8gcDAeu+AABzmOb74Nqqb6ecrZ4HAwHfLVQ8+Q7ZRDLwWDY0bYGFBwMBv776qp1rKbk+NT+wdS/yIAcDAdmu5mxktgh7qBx2BaQadi4HAwGo52kGuw1Kt+7g9rHSkOHEBwMBBRC1QbjWrB81TLHS8hem6QcDAZn5i7L9qVhlJo6X3qbp7YgHAwFTpc+1JCZT6cfcxYMeePQrBwMBA186c1hN7kcPM9ig8Ch0pwcDAXgbQrJ7lYL5ds4iZfuesvsHAwFIAPslifZhwWcoDrrICtZEBwMB</ZABiAG8A>
<bQBlAHQAYQA_>o7k0Zhl2jig2t8itmcH9fgIAABQE30N9/wDPVzBKNejBrbwCAAActwUoPpmbmUiuwWU2Bc0XAgAAPVYaM6WLFjBNzJxL+WB7xAIAAAwT1kRZe2cE+Pu2Tkb1I5QCAAB0DMJ/NSeeXtaaqJf6WXtvAgAA0f2qFYcM66qlPkanwDzeDgIAAJ2ceJGxlYbBtAmMBJYOTAwCAADiRmzORRJgc0bmLJN34hy8AwAAvF73YZZxFBTILAXqTDkQKQMAAGqNnxEcP30FlhE4ClWPFQADAABnP+hVdCW6nUova0ozrk0RAwAAlL34rTHBPO+P+1se5gipYgMAAG+zNCQd8uonGQW3z8eulfQDAACyCQM5sHr1eijQtx1glBsGAwAAJewliw87St8fuk8ky80xlAMAAE5f4WHl9iJBQujbe6E7cfcDAABnWFHTA5ffmfBurtCMZI7YAwAAX6jxIffLatGOlVHavnNIeQMAAP9K4hQsbADc0yyV5o9pjfkDAAD/Erovucsncce39xnj6qshAwAAGinNrXt2m9w/mcr86+drjgMAAJDehQXGI3DCHn6PBu56wLgDAADPtaWy2eKjs1WQ3RLv7xg/AwAACci2GbUdiZ8/BFAQ2gZeXwMAAGjinBlZ8Tq2h7RhtgtjaFgDAABQqedqRL7+E2289NvfE0+QAwAAXIAiF3rCt9IjDYYQf9nj4wMAAHOILC7jqaqp46vBD71Z1LoDAACD/6tCynETh2+53w2G912VAwAAMutVZ9dtznQlon7OpL+8cQMAAKfLv0wZNxfOiNYB7lkFO/UDAADbuAmqO6uTVKSZt7PD99LKAwAAQCxEyw3hk9FFOg18mX/s6wMAAMjwMfD/vWHxQkLtNvD6WHEDAAAkCz0sZAD3hueZUP1QPF6IAwAAsYvW0mWHYy4QsHCb3xPWxAMAAGoQhzI9NB4Gw1vrljmqVOkDAACcLIoj3Ge/zVaCf8MZ846uAwAANrPhp9OzxziXk2phYEJRiwMAAK9KaRXS5Yjdyi5pvoVRcocDAAAspMhfMhhhgDLh7uQjDR3xAwAAJHB+xrH+vRhUMdv+ONj32gMAAHR0DfiqGgyO/Bka4uI+K1IDAACbM/skkcmgdc6mRDUNVTUPAwAA509fwkKnzzQbCjeiaAyaOAMAAEkUlq6ZNsN0gcLZkgaBL6MEAABRSlz2gT6MywbjK98WgoK+BwAADZeEmmc0hrlltsz4P60HHwcAAO2i9hrd5d7adpHdAnhyVOIDAAA_</bQBlAHQAYQA_>
<UgBlAGQARwBhAHQAZQBfAFMAUQBMAEMAbwBtAHAAYQByAGUAXwBEAGUAZgBhAHUAbAB0AF8AUwBjAGgAZQBtAGEA>QAxuS6edULIvuuG2HXZszxsAAA__</UgBlAGQARwBhAHQAZQBfAFMAUQBMAEMAbwBtAHAAYQByAGUAXwBEAGUAZgBhAHUAbAB0AF8AUwBjAGgAZQBtAGEA>
<Grouping type="ListByte" version="2">
<value type="Byte">63</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
</Grouping>
<SelectAll>True</SelectAll>
</SelectedSyncObjects>
<SCGroupingStyle>0</SCGroupingStyle>
<SQLOptions>10</SQLOptions>
<MappingOptions>82</MappingOptions>
<ComparisonOptions>0</ComparisonOptions>
<TableActions type="ArrayList" version="1" />
<SessionSettings>15</SessionSettings>
<DCGroupingStyle>0</DCGroupingStyle>
<SC_DeploymentOptions version="1" type="SC_DeploymentOptions">
<BackupOptions version="1" type="BackupOptions">
<BackupProvider>Native</BackupProvider>
<TypeOfBackup>Full</TypeOfBackup>
<Folder>D:DatabasesBackup</Folder>
<Filename />
<SqbLicenseType>None</SqbLicenseType>
<SqbVersion>0</SqbVersion>
<DefaultNativeFolder>D:DatabasesBackup</DefaultNativeFolder>
<DefaultSqbFolder />
<Password encrypted="1" />
<NameFileAutomatically>False</NameFileAutomatically>
<OverwriteIfExists>False</OverwriteIfExists>
<CompressionLevel>0</CompressionLevel>
<EncryptionLevel>None</EncryptionLevel>
<ThreadCount>0</ThreadCount>
<BackupEnabled>False</BackupEnabled>
</BackupOptions>
</SC_DeploymentOptions>
</Project>
Hi Mark,
We are running a schema compare to deploy DB changes in VB and get the following error for a particular table :
'FK_ItemSubTypeID@JobItem' is not a constraint.
Could not drop constraint. See previous errors.
When we run again this works successfully, suggesting something in the first pass executed to allow this to proceed 2nd time,
If we run the compare and deploy via the SQL Compare application, this works OK straight away.
The only difference between the config of the app and VB is the app is exluding objects in a particular schema, however this does not account for the error,
I am assuming there is a dependency or setting that needs to be checked to fix this, but any assistance would be greatly appreciated!
We are executing the compare as :
Dim diff1 As Differences = fromDatabase.CompareWith(
targetDatabase:=toDatabase,
options:=Options.Default.Plus(
Options.IgnorePermissions,
Options.IncludeDependencies,
Options.DecryptPost2kEncryptedObjects,
Options.IgnoreWhiteSpace,
Options.IgnoreFillFactor,
Options.IgnoreWithNocheck,
Options.IgnoreFileGroups,
Options.IgnoreUserProperties,
Options.IgnoreWithElementOrder,
Options.IgnoreDatabaseAndServerName))
and the deploy as :
Dim work As New Work()
work.BuildFromDifferences(
differences:=Diff1,
options:=Options.[Default].Plus(Options.IncludeDependencies),
runOnTwo:=True)
' Output any messages and warnings
For Each message As Message In work.Warnings
setStatus(message.Text, False)
Next
Using execBlock As ExecutionBlock = work.ExecutionBlock
Dim executor As New BlockExecutor()
executor.Status = New StatusEventHandler(
Sub(sender As Object, e As StatusEventArgs)
If e.Message IsNot Nothing Then setStatus(e.Message, False)
End Sub)
executor.ExecuteBlock(block:=execBlock, server:=toConnProps.ServerName, database:=toConnProps.DatabaseName,
integratedSecurity:=False, userName:=toConnProps.UserName, password:=toConnProps.Password)
The application is configured as :
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<!--
SQL Compare
SQL Compare
Version:11.1.0.1-->
<Project version="3" type="SQLComparisonToolsProject">
<DataSource1 version="3" type="LiveDatabaseSource">
<ServerName>SERVER</ServerName>
<DatabaseName>SOURCEDB</DatabaseName>
<Username />
<SavePassword>False</SavePassword>
<Password />
<ScriptFolderLocation />
<MigrationsFolderLocation />
<IntegratedSecurity>True</IntegratedSecurity>
</DataSource1>
<DataSource2 version="3" type="LiveDatabaseSource">
<ServerName>SERVER</ServerName>
<DatabaseName>TARGETDB</DatabaseName>
<Username />
<SavePassword>False</SavePassword>
<Password />
<ScriptFolderLocation />
<MigrationsFolderLocation />
<IntegratedSecurity>True</IntegratedSecurity>
</DataSource2>
<LastCompared>04/22/2015 14:50:53</LastCompared>
<Options>Default, IgnorePermissions, IgnoreWithNocheck</Options>
<InRecycleBin>False</InRecycleBin>
<Direction>0</Direction>
<ProjectFilter version="1" type="DifferenceFilter">
<FilterCaseSensitive>False</FilterCaseSensitive>
<Filters version="1">
<None version="1">
<Include>False</Include>
<Expression>(@SCHEMA = 'meta')</Expression>
</None>
<Assembly version="1">
<Include>True</Include>
<Expression />
</Assembly>
<AsymmetricKey version="1">
<Include>True</Include>
<Expression />
</AsymmetricKey>
<Certificate version="1">
<Include>True</Include>
<Expression />
</Certificate>
<Contract version="1">
<Include>True</Include>
<Expression />
</Contract>
<DdlTrigger version="1">
<Include>True</Include>
<Expression />
</DdlTrigger>
<Default version="1">
<Include>True</Include>
<Expression />
</Default>
<ExtendedProperty version="1">
<Include>True</Include>
<Expression />
</ExtendedProperty>
<EventNotification version="1">
<Include>True</Include>
<Expression />
</EventNotification>
<FullTextCatalog version="1">
<Include>True</Include>
<Expression />
</FullTextCatalog>
<FullTextStoplist version="1">
<Include>True</Include>
<Expression />
</FullTextStoplist>
<Function version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</Function>
<MessageType version="1">
<Include>True</Include>
<Expression />
</MessageType>
<PartitionFunction version="1">
<Include>True</Include>
<Expression />
</PartitionFunction>
<PartitionScheme version="1">
<Include>True</Include>
<Expression />
</PartitionScheme>
<Queue version="1">
<Include>True</Include>
<Expression />
</Queue>
<Role version="1">
<Include>True</Include>
<Expression />
</Role>
<Route version="1">
<Include>True</Include>
<Expression />
</Route>
<Rule version="1">
<Include>True</Include>
<Expression />
</Rule>
<Schema version="1">
<Include>True</Include>
<Expression />
</Schema>
<SearchPropertyList version="1">
<Include>True</Include>
<Expression />
</SearchPropertyList>
<Sequence version="1">
<Include>True</Include>
<Expression />
</Sequence>
<Service version="1">
<Include>True</Include>
<Expression />
</Service>
<ServiceBinding version="1">
<Include>True</Include>
<Expression />
</ServiceBinding>
<StoredProcedure version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</StoredProcedure>
<SymmetricKey version="1">
<Include>True</Include>
<Expression />
</SymmetricKey>
<Synonym version="1">
<Include>True</Include>
<Expression />
</Synonym>
<Table version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</Table>
<User version="1">
<Include>True</Include>
<Expression />
</User>
<UserDefinedType version="1">
<Include>True</Include>
<Expression />
</UserDefinedType>
<View version="1">
<Include>True</Include>
<Expression>TRUE</Expression>
</View>
<XmlSchemaCollection version="1">
<Include>True</Include>
<Expression />
</XmlSchemaCollection>
</Filters>
</ProjectFilter>
<ProjectFilterName>Custom*</ProjectFilterName>
<UserNote />
<SelectedSyncObjects version="1" type="SelectedSyncObjects">
<Schemas type="ListString" version="2">
<value type="string">ZABiAG8A</value>
<value type="string">bQBlAHQAYQA_</value>
<value type="string">UgBlAGQARwBhAHQAZQBfAFMAUQBMAEMAbwBtAHAAYQByAGUAXwBEAGUAZgBhAHUAbAB0AF8AUwBjAGgAZQBtAGEA</value>
</Schemas>
<ZABiAG8A>SVf4LAbkZOZReZ4/g/rOVwMCAeSmKt3PXIQmZL+SEpjaj2gCAgEIDTsaj2epXQGwQXHcCOFNAgEBSh5tmo0hz/r62OanmXL/MgICAT8s/3U6Dg7AdFBnKXawnQACAgE/k2zdK5DYmKNKMTiseTDVAgIBcKxGCuD8+Hc9UBTRGpRBaQICAVn60K8bzH4uBFBl+ic6vE4DAQHM6+Mg6isSZK2Yub1YOVraAwIBgoCHnNhuG00VW8UyC1bP+wMBATpFXgP0zm5bxWYsc4LobFsDAgHC/mDWdk9GPRh1gKncM5ziAwIBM3LrAu8jS0oI294OpAN/LAMCAQQhGBH98saLwC3p2gGOwG8DAgG9mxMj/OQfAFnOJm4SXvfJAwIBws59RVJ6V5OBVdDFkwRU1gMBAaz36zaTeru8aMVvt1vY2mADAgEzsCbgYWDcgo77UT10ikKsAwIB10qodW8sprOkHnLQ2PJAJAMCAeEad9HWu7puMxBpB+0MvNkDAgGF/YxALwGYKEYgshJ4xWF4BAIBq096WygYLKYNFd+DCErCGAQCAQB+hCoCEIPN/8XUqCKK1f4CAwGbL2D3pfGL6nlMG78Bcb74AgMBRTmUVLyw1CcLiczwRWktUQIDAYRla5F6xHUr2xQNbScprxwCAwEE/puGxeBW5Q21OIYU3EosAgMBABL5QRaXkaYPpq/L8dygTgIDAc0jaU40gkB2k6Ny3DkJLJYCAwGM+k/bIn8iMILHdxebn/E2AgMBTqfHpe7MRSeoxewCQUKKsQIDASCMc2GzUTfhaHqbU/mU02ICAwG17xIOVxvEJY2yti3RfMz8AgMBI8ozKwUf/+B6AGAJa0gVmgIDAQ9/5h3SKhb6e/GnQvnMQ44CAwEfrQ51PKzUDnrBkhZfDr57AgMBP5JPdMy92z6E1kxsJZwLdAIDAYFizd6xUdHzu+pantDfjb4CAwHT9Z3G1gsw7IZn4OP4x7BQAgMBJe2XT8gEGhKl1UY0AoY8qQIDAWHP/IouqJY04Jzg055FAogCAwFrhxlk8mFGRfxntx6nVRHGAgMBZAByJbBVzjIDhoVEORcoowIDAegckNbbKoIItEMEWEL4yb0CAwFFTujZ9HRuEm9w9vneSWuKAgMBFvVBtsk3JC31Oie//EchDQIDAfYLCP70EVDIDO0qBBmu5JkCAwFZbDJkNz6YZbIsMWxqXZDXAgMB+hRaYEbNPzL5KM8GEuJRgQIDAabE5eguTyrYJzWUwbcSeWACAwHU7PM3Psum678WEPppT1AKAgMBQQr0VYAOK98bPiV5jICbYAIDAfNi3A8LmWTfMMPqoASON5wCAwE+8o7wZugyI/03Bo+mV9zoAgMBJMuAkN87tEARbv8VjEjVpgIDATRfku0n53KWFvNta4yk/2kCAwF+Nr+tOPp7U0ghInFMaGLJAgMBlw/e7gmn4iyICMYLhQyBqAIDAVa20n2ffe0g2U7m3gq5KFgCAwFdOHHD4EaboZlSo5QE3bsVAgMBe+6fCI+StufboTkWX61eUQIDAcfEByCiqza1BMya8GOaL8YCAwHU3NuymwrciD9s93yW/RDnAgMB4TrruJBw36kpQt4Pzu1R4AIDARjYUD5Cs9jybVIVs/BEJJ4CAwFQ7On5uUGimXiqMn9m99t0AwMBN0ph9oVhkV2ck8UTOgMVvwMDAVCv01WwYaq3THt21XIl4jQDAwGrn/h2/ygpcmqUNbQxYMEYAwMBHAMnjfOZN9JnUPeI3/quYQMDAeMOtuowcWbAhLL6tAe3PrIDAwHqyAqx5LHRl8MhRlphJ9aFAwMBLnpGXP+gwpM3W6PX4wP36AMDAZwvcBoHG8idPVqrE3o+6YMDAwEFxWUTqEb+/f4ycyVsVGd2AwMB/grmHBwJyrwRqdrn2nnirAMDAUwsZ7fS2JvTiQw+3Vh+fBEDAwHX6UAE4ny9DDqljyYpYP8YAwMBU9OLvCdKU63zD4SGuON8JgMDAabOb+lzM4Al+xkjT9sJ/5kDAwFYZaB6+6NICE1sBridO9eeAwMBdUUbZS4dAgt4hwHmB2EhCgMDAdzjlTvQkREyMomGA1Ioy0MDAwEWBYt6KusEYlt5dlVNKPVAAwMBgoyATQldKl/EzqXGLdpYFwMDAd2SF6yBBog6baSxNIlU9ZwDAwG5lWGyDu3IRtUzO0UBGkBqAwMBN0bXwfu6lUn2Ar2PXRsw/wMDAUhLTKQVhjSjNYwMRwhhICIDAwFh/547w8hkCT2AeeMcq3oKAwMBKSiofUb3a4R56mJjmOOf5QMDAbPSOMicf8kF3Fs4QZeE1wUDAwFKCJPL6TegPTlWBPvFxSGvAwMBzl6TtiyBdGn0de29mvBdGAMDAYgHwto3NB8t0WMdEoY8t8oDAwFx1m0nXr6AFyyB0mSaBdRJAwMB/OdyZcEdRz7kKiJeisjCIAMDAXUMTc8I+nen3+AAprNg5JgDAwH7lW/7QUZwnVk9L1hB0OWbAwMBVuNTL4XmlPy/dj1cb1HxNgMDARySMAzrNvD9hEYw7ih/Nl8DAwFuFCsVOiDczEBV5ItqKnOvAwMB+oRzczsTLu/sNQMPdJlizAMDAXkG/yNweHJotWQmo8sxzGADAwEI3nRtWMRQ8eB+z1Frs+GJAwMBNHYs29GEjMsa3XSd1ZDrBwMDAYYoB0LheW9PDxie37o6OWsDAwFZMqYMU6lmrv3AS8sC/D8WAwMBipy3fbFpcRDPmTbNt/aLnwMDAehqexi9MrQeBt6zz/4KAnoDAwELcaKLzbBhfWEFYn8ClBKBAwMBxw9mh4XEMVIWHFXqfzAVbwMDAe0tj0mbJ8PXaXSS9ageZ6YDAwE/W/88S9r+G507oTPiMCBQAwMBqPvuu2pUfQySxkqCJANnbQMDATbC1WrSFYdd33T3NwpxtAwDAwFFg8l0RU6VQ/4rgJsASuzVAwMBtaybehNAoE0x8VKnSRtWSQMDAYX9SCpKTkUNQiRKZNJ+eoIDAwFN16IWDzkuEz4wmIHaeRp6AwMBu0ZXWfMfNKPL+hWIWtQnpwMDAby846umLiaxZOIG/wIOJx4DAwFhgujIZKcM9Pknv2OEt/Q6AwMBDYkzXFDM/fBQHt3P/otqNQMDAX1e3stxnIS7tzOTS0f0wXgDAwEUKqCYvPxXtc5DizFYNCD9AwMB1tzbnr3Xg/KkepyjWZlVxwMDAY/gbZOlnfWRX3tv83iiGFoDAwGnTel2etW7qDe2XI5AxMPWAwMBBoKbv4UVlzkHPUfgUf4mTQMDAezUDNK0IhEcEu2LwOMk87QDAwEnID+tnXohokiDElTqisy2AwMBuBCF1ZyODKxAqd1nbV3aKgMDAWlaEZfnMLbJJ98JyIfYFtoDAwF9QJlDg2j+1XY94WAmxseqAwMBdRh+tW5jhm21/vON3F6MKAMDAfax9hfnx13kLCLmsrokuYoDAwEsDeNz/f1m9Lt9iWmdj0OzAwMBOxkLSYDTbsDj3kpZCsUtgwMDAd4at2WKBLEvvujbXiKYjS0DAwHUVM8ZsEsE9lvkfrFKVlV8AwMBZNhvYo6+AQpUc9YXWB2e1wMDAeFIpdvYd2cDjeIONElYCUwDAwEq9xmgtNcs9778XXvoqlwCAwMBANEo1MmB9Fr3PGsXegmTMQMDAa4tmy5PBe/HaNppbBsdjKUDAwG2fpr5FTN0APlT6UBAQiXrAwMBzSm0lhrmu3/ptJgZihvZDgMDATc403ifwQ2U/63r14zSZp4DAwEIuKKREeUn59eqCjyFKq/bAwMB8Eos32bduaUaY+RpnW/DoQMDAdfssAXaT/RR6q5G254eeKIDAwEUQv09MIhTGJhRtNZR91gtAwMBUyNccBVBsP/qDZHd7boEUAMDAd1QxSwXXwaJwwO2s3RWfdkDAwG8edoa+X2h7S4XahVtbNkPAwMBhEftjxwOHD+z9WCXOzHxTgMDAbyKb85yhwVWYqEIU/Q322QDAwGChW7fTiSOxP8nIsFal79UAwMBXb4Nf0S6KT3Bp1LcfUkBUQMDAcaPlkfKXEylLPt56slcGBYDAwEiZ8iZyk4t3/9w/P3xq/nVAwMBqadP4YIHXsMNWCZvEoTCZAMDAbSALRBORy5/yL+lMcWIMX4DAwFUMvZoY4xRCsZ2K//bL4eiAwMBQOatns7c0Lxrp3WF6s4bZgMDAaaM3O4BBagdO5MD4U3s+sUDAwG3VeD+mCJ4y0X5vnbeT/NmAwMB8z0Q+/bPC6ewx3Q08RXBDgMDAVX0XjT7gjGf9bKWuW6d7aMDAwFpHqSkzv0lQc/Wg0FzVA0qAwMBwQpp3RfkD9tov43tzsPM3QMDASAmhZejrjDqE0IpupTy06cDAwFDAYZxhDrxBNOicYeRppoKAwMByq3uPKWyIhtfuTXuDc3LBAMDATf1TAWFypspreN6oC7aRh4DAwGQ/qhq0TSoFmDRrbjyPjdCAwMBG6KGKrLFYe/nuIARKfcVogMDAc9tHhFu9CrEzemnexZqo0kDAwE+Qmkeyl7/Z76pPafHFVe5AwMBtK+MtrFN2Qa15kQt4rgpCAMDAdAhHkRcpGVhvhlPh2v/baADAwGH3ELmbNFSR0dtu7opRyr6AwMBEf0RaDjAZv/6Q/1mdumB2AMDAbBH/LA8gI+A+LMAzSGKcwoDAwHaUrjETxdRvuz6TXKojVrrAwMBy5bUp1gazn9hySN8M/du0wMDASrLvj5MEfsFgiHjWe3SDLMEAwHA3/RdiyvVFSL3Dpz1ahyyBAMB5m44DMFLrQJXxbIwkWGsBQQDASoRc35ZIZHahp1bI8smN5QEAwEjEI6kUxk0qMvqxFDykMIDBAMBmR2EkmBTSHtC66Xif+tlsAQDAVghT0vwOd6ninNu6tyMfFUEAwFJGygk9tHWPQ5Se3QyuOqOBAMBDBrQQ8tgu1Gtdeb223HaTAQDAQBWFEMxGMLsgqJxGXpMDf0EAwGfISVui61a8D3pU5j/yb9vBAMBlvmEFbAWONgLyZ4gt+yEqwQDAaB4HMTaiPoNSKBC7jiQAv8EAwEzxVv9YEN9TgCqqIxPygTNBAMBCuRNSX2YgC1OuyeZscQI8QQDAW2Kh1TOIuJZkk66T5pt0XIEAwEBaeBvtvSXZKE3bwsbTYhRBAMB0fmkuMp3NNeF5C419z05dQQDAezeOnsVcAC7g6Z+D26WqwUEAwHKKnYq7sJzoM70QHMfIekkBwMBVYGQxQbSYAX1y/MNqGGM8gcDAeu+AABzmOb74Nqqb6ecrZ4HAwHfLVQ8+Q7ZRDLwWDY0bYGFBwMBv776qp1rKbk+NT+wdS/yIAcDAdmu5mxktgh7qBx2BaQadi4HAwGo52kGuw1Kt+7g9rHSkOHEBwMBBRC1QbjWrB81TLHS8hem6QcDAZn5i7L9qVhlJo6X3qbp7YgHAwFTpc+1JCZT6cfcxYMeePQrBwMBA186c1hN7kcPM9ig8Ch0pwcDAXgbQrJ7lYL5ds4iZfuesvsHAwFIAPslifZhwWcoDrrICtZEBwMB</ZABiAG8A>
<bQBlAHQAYQA_>o7k0Zhl2jig2t8itmcH9fgIAABQE30N9/wDPVzBKNejBrbwCAAActwUoPpmbmUiuwWU2Bc0XAgAAPVYaM6WLFjBNzJxL+WB7xAIAAAwT1kRZe2cE+Pu2Tkb1I5QCAAB0DMJ/NSeeXtaaqJf6WXtvAgAA0f2qFYcM66qlPkanwDzeDgIAAJ2ceJGxlYbBtAmMBJYOTAwCAADiRmzORRJgc0bmLJN34hy8AwAAvF73YZZxFBTILAXqTDkQKQMAAGqNnxEcP30FlhE4ClWPFQADAABnP+hVdCW6nUova0ozrk0RAwAAlL34rTHBPO+P+1se5gipYgMAAG+zNCQd8uonGQW3z8eulfQDAACyCQM5sHr1eijQtx1glBsGAwAAJewliw87St8fuk8ky80xlAMAAE5f4WHl9iJBQujbe6E7cfcDAABnWFHTA5ffmfBurtCMZI7YAwAAX6jxIffLatGOlVHavnNIeQMAAP9K4hQsbADc0yyV5o9pjfkDAAD/Erovucsncce39xnj6qshAwAAGinNrXt2m9w/mcr86+drjgMAAJDehQXGI3DCHn6PBu56wLgDAADPtaWy2eKjs1WQ3RLv7xg/AwAACci2GbUdiZ8/BFAQ2gZeXwMAAGjinBlZ8Tq2h7RhtgtjaFgDAABQqedqRL7+E2289NvfE0+QAwAAXIAiF3rCt9IjDYYQf9nj4wMAAHOILC7jqaqp46vBD71Z1LoDAACD/6tCynETh2+53w2G912VAwAAMutVZ9dtznQlon7OpL+8cQMAAKfLv0wZNxfOiNYB7lkFO/UDAADbuAmqO6uTVKSZt7PD99LKAwAAQCxEyw3hk9FFOg18mX/s6wMAAMjwMfD/vWHxQkLtNvD6WHEDAAAkCz0sZAD3hueZUP1QPF6IAwAAsYvW0mWHYy4QsHCb3xPWxAMAAGoQhzI9NB4Gw1vrljmqVOkDAACcLIoj3Ge/zVaCf8MZ846uAwAANrPhp9OzxziXk2phYEJRiwMAAK9KaRXS5Yjdyi5pvoVRcocDAAAspMhfMhhhgDLh7uQjDR3xAwAAJHB+xrH+vRhUMdv+ONj32gMAAHR0DfiqGgyO/Bka4uI+K1IDAACbM/skkcmgdc6mRDUNVTUPAwAA509fwkKnzzQbCjeiaAyaOAMAAEkUlq6ZNsN0gcLZkgaBL6MEAABRSlz2gT6MywbjK98WgoK+BwAADZeEmmc0hrlltsz4P60HHwcAAO2i9hrd5d7adpHdAnhyVOIDAAA_</bQBlAHQAYQA_>
<UgBlAGQARwBhAHQAZQBfAFMAUQBMAEMAbwBtAHAAYQByAGUAXwBEAGUAZgBhAHUAbAB0AF8AUwBjAGgAZQBtAGEA>QAxuS6edULIvuuG2HXZszxsAAA__</UgBlAGQARwBhAHQAZQBfAFMAUQBMAEMAbwBtAHAAYQByAGUAXwBEAGUAZgBhAHUAbAB0AF8AUwBjAGgAZQBtAGEA>
<Grouping type="ListByte" version="2">
<value type="Byte">63</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
<value type="Byte">0</value>
</Grouping>
<SelectAll>True</SelectAll>
</SelectedSyncObjects>
<SCGroupingStyle>0</SCGroupingStyle>
<SQLOptions>10</SQLOptions>
<MappingOptions>82</MappingOptions>
<ComparisonOptions>0</ComparisonOptions>
<TableActions type="ArrayList" version="1" />
<SessionSettings>15</SessionSettings>
<DCGroupingStyle>0</DCGroupingStyle>
<SC_DeploymentOptions version="1" type="SC_DeploymentOptions">
<BackupOptions version="1" type="BackupOptions">
<BackupProvider>Native</BackupProvider>
<TypeOfBackup>Full</TypeOfBackup>
<Folder>D:DatabasesBackup</Folder>
<Filename />
<SqbLicenseType>None</SqbLicenseType>
<SqbVersion>0</SqbVersion>
<DefaultNativeFolder>D:DatabasesBackup</DefaultNativeFolder>
<DefaultSqbFolder />
<Password encrypted="1" />
<NameFileAutomatically>False</NameFileAutomatically>
<OverwriteIfExists>False</OverwriteIfExists>
<CompressionLevel>0</CompressionLevel>
<EncryptionLevel>None</EncryptionLevel>
<ThreadCount>0</ThreadCount>
<BackupEnabled>False</BackupEnabled>
</BackupOptions>
</SC_DeploymentOptions>
</Project>