Comments
Sort by recent activity
@Russell D - thanks for investigating. In answer to your question ~ no". Both projects were created identically (except the databases of course). But one continues to serve up the change list of previously unchecked objects still unchecked and the other serves up the change list of objects with all objects checked even though, all but new, objects were previously unchecked. / comments
@Russell D - thanks for investigating. In answer to your question ~ no". Both projects were created identically (except the databases of course). But one continues to serve up the change list of pr...
Thank you Arneh. Although I had a bit of trouble getting the project to load a filter in VS 2017, it seems to be working now. I'm aware of the filter option, but, for some unknown reason, in one of the projects, the roles and users, after having been unchecked/excluded, always remain unchecked/excluded; but in another project the objects continue to list as checked/included; so I'm wondering if there is a setting or a trigger action that ensures that once unchecked/excluded the object will remain unchecked/excluded in object changes list. I would like for the objects to remain unchecked if there is a setting or a trigger to accomplish retention of the unchecked box. / comments
Thank you Arneh. Although I had a bit of trouble getting the project to load a filter in VS 2017, it seems to be working now. I'm aware of the filter option, but, for some unknown reason, in one o...
unintended post / comments
unintended post
We are also looking for the best practice solution for ignoring the users and roles. Ensuring that the filter includes the required exclusions seems like a good option; however, in VS 2017 I am not able to load a filter.The documentation instructs to place the scpt file in the root (project) folder and then 'unload' and 'load' the project. Loading and unloading the project in VS 2015 works, but I am unable to get the scpf file to load into a VS 2017 project. / comments
We are also looking for the best practice solution for ignoring the users and roles. Ensuring that the filter includes the required exclusions seems like a good option; however, in VS 2017 I am not...
Dan B. While I don't understand the logic. I followed your suggestion to remove the target migration objects from a target database and the baseline stopped deploying. Truly I don't comprehend the logic, but, thank you for your valuable help in this forum. / comments
Dan B. While I don't understand the logic. I followed your suggestion to remove the target migration objects from a target database and the baseline stopped deploying. Truly I don't comprehend the ...
Thanks, Dan B. Yes, it does exist but I tried to add a filter to the project to exclude objects that begin with '_' but the filter doesn't load up in Visual Studio 2017. The instructions are simply to drop the filter file into the root of the project (same folder where the project file exists) and then unload and load the project and the filter should load up in the project. But this isn't working (the filter file loads up in VS 2015 but not VS 2017). Have the filter instructions changed? I'm not understanding the logic of removing the migration_log from the target database to stop the baseline script from running. The objective of the baseline script is to run against an empty target database. If the migration_log exists on the target database doesn't that mean that the target database is NOT empty? BTW - I'm just using a simple 3 step CI/CD method: 1 build task = "build the sql change automation project" & 2 release tasks 1) PeformCreate & 2 ) PerformDeployFromResources. Thanks for any help; much appreciated. / comments
Thanks, Dan B. Yes, it does exist but I tried to add a filter to the project to exclude objects that begin with '_' but the filter doesn't load up in Visual Studio 2017. The instructions are simply...
@SERVERNAME = 'NOTHING'" and the condition does not stop the baseline from executing. What can I do to ensure that the baseline does NOT execute. Once it's created, I can't delete it. The documentation states that the condition will restrict the baseline from executing even on the first release. Should I un-comment the baseline header? / comments
@SERVERNAME = 'NOTHING'" and the condition does not stop the baseline from executing. What can I do to ensure that the baseline does NOT execute. Once it's created, I can't delete it. The document...
We decided to create the target DB before we create the SCA package. / comments
We decided to create the target DB before we create the SCA package.
Follow on note: The target DB is set in the release environment to the target server and same DB name is used. / comments
Follow on note: The target DB is set in the release environment to the target server and same DB name is used.
we set our SCA test project without a target DB and when the release runs it errors because the agent can't login to the SQL Server database. But the database doesn't exist, yet in the failed step our agent has SA so it can do whatever it needs to do).. / comments
we set our SCA test project without a target DB and when the release runs it errors because the agent can't login to the SQL Server database. But the database doesn't exist, yet in the failed step ...