Glad you like them. Is there a specific topic that you'd like to see covered? I'll be making more videos once I get my motherboard replaced on my desktop.
Thanks for the great video. Quick Question : Since you are deploying to an On-prem sql server, do you need to install a self-hosted Agent in your Server, or you can use an azure pipelines Agent?
@Elizabeth Noble : I get build errors, apparently it is failing on scripts referencing system objects while piping through devops (tried msbuild and visual studio task). I referenced Master db (package) while using ADS and I could see an entry in .sqlproj file, ADS builds and publishes great. Any troubleshooting tips will be greatly appreciated.
Hi Elizabeth, I had 2 questions and would really appreciate your inputs. 1. In the build pipeline, what's the significance of copying the dacpac on to artifact staging directory and why we need to do that? 2. In our database (AZ SQL database), there are a few tables whose DDL change dynamically as a part of ETL? As a result, I am unable to bring the DB under GIT as it modifies schema of those tables in the release. I can't separate these tables from the DB as they are used heavily in other procs and views as these are basically contain source data. I could not find any way to make the project "ignore" the schematic differences on these tables (isolated in a separate schema).
Hi Sourav, thanks for reaching out. I'm copying the dacpac on to artifact so that I can use it in the release pipeline. If I don't do that, I believe the release can't find any code to deploy. At my company, we use OctopusDeploy to deploy our database objects so we don't need to copy the artifact in this step. I'm hoping to do some videos using OctopusDeploy in the future. What part of the tables are different? The schema name, table name, columns, indexes? I may have to do some testing to see if there's a way to handle this. It may be that a migration based approach could work better for your situation. That's where you would create individual script files that get deployed. That way you could control what does and does not change.
I am getting following two errors as I have linked servers on my database. Can you please help me configure them in my db project dacpac? SQL71561: View:'View' contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: blah blah and Severity Code Description Project File Line Suppression State Warning SQL71502: Procedure: 'Table' has an unresolved reference to object [sys].[objects].[type].
I've got a video planned for this once I get my main computer fixed. Would you prefer to see multiple databases built and deployed in the same pipeline? Or how to build each database separately when there are multiple databases in a database project?
@@elizabethnoble22 i have multiple sql files in a folder. i need to execute them with invoke-sqlcmd to a single database and need to know how can we print the output of each insert, update, select statement ,drop,truncate,create database,alter database in a particular sql file also need to print how many scripts got executed before the error in that particular sql file
Love this idea! Azure Devops with Azure Data Studio🥳 Looking what has changed for this 2 years!
Nice video. Well-paced and very infromative. I am going to try this into Azure tomorrow 👍
Good job on this tutorial. Followed your steps and it worked like a charm!
Great, straightforward explanation. Really helpful, thank you.
That was great. I hope you keep making these.
Glad you like them. Is there a specific topic that you'd like to see covered?
I'll be making more videos once I get my motherboard replaced on my desktop.
Thanks for the great video. Quick Question : Since you are deploying to an On-prem sql server, do you need to install a self-hosted Agent in your Server, or you can use an azure pipelines Agent?
great tutorial! I had question, where did you copy your Source and Target folder names from when creating the Copy File task in the pipeline?
@Elizabeth Noble : I get build errors, apparently it is failing on scripts referencing system objects while piping through devops (tried msbuild and visual studio task). I referenced Master db (package) while using ADS and I could see an entry in .sqlproj file, ADS builds and publishes great. Any troubleshooting tips will be greatly appreciated.
How to execute mutiple sql in Azure devops to execute in Azure Database
Fantastic video!
thank you, do you have the process to deploy the database in azure sql server, thank you again
Hi Elizabeth,
I had 2 questions and would really appreciate your inputs.
1. In the build pipeline, what's the significance of copying the dacpac on to artifact staging directory and why we need to do that?
2. In our database (AZ SQL database), there are a few tables whose DDL change dynamically as a part of ETL? As a result, I am unable to bring the DB under GIT as it modifies schema of those tables in the release. I can't separate these tables from the DB as they are used heavily in other procs and views as these are basically contain source data. I could not find any way to make the project "ignore" the schematic differences on these tables (isolated in a separate schema).
Hi Sourav, thanks for reaching out.
I'm copying the dacpac on to artifact so that I can use it in the release pipeline. If I don't do that, I believe the release can't find any code to deploy. At my company, we use OctopusDeploy to deploy our database objects so we don't need to copy the artifact in this step. I'm hoping to do some videos using OctopusDeploy in the future.
What part of the tables are different? The schema name, table name, columns, indexes? I may have to do some testing to see if there's a way to handle this. It may be that a migration based approach could work better for your situation. That's where you would create individual script files that get deployed. That way you could control what does and does not change.
I am getting following two errors as I have linked servers on my database. Can you please help me configure them in my db project dacpac?
SQL71561: View:'View' contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: blah blah and Severity Code Description Project File Line Suppression State
Warning SQL71502: Procedure: 'Table' has an unresolved reference to object [sys].[objects].[type].
Add NoTransactions to the SQLCompareOptions in the task
Can you pls share the repo links
How to execute mutiple sql in Azure devops to execute in Azure Database
I've got a video planned for this once I get my main computer fixed. Would you prefer to see multiple databases built and deployed in the same pipeline? Or how to build each database separately when there are multiple databases in a database project?
@@elizabethnoble22 i have multiple sql files in a folder. i need to execute them with invoke-sqlcmd to a single database and need to know how can we print the output of each insert, update, select statement ,drop,truncate,create database,alter database in a particular sql file also need to print how many scripts got executed before the error in that particular sql file