Comments
Sort by recent activity
Is this possibly an issue of the order of when things are executed (Trigger is being created before the table type has been created) in the deployment script? I have run into similar issues and had to control it myself in custom scripts. Kendra indicates she does 3 build and deploys for each change which would make it run in the correct order. On a side note having the duplicate names makes it hard to know what object the error really is on. You may want to change that regardless in my opinion. / comments
Is this possibly an issue of the order of when things are executed (Trigger is being created before the table type has been created) in the deployment script? I have run into similar issues and had...
Well I figured it out. The data was in the shadow database. Deleting the row in the shadow database fixed the issue. Un-selecting "Include table data" should also truncate the data in the table for the shadow database. Is this a bug or by design? Thanks / comments
Well I figured it out. The data was in the shadow database. Deleting the row in the shadow database fixed the issue. Un-selecting "Include table data" should also truncate the data in the table fo...
The .sqlproj just references which tables should have static data. Unselecting it just removes the reference but it seems the data is still left behind. Where does SQL Change Automation store that static data with this type of project? In this screen shot I just set the table RequestTypesSLA to include data. When I do a compare it has a row of data in it. Where is that one row of data coming from? Since I just told it to include static data there should not be an update in there. The script it generates should be if count(*) = 0 insert all rows like every other script it generates when I first select include table data. / comments
The .sqlproj just references which tables should have static data. Unselecting it just removes the reference but it seems the data is still left behind. Where does SQL Change Automation store tha...
Where are these folders kept? I don't have them in my project. / comments
Where are these folders kept? I don't have them in my project.
Is in under the view menu? Selecting it there should show the window. / comments
Is in under the view menu? Selecting it there should show the window.
Can you use a filter? / comments
Can you use a filter?
It seems like it would be prudent, if its possible, that when the operation does not match the project type in the package to throw an error on build or deployment and stop. / comments
It seems like it would be prudent, if its possible, that when the operation does not match the project type in the package to throw an error on build or deployment and stop.
Now it won't even install unless LocalDB is downloaded and installed. Please Correct this. Thanks / comments
Now it won't even install unless LocalDB is downloaded and installed. Please Correct this. Thanks
So when this command is run: Use-DatabaseReleaseArtifact $DBUpdate -DeployTo $DBConnection The snaphot is the "current schema" of the -DeployTo target? If so it should not matter if a shadow database was created or not since shadow schema should not be used. When I run Invoke-DatabaseBuild and it creates the shadow database it does not know what my target is going to be at that time so I am a little confused at which schema is actually being used for the snapshot. / comments
So when this command is run: Use-DatabaseReleaseArtifact $DBUpdate -DeployTo $DBConnection The snaphot is the "current schema" of the -DeployTo target? If so it should not matter if a shadow dat...
So the snapshot is of the shadow database and not the target database? It used for drift? I was thinking it was a reference to what the target DB schema looked like before deployment. / comments
So the snapshot is of the shadow database and not the target database? It used for drift? I was thinking it was a reference to what the target DB schema looked like before deployment.