XML SCHEMA dependents prevent drop

Automate and integrate using the SQL comparison API

XML SCHEMA dependents prevent drop

Postby cleek » Thu May 28, 2009 3:30 pm

I have a stored procedure that has a parameter that is bound to an xml schema collection. The xml schema collection has changed. Because the xml schema collection is different between the source and target databases, the SDK tries to drop the xml schema collection and recreate it. However, the xml schema collection cannot be dropped, because it is still bound to a stored procedure parameter. Is this expected behavior? What is the recommended algorithm for synchronizing an xml schema collection that has changed and has dependent objects? Is there a way to update the xml schema collection without manually dropping the XmlSchemaCollection's dependent objects and then rerunning the comparison and update?
Posts: 3
Joined: Fri Jan 30, 2009 5:20 pm

Re: XML SCHEMA dependents prevent drop

Postby xsinc.msanders » Wed Feb 01, 2017 2:13 am

8 years later. I must also know this.
Posts: 10
Joined: Tue Feb 23, 2016 9:55 pm

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests