This feature may not be available by default and might need to be enabled upon request. Please contact your account manager for more information.
Git integrations for SqlDBM projects are managed through User Connections. While this article provides specific instructions for Azure DevOps, the related article at the end of this post covers the rest of the common steps to configuring the integration.
Once the integration has been configured, see the related at the end of this post on pushing to git and the various ways of generating the files themselves.
To enable version control through the Azure DevOps repository, you will need to create a Personal Access Token and link it with SqlDBM using the steps below.
Please make sure to initialize your repository by creating at least one file in the main branch (Readme.md for example).
1 . Go to Azure DevOps. Create or choose an organization.
2. Create a Personal Access Token.
Go to: User settings → Personal Access Tokens.
Once created, make sure to copy the above token. Azure doesn't store it, and you will not be able to see it again.
-
Token must have read & write permissions (see screenshot) or full access.
-
If you want to create pull requests while pushing, there should be no restrictions on creating a pull request for the user who created the token.
-
Note the expiration period. When it expires, the token will no longer be valid, and the integration will break.
3. Open the SqlDBM Account - User Connections - page in a different browser tab.
5. Choose the "Azure DevOps" option.
5. Enter your token in the "Personal Access Token" field.
6. Open Azure DevOps again and create and initialize a repository.
You can initialize a repository from the Repository page.
Copy the link
7. Open SqlDBM "User Connections" with the specified token.
8. Specify the repository URL.
9. Unmark the checkbox if you don't need to create pull requests.
10. Done.
Notice, you can add links only to those repositories that are related to the organization under the specified Personal Acess Token.
Project users will now see a "Push to Git" button on the Forward engineering page. It will become active after generating DDL or YAML scripts.
The same behavior in the DataOps page (alter script popup).
After a successful push request, find your script in the repository files:
Files -> Commits - there should be a commit with your SQL script.
Otherwise, if you selected the 'Create Pull Request' option in the azure integration page, go to:
Pull Request to master/main branch.