What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare 10 Hung

Ozzie19Ozzie19 Posts: 11
edited March 19, 2012 5:03PM in SQL Compare Previous Versions
I'm 22% through - the mouseover said 15 seconds left. 5 minutes later I press cancel. Computer is hung - databases in unkbown state - what should I do? Great way to start the weekend.
Doug
Doug

Comments

  • Options
    I've not heard reports of this issue before.

    By default SQL Compare's script runs in a transaction, so if it doesn't complete, it should roll back.

    One thing worth trying is to use SQL Compare to generate the SQL script, load this in SSMS and see if executing it here makes a difference.

    Let us know how you get on,

    David Atkinson
    Red Gate
    David Atkinson
    Product Manager
    Redgate Software
  • Options
    David,

    I let it hang there another 20 minutes then killed it. Everything rolled back - seemed a bit odd - I never seen your tool exhibit that behavior before.

    Thanks,
    Doug
    Doug
  • Options
    I've not heard of this issue before. Very bizarre indeed.
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.