Comments
Sort by recent activity
mkumar said:
Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account]
I am not quite sure about this permissions? Is it db_owner? / comments
mkumar said:
Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account]
I am not quite sure about this permissions? Is i...
I already did, and the DBA is asking me the permissions that need to be granted. / comments
I already did, and the DBA is asking me the permissions that need to be granted.
I can send you the project but you would need DB as well...if I am not wrong....I am afraid I cannot share the DB as it is classified as sensitive DB and cannot be shared. / comments
I can send you the project but you would need DB as well...if I am not wrong....I am afraid I cannot share the DB as it is classified as sensitive DB and cannot be shared.
Any advice please? / comments
Any advice please?
SQL Change Automation -- 3.3.19197.9405
SQL Change Automation PowerShell -- 3.3.19197.9413 Visual Studio 2017 SQL Change Automation Core Extension -- 3.3.19225.9927 Here are the default values AUDIT_USER_ID = ('-1') AUDIT_DATE = (getdate())
/ comments
SQL Change Automation -- 3.3.19197.9405
SQL Change Automation PowerShell -- 3.3.19197.9413Visual Studio 2017 SQL Change Automation Core Extension -- 3.3.19225.9927Here are the default valuesAUDIT...
I agree, refreshing may not cause issue. But an accidental drop/delete/truncate of this migration on my target DBs is what I am worried about. / comments
I agree, refreshing may not cause issue. But an accidental drop/delete/truncate of this migration on my target DBs is what I am worried about.
also , what is the use of Deployed status=2... what am I gaining by marking a script "Mark it deployed" on my source DB? / comments
also , what is the use of Deployed status=2... what am I gaining by marking a script "Mark it deployed" on my source DB?
I agree, that the table should not be dropped. But we are still evaluating the tool, so we are weighing in possible accidents. The table may not be dropped, but could be refreshed when we do data refresh from higher environements to lower. For Eg : if we refresh out UAT DB with Prod DB, then the migrationlog table would also get refreshed, so there is always a chance that the data in table gets messed. So I am finding ways to manipulate it, esp finding a way to skip a Change script from being deployed on a target DB. / comments
I agree, that the table should not be dropped. But we are still evaluating the tool, so we are weighing in possible accidents. The table may not be dropped, but could be refreshed when we do data r...
I guess let me put my question in a different way. Lets say I have a baseline script and couple of change scripts in project. And they were succesfully deployed on my Target DB. So I assume the migrationlog table would show 0 for baseline script and 1 for the change scripts. Is that right? Now, lets say, my migrationlog table got dropped by accident on my target DB. Now If I run my release pipeline, since there is no migrationlog and also since it finds a baselinescript, it safely skips running the baseline script. But it always try to run the other two change scripts on my target DB. The question is, how can i skip the other two change scripts from being run on my target DB? I tried setting them as "Mark them as deployed" from VS, but still the release pipeline is trying to execute it on my target DB, / comments
I guess let me put my question in a different way. Lets say I have a baseline script and couple of change scripts in project. And they were succesfully deployed on my Target DB. So I assume the mig...
What should I mark a script's deployed column value in my source DB so that it doesnt get executed on my target DB? I tried 0,1,2...none of them worked...i dont want to delete the script from my VS project. / comments
What should I mark a script's deployed column value in my source DB so that it doesnt get executed on my target DB? I tried 0,1,2...none of them worked...i dont want to delete the script from my VS...