User profile for way0utwest

So, if you look in the folder where you've specified for the release, there should be an Update.sql file. When I run this in TFS/VSTS/Octopus, this is what is generated as a set of artifacts. You can also run this from the command line, using the parameters for your system and look at the ouput. I assume you have a build, correct? The output of the build should be a nuget of all your vcs. In my release folder, the folder that I have specified as the location for the package , here's what I see: [image] / comments

So, if you look in the folder where you've specified for the release, there should be an Update.sql file. When I run this in TFS/VSTS/Octopus, this is what is generated as a set of artifacts. You c...

0 votes

What is your source for the Jenkins package? Are you using SQL Source Control or SCA in Visual Studio to do this? The SCA project should produce a set of all migration scripts, but also a package of just changes, based on the target db being set to the downstream environment. / comments

What is your source for the Jenkins package? Are you using SQL Source Control or SCA in Visual Studio to do this?The SCA project should produce a set of all migration scripts, but also a package of...

0 votes

If you're using SQL Source Control, the output of the build is the entire repo, because this is the state of the database. Once you use an SCA cmdlet to produce a deployment package that is just the changes. / comments

If you're using SQL Source Control, the output of the build is the entire repo, because this is the state of the database. Once you use an SCA cmdlet to produce a deployment package that is just th...

0 votes

How would you identify this? I'm guessing you have a value in a parent tableof the PK(s) that you need to delete, but want those removed, along with cascades. Is there a reason you can't turn on cascading deletes? / comments

How would you identify this? I'm guessing you have a value in a parent tableof the PK(s) that you need to delete, but want those removed, along with cascades. Is there a reason you can't turn on ca...

0 votes

We don't. Data Compare won't do this unless you select all the child tables, and had the data already removed. You can certainly turn on cascading deletes and then run your delete, and then disable this. Is there a reason you can't do this? Or maybe I misunderstand your issue. What is the "junk data"? Is it all data? / comments

We don't. Data Compare won't do this unless you select all the child tables, and had the data already removed. You can certainly turn on cascading deletes and then run your delete, and then disable...

0 votes

How are you doing the deployment? Are you seeing this folder discrepancy when running the PoSh from a cmd window? / comments

How are you doing the deployment? Are you seeing this folder discrepancy when running the PoSh from a cmd window?

0 votes

The Output window (lower pane by default), is the one to use. There's a drop down in there, and you typically want the Build or General items selected, depending on what you're doing. A deploy usually results in a build, so be sure to check that. VS usually switches this for you,but if you have it set to your VCS or something else, you might not notice. / comments

The Output window (lower pane by default), is the one to use. There's a drop down in there, and you typically want the Build or General items selected, depending on what you're doing. A deploy usua...

0 votes

I think gitflow is unnecessarily complex, and it's problematic for databases, but if you use it, that's OK. If you look at gitflow, you aren't putting your changes from the local machine to the remote db, are you? You are sending your changes to the VCS and the SCA automation process should push them to another machine. However, that doesn't matter. You push/pull your changes from VCS, which is what other developers do. First, you need strong communication if developers might touch the same object. That can be something like a Slack channel, or some other mechanism for a developer to just say "I've changed x". This important, otherwise you'll end up with hard merges. You could even make a quick "I'm doing this" in your standup. Your gitflow should have feature branches, correct? This means you have master---------o---o---------------------o dev --------0/----o/---------o--------o fb1 \---o---\-o----/ fb2 \----o/ In this case, master is at the top, where I release. Dev is below. Let's have Steve work fb1 and Andy work fb2. Andy gets dev copied and then commits. He is happy with his commit (o) and pushes up to dev. This is the second o. This gets merged to master. Steve later gets a branch from dev, fb1, and works and commits. Change is good. He then pulls from dev, which at this point, should include the change from Andy. Steve needs to merge this in his branch, which might be simple, might be hard. If there is communication, either there is no conflict or there is the need to resolve changes. Steve then commits again and pushes/merges changes to dev later. The key here is that you need to have short lived branches for the db, since this is a shared area. If you need to work, make your branch and push changes that you know work, immediately. If you're not sure or this takes time, then stage changes and pull from dev again to get anything merged in. Then try applying your changes again. The really issue here is that the longer branches live, the more likely there are conflicts. Imagine that you have multiple C#/Java developers working on the same method. If they each make a quick change and merge, the other likely gets the changes. If they wait weeks, merging might be really hard. The same thing with databases. What I'd suggest if that you plan out changes, maybe get an idea, and save them after you've experimented a bit. This might be an hour or a week. Then rebuild the db branch again, essentially a new feature branch, and make your changes. If they're good, immediately commit and merge back to dev. / comments

I think gitflow is unnecessarily complex, and it's problematic for databases, but if you use it, that's OK.If you look at gitflow, you aren't putting your changes from the local machine to the remo...

0 votes

No. You should never make changes in Test that are needed. This defeats the purpose of using a pipeline, and is a source of problems. What you should always do is release change A to your VCS. Then this is either built or reviewed and using an automated, consistent process, release to test. If you find an issue, then reproduce that in dev, or if you can't, try the fix in test and undo it. Then go back to Dev and make the change (Change [image] , upload and re-release. This is one reason your release to test ought to reset your schema to what is production like. If you're using SCA, only the new change from dev (Change [image] will be released. Then you can test ,and when you release to downstream environments (Staging, prod, acceptance, etc.), both Change A and Change B will be in the package. This is similar to what Microsoft does with SQL Server. If they find a bug, they fix in SQL 2017 branch. However, they have to manually backport this to SQL 2016, which is often taking the changes and adding them to the other environment. / comments

No. You should never make changes in Test that are needed. This defeats the purpose of using a pipeline, and is a source of problems. What you should always do is release change A to your VCS. Then...

0 votes

Where are you excluding users? Is this a filter in SCA/SQL Source Control? Or are you adding the switch to the DLM cmdlets to ignore users and roles? / comments

Where are you excluding users? Is this a filter in SCA/SQL Source Control? Or are you adding the switch to the DLM cmdlets to ignore users and roles?

0 votes

How can we help you today?

way0utwest

Comments