Enterprise-only feature.
The feature is only available to users with Account Admin privileges.
Once the integration has been configured, see the related article on using this feature and the various ways of generating the files themselves.
To enable version control through the Bitbucket repository, you will need to create a Person 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 Bitbucket. Create or choose an organization.
2. Create a Personal app password.
Go to: Personal settings → App passwords
Once created, make sure to copy the above token. Bitbucket doesn't store it, and you will not be able to see it again.
Password must have read & write permissions 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 "Integrations" page in a different browser tab.
4. Choose the "Bitbucket" option.
5. Enter your password in the "Personal Access Token" field.
6. Enter the BitBucket login
7. Open BitBucket again and create a repository.
8. Copy the link with HTTPS.
9. Open SqlDBM "Integrations" with the specified token.
10. Select a project.
11. Specify the repository URL.
12. Select users who will have push permissions (modelers or project owner only.)
13. Unmark the checkbox if you don't need to create pull requests.
14. Click Connect Integration button.
15. 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 Bitbucket" button on the Forward engineering page. It will become active after generating DDL through Create or Alter scripts.
The same behavior in the DataOps page (alter script popup).
After a successful push request, find your script in the repository files:
Commits - there should be a commit with your SQL script.
Otherwise, if you selected the 'Create Pull Request' option in the Integration page, go to: Pull Requests
