The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
Hey dexterama, I've just noticed your post above. I'm really sorry to hear you're not happy with our tech support team's response, which was (word for word) as follow:
"SQL Source Control uses SQL Compare's dependency engine to create updates. It will not work to say create object type x and then object type y because SQL Server dependencies are way, way more complex than that. It may work on your database, coincidentally, but not for everybody. SQL Source Control should perform operations in dependency order - it scans the text of all objects and creates a dependency matrix from that.
So what the most likely problem is, is that the SQL Scripts in the repository were not created by SQL Compare or SQL Source Control, or are not using the same folder structure. In that case, some objects can be missed or created in the wrong order. Of course, since I do not know the state of your repository, I cannot offer any specific advice about how to fix this. We'd need all of the files so we can try to investigate it."
The tech support guys want to do their best to help, but sometimes they need people's collaboration...the guys have explained in the forum post what they need from you to be able to point you in the right direction. They're awaiting for you to get back to them.