Comments
Sort by recent activity
Also, do you know what type of output are we looking for? I got the access and it was a success. Now what would be the next step? I tried executing a non-destructive script and deployment was a success. How do I conclude the output? where do I check the output? I am trying to perform CICD operation for the data scripts. Will the DBA have to check manually to see the script is being executed on the server or something? / comments
Also, do you know what type of output are we looking for? I got the access and it was a success. Now what would be the next step? I tried executing a non-destructive script and deployment was a suc...
sasankj said:
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?
Ask DB lead who controls the permissions. Generally they are limited to the DB team and Dev team who work on the database part. If there is no dedicated DevOps team then it is the DBA who handles all the permissions. They will have to provide you with access for the profile you want to use or give you a service account where you can test the scripts / comments
sasankj said:
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 t...
Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account] / comments
Ask him to grant the account/profile (example d2rddb) access to the server and the database as well [for that profile/account]
Use Windows authenticator and run the release or deploy it I mean. When you come across the error showing the profile or account you are using has failed to login, contact your DBA. Provide him with the details and let him know what are you trying to do. He will have your profile/account access be granted and hence, you can see a success in your deployment. / comments
Use Windows authenticator and run the release or deploy it I mean. When you come across the error showing the profile or account you are using has failed to login, contact your DBA. Provide him wit...
Sergio R said:
Assuming you are using the Release task, it won't drop the target database. The Build task uses a temporary database that will be cleaned beforehand and depending on your settings can be a dynamic database that's created at the start of the build and dropped when it finishes.
Can I deploy/execute data scripts from a source control (with a custom folder in it) to the database via RedGate Tasks on TFS 2018 without using Visual Studio or SSMS? Assuming I know the target database, SQL Server credentials... / comments
Sergio R said:
Assuming you are using the Release task, it won't drop the target database.The Build task uses a temporary database that will be cleaned beforehand and depending on your settin...
Sergio R said:
The release logs will indicate whether the release was successful or not.
Hey, thanks for the reply. I am basically trying to execute/deploy scripts from a custom folder on TFS to the database via RedGate. For that operation, does the schema changes take part? Will that cause an issue and would the database be dropped? / comments
Sergio R said:
The release logs will indicate whether the release was successful or not.
Hey, thanks for the reply. I am basically trying to execute/deploy scripts from a custom folder on TF...