SCA in SSMS add-in mostly "(Not Responding)"

• 
  Hi Peter,
  
  I am sorry that you are having issues with SCA for SSMS.
  I will follow up using our support system since we need additional diagnostic data to troubleshoot your issue.
  
  Kind Regards,

  Sergio R January 24, 2020 14:42

  - 0 +
• 
  Much appreciated, @Sergio R . I will want to strategize with the support team on how best to handle some other issues with baselining this DB.  It has programmable objects that have linked server refs, cross DB refs, etc.  Getting a deploy to my dev DB has been a challenge.

  PeterDanielsCRB January 24, 2020 16:34

  - 0 +
• 
  We will look at the logs and will get back to you soon.
  
  Regarding cross-database dependencies the following article might help:
  https://www.red-gate.com/hub/product-learning/sql-change-automation/resolving-cross-database-dependencies-in-sql-change-automation-using-local-databases-or-clones
  

  Sergio R January 24, 2020 17:11

  - 0 +
• 
  That article is helpful - thanks.  I want to explore the idea of a pre-deploy script making stubs.  I'm still a bit confused on how to best ignore certain objects and programmable object scripts without having to redo the entire baseline generation that takes so long. I do realize I'm hacking away in SCA at this point.  Just want to get this puppy into source so I can develop some new objects.

  PeterDanielsCRB January 24, 2020 17:24

  - 0 +
• 
  @PeterDanielsCRB - Is there a reason why you can't have copies of the dependent databases in your environment so the baseline script runs?
  
  
  

  David Atkinson January 24, 2020 17:31

  - 0 +
• 
  Thanks, @David Atkinson.  I've been working that angle, too.  It worked for one simple DB; I just created a shell for it.  The other DBs have the same kind of problems - cross refs, and are too large to restore onto my laptop.  Considering a cloning tech like SQL Clone/PSDatabaseClone.

  PeterDanielsCRB January 24, 2020 17:35

  - 0 +
• 
  @PeterDanielsCRB - You mean a shell which is schema object only (no data)? If so, that's an interesting idea. SQL Clone should allow you to not only spin up dependent databases in dev, but also throughout your CI/CD pipeline.
  
  

  David Atkinson January 24, 2020 20:49

  - 0 +
• 
  The issue initially reported SCA in SSMS add-in mostly "(Not Responding)" has now been fixed, please upgrade to version 4.2.20036 or later

  Sergio R February 21, 2020 16:03

  - 0 +
• 
  I hear ya, @David Atkinson - re: full clones.  Just not sure we have the $ for SQL Clone/Provision at this time.  Ergo, looking into PSDatabaseClone.  Meanwhile, I'm going to mark @Sergio R 's last one as the answer even though I have not tested it again since the fix.  I have confidence in the team.

  PeterDanielsCRB February 24, 2020 20:48

  - 0 +

Add comment

Please sign in to leave a comment.