How managing a database project for a Synapse dedicated SQL pool in case of team working

Question

How managing a database project for a Synapse dedicated SQL pool in case of team working

pmscorca 1,052

Hi,

in order to implement the version control for a database to build on a Synapse Analytics dedicated SQL pool, my developer team would use SSDT (in Visual Studio, Azure Data Studio, etc.) in order to create a database project. Now, how managing a such task in team? Is it possible that one developer could create the team_db_project on own dev machine, implement the table_1, and another one could create the same team_db_project on own dev machine, implement the table_2 (different from the table_1)? Which is the right approach to operate in team?

Thanks

Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2023-12-20T05:18:00.6733333+00:00

@pmscorca Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

2 answers

Your answer

Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2023-12-20T05:18:00.6733333+00:00

@pmscorca Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,151 MVP Volunteer Moderator

Hey,

For synchronized development, the best way is to create database project locally and then sync/checkin within either Azure Devops Repo/Git hub repo in the 1st attempt.

Post that users can clone the repos and make changes and checkin those changes for others to pull in those changes.

Sample :

https://azureaggregator.wordpress.com/2023/05/05/ci-cd-with-azure-synapse-dedicated-sql-pool/

Answer 2

Smaran Thoomu 24,260 Microsoft External Staff Moderator

Hi @pmscorca

Welcome to Microsoft Q&A Platform. Thank you for posting your query.

Adding to @Nandan Hegde To manage a database project for a Synapse dedicated SQL pool in a team, you can use Azure DevOps to collaborate with your team members. Azure DevOps provides a set of services for managing your project's lifecycle, including version control, continuous integration, and continuous deployment.

Here's how you can use Azure DevOps to manage your database project:

Create a new project in Azure DevOps and add your team members to the project.
Create a new Git repository in the project to store your database project.
Each developer can clone the repository to their local machine and create a new branch for their changes.
Each developer can make their changes to the database project in their branch and commit their changes to the repository.
Once the changes are complete, the developer can create a pull request to merge their changes into the main branch.
Another team member can review the pull request and approve or reject the changes.
Once the changes are approved, they can be merged into the main branch.
You can use Azure DevOps pipelines to automate the build and deployment of your database project.

Regarding your question about whether one developer can create the team_db_project on their own dev machine and another developer can create the same team_db_project on their own dev machine, the answer is yes. Each developer can create their own copy of the database project on their local machine and make changes to it. However, it's important to ensure that changes are merged into the main branch regularly to avoid conflicts.

Reference:

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2023-12-19T06:28:54.91+00:00

@pmscorca Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
pmscorca 1,052 Reputation points

2023-12-20T15:00:26.79+00:00

Hi, I confirm that I'm interested to work in team and so each developer on own local machine has to manage the same database project.

Moreover, inside Azure DevOps it already exists a project with own repos, so I and other developers can clone it locally using git.

Now, how is it better to proceed: in Visual Studio first open the local repository and then create (how?) the database project or first create the database project and then associate (how?) the local cloned repository?
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2023-12-20T15:42:46.9+00:00
Hi @pmscorca

Thanks for getting back. If you already have a project with its own repository in Azure DevOps, it's better to clone the repository locally using Git and then create a new SQL Server Database Project in Visual Studio. Here are the steps to follow:

Clone the repository to your local machine using Git.

Open Visual Studio and create a new SQL Server Database Project.

In the Solution Explorer, right-click on the project and select "Add Solution to Source Control".

In the "Add to Source Control" dialog box, select "Git" as the source control system and click "Add".

In the "Publish Database" dialog box, select "Use existing Git repository" and click "Publish".

Visual Studio will prompt you to select the local Git repository that you cloned in step 1. Select the repository and click "Publish".

Once you've associated the database project with the local cloned repository, you can start making changes to the project and committing them to the repository. Other team members can then pull the changes from the repository and merge them into their local copies of the project.

I hope this helps! Let me know if you have any further questions.

Please consider hitting Accept Answer button. Accepted answers help community as well.

Share via

How managing a database project for a Synapse dedicated SQL pool in case of team working

2 answers

Your answer