SDK vs Application
MarkHeesom
Posts: 5
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>
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>
Comments
Thanks for your post.
Can you quickly tell me what is this object 'FK_ItemSubTypeID@JobItem' is it a foreign key constraint?
And when you mentioned failed first time did you do any partial deployment? that made that error go away?
If not do you have transactions turned off?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Sorry for the delay in responding. I didn't have notifications on.
Yes, it is a foreign key constraint and we haven't done anything specific to get the compare to work 2nd time.
We are also not doing anything specific about transactions so I assume is default, and I would guess off. We are hoping to have the code behave identically to the application.
Thanks,