Activity overview
Latest activity by sasankj
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.
DB permissions required
In the " Deploy database changes from from artifacts" step..what are the permissions required by the Account (either windows authentication or SQL authentication" ) on the target DB and target DB s...
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...
Baseline script giving errors
I created a baseline script for one of my DBs and it didnt generate proper script for Default Constraints. Please see belowCREATE TABLE [DCST].[XREF_REL_SETTLEMENT_COMPLAINT]([SETTLEMENT_KEY] [int]...
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...