Activity overview
Latest activity by GeekyCat
Hi Kendra - Thank you for your response. I am using SQL Source Control. I'm sorry I didn't provide that first. Between Dev and QA, there are objects that I don't want synced and I've created a filter from SQL Compare to use a scpf file which is in the a folder that the agent can access. I have a changeset that, when I look into it, I see the 2 scripts that I committed associated with the Release Pipeline. (Image 403). I've provided screenshots that hopefully will provide the needed information. But when I redeploy the stage object, you can see in the sample logs that it's actually doing so much more. Including dropping tables that have actual data in them. Since QA (and Prod) contain update and refresh scripts for those environments, I can't make each environment exactly the same. I'm sure I'm not the first person to do things this way. Is there a better way of setting things up? Please let me know if you need more information and thank you so much for your help Cathryn [image] [image] [image] [image] [image] [image] / comments
Hi Kendra - Thank you for your response. I am using SQL Source Control. I'm sorry I didn't provide that first. Between Dev and QA, there are objects that I don't want synced and I've created a f...
Did you find an answer on this? I had the same thing happen and it re-deployed all the additional objects as well / comments
Did you find an answer on this? I had the same thing happen and it re-deployed all the additional objects as well
Build a SQL Source Control project error
Hi AllI've been struggling setting up a CI project and I've gotten to the piece where you create a pipeline to make sure it will run successfully. The error I'm getting is:SQLCompare.exe terminate...
Hi Kendra - could I get the reference you for linked servers? I am trying to overcome this issue as well. Thank you Cathryn / comments
Hi Kendra - could I get the reference you for linked servers? I am trying to overcome this issue as well.Thank youCathryn
Standard setup for SCA when you have Dev, QA and Prod environments
Hello I'm just starting to set up my SCA all the videos I see only show the option for 1 target DB. I'd like to deploy from Dev to QA, be able to test and then deploy from QA to PROD. Do I need t...
Linking Azure Storage: Object cannot be cast from DBNull to other types
I just upgraded to SQL Backup 10 and I'm trying to link to my Azure Storage account. When I fill in the info and click 'Link Account', I get the error 'Object cannot be cast from DBNull to other t...