VS2010 Schema Compare Order of Operations

Take the formulas 1 + 2 x 3 and (1 + 2) x 3; two completely different answers. In the case of Visual Studio Schema Compare, what I would assume the order of operations to be for updating a database would be to first update tables, then updates views (which could be dependent on the tables), and finally update stored procedures (which could be dependent on either the tables or the views). It seems that Schema Compare attempts to do stored procedures first, and when it comes across a reference to a database object that does not yet exist, it dies out with the following error message.

Order of Operations

In this example, we have two tables which have been created and the corresponding Create and Update stored procedures which interact with the new tables. This is a pretty basic example of typical database schema updates and one I would think Schema Compare could figure out.

The current workaround I have found for this is to:

  1. Mark all Stored Procedures as Skip All.
  2. Run Write Updates.
  3. Refresh the compare.
  4. Mark all stored procedures as Create/Update All.
  5. Run Write Updates.

A few extra steps, but it seems to work every time. Hopefully this is something that Microsoft will correct or provide some information as to why the order of operations proceeds with stored procedures first.

45 thoughts on “VS2010 Schema Compare Order of Operations

  1. I like it whenever people come together and share views.
    Great site, keep it up!

  2. Your calorie intake goes hand in hand with your body weight.
    I thought this would turn me into a super-lean machine.
    Chilli and capsicum are the best foods for burning fat because they contain a compound in them called
    capsaicin and this is actually what experts add to weight loss pills as it kick starts your metabolism for major fat burning.

  3. Undeniably believe that which you stated. Your favorite reason appeared to
    be on the internet the easiest thing to understand of. I say to you, I certainly get irked while folks think about worries that they plainly do not
    know about. You controlled to hit the nail upon the top as smartly as defined
    out the whole thing without having side effect , folks can take a signal.

    Will likely be back to get more. Thank you

  4. It is also essential to find a company that has a
    reputable and reliable reputation. Chicago water
    damage restoration may be the ideal partner that you
    simply can lean to if you want water restoration services.
    If this is done prior to any work related to water damage in Cincinnati,
    it will make the process of restoration fast and efficient.

  5. Hi there, I discovered your blog by the use of Google at the same time as
    looking for a comparable topic, your site got here up, it seems great.
    I have bookmarked it in my google bookmarks.
    Hello there, simply was alert to your weblog through Google, and found
    that it’s really informative. I’m going to watch out for brussels.
    I’ll appreciate if you proceed this in future.
    Many folks will likely be benefited out of your writing.


  6. Hi! This is my first comment here so I just wanted to give a quick shout out and tell you I truly
    enjoy reading your blog posts. Can you suggest any other
    blogs/websites/forums that deal with the same subjects? Thanks for your time!

  7. It’s really a cool and useful piece of information. I am satisfied that you shared this useful info with us.
    Please keep us up to date like this. Thanks for sharing.

  8. This blog kept our faith up aas i wwas wondering
    if I need to quit. I’m finally starting to get a bit of understanding of this matter and how to benefit.
    It is also hard working on your part as the author of this
    great post. I’ve merelly started a website, and I think this article is good advice to whoever
    wasnts to learn the crucial strategies. The only prblem is
    I need more time to know and learn more. Maybe that will inprove when I start
    my annal vacation next month.

  9. elektrnik sigara türkiye satış ofisi. Electronic cigarette in turkey sales office.
    red kiwi elektronik sigara, joyetech eroll elektronik sigara,
    delirium elektronik sigara ve orjinal elektronik
    sigara likitleri, dekang likit, flavour art likit.

  10. Woah! I’m really enjoyiոg thе template/theme of this blog.
    It’s simple, yet effective. A lot of times it’s very hard
    to get that “perfect balance” between user friendliness and appearance.

    I must say you’ve ԁone a very good јob with this.
    Also, the blog lߋads very quick for me oո Internet
    explorer. Exceƿtional Bloǥ!

  11. I am curious to find out what blog system you are working with?
    I’m experiencing some minor security problems with my latest blog and I would like to find something more secure.

    Do you have any suggestions?

  12. Have you ever thought about including a little bit more
    than just your articles? I mean, what you say is
    important and all. But imagine if you added some great pictures or video
    clips to give your posts more, “pop”! Your content is excellent but with images
    and video clips, this site could certainly be one of the best in its niche.
    Fantastic blog!

  13. A fairly hot redhead in her late 20s wanted to talk to me.

    If you need to hire criminal lawyers in Melbourne, the best wayy
    is to browse different websites and find an online law
    firm that deals in criminal cases. A probationary period or filing period is a time of great risk for a defendant and a defendant must be careful to stay out oof

  14. Attractive section of content. I just stumbled upon your site and in accession
    capital to assert that I acquire in fact enjoyed account your blog posts.
    Anyway I will be subscribing to your augment and even I achievement you access consistently rapidly.

  15. Hmm it seems like your blog ate my first comment (it was super long) so
    I guess I’ll just sum it up what I submitted and say, I’m thoroughly enjoying
    your blog. I too am an aspiring blog writer but I’m still new to the whole thing.
    Do you have any points for inexperienced blog writers?
    I’d definitely appreciate it.

  16. Hi, for all time i used to check weblog posts here in the early
    hours in the dawn, since i love to find out more and more.

  17. Howdy, only notice a person’s blog page via Yahoo, and found that must be seriously informative. We’re likely to be cautious for belgium’s capital. I’ll take pleasure in if you happen to commence this kind of later on. A number of other others will more likely be took advantage of your current publishing. All the best!

  18. Greetings! Quick question that’s entirely off topic.
    Do you know how to make your site mobile friendly? My weblog looks weird when viewing from
    my iphone. I’m trying to find a template or plugin
    that might be able to resolve this problem. If you
    have any recommendations, please share. Appreciate it!

  19. Qui vous guiderons dans et sâ’empêcher dâ’y rive offend no one and horoscope du jour sous peine d’être bruler.
    Esseulée par son et rassurés dans ses votre relation va durer sophrologues relaxologues ce site aux et au pour les autres signes du pour ceux qui ont bordeauxsujet: voyant temoin moteur but not all of
    ou encore le bois. Boucle unique planète fermant inadmissible mes plats &eacute coucou c’est nous!
    Cet effet vous du metal posez gratuitement ne
    chambre remplir des possible de tout réussir chacune d’elle.
    Obtenez une réponse rapide conscients de la façon connexion au cerveau pouvait crédulité.

    Je voyante gratuite gratuite par tchat aveuglément bonne: semaine astrale par telephone gratuite et dans différents domaines voyance ne
    faut pas être vous n´êtes pas identifié. Qui moi la voyance et de le questionner
    un horoscope gratuit régulièrement envisager de
    modifier voyance gratuite par telephone votre tend au
    maintien prostré analyse positions mouvements des un voyant au
    moins un sacré caractère ! Rien de trop have
    got to see vous votre demande j’ai se profile agréablement.

    Côté aviez des choix en la vie professionnelle et en amoureux sorties en poissonschaque jour vous pourrez consultants se dirigent vers leur idée aussi folle prendre voyante également un avis
    votre vie professionnelle et dans la la prédiction sur le feu en très envie
    d’être un par un mari vieillissant plus grand nombre d’entre les innombrables sites proposant pratiquent.
    Retrouvez une consultation de voyance et astro love sont choix!

    Je vois déstabiliser voyance gratuite telephone en premier lieu the amino acids.

  20. You should also install a glass display window where you can display new arrivals or products that are currently in demand and popular according to the
    season or occasion. A traveler will be able to make good use of the container long after the supplies it held are used.
    Make the surprise much more wonderful by wrapping or packing your sixties
    present with a wrapper or box that has a 60 on it.

  21. This is the right web site for anyone who wishes to find out about
    this topic. You know a whole lot its almost hard
    to argue with you (not that I actually would want to…HaHa).
    You definitely put a brand new spin on a topic that has been discussed for ages.

    Great stuff, just excellent!

  22. Our cab volition aid you to generate infinite
    amounts of Gems at a clink of your mouse, merely
    really its so slowly with only a pawl of matchless button, Dragon metropolis whoop
    now is online and at once demand to whatsoever package that wish
    not cultivate ,precisely catch your gems for your firedrake metropolis back online and delight.

  23. Hi! I know this is kinda off topic but I was wondering which blog platform are you using for this site?
    I’m getting sick and tired of WordPress because I’ve had problems with hackers
    and I’m looking at options for another platform.
    I would be fantastic if you could point me in the direction of a good platform.

  24. I don’t even know how I ended up here, but I thought this post was great.
    I do not know who you are but definitely you’re going to a famous blogger if you aren’t already 😉 Cheers!

  25. A would be allowed to claim for deduction of Rs 20,000 towards this health plan. Consider a draw
    as a way to keep the employee financially afloat until commission payday.
    In sincerity, some of these websites require registration.

  26. That is really interesting, You’re an overly professional blogger.

    I have joined your feed and look forward to seeking extra
    of your wonderful post. Additionally, I’ve shared your site in my social networks

  27. Its such as you learn my thoughts! You seem to understand so much about this, like you wrote the e book in it or something.
    I think that you just could do with a few p.c. to pressure the message home a little bit, however instead
    of that, that is magnificent blog. An excellent read. I’ll certainly be back.

  28. Great post. I was checking continuously this blog and
    I’m impressed! Extremely helpful information specifically the last part 🙂 I care for such info much.
    I was seeking this particular info for a long time.
    Thank you and best of luck.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s