User Connections will soon replace Integrations
To continue using Push to git functionality, each user will have to configure their git integration in User Connections and provide their own personal access token. This functionality will no longer be limited to admins.
The feature is only available to users with Account Admin privileges.
This feature may not be available by default and might need to be enabled upon request. Please contact your account manager for more information.
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 GitHub 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 GitHub. Create or choose an organization.
2. Create a Personal Access Token.
Go to: Developer settings → Personal Access Tokens→ Generate new token.
Once created, make sure to copy the above token. GitHub doesn't store it, and you will not be able to see it again.
The token 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.
Minimum required permissions for the token:
3. Open the SqlDBM Account - User Connections - page in a different browser tab.
4. Choose the "Github" option.
5. Enter your token in the "Personal Access Token" field.
6. Open GitHub again and create and initialize a repository
7. Copy the link with HTTPS.
8. Open SqlDBM "User Connections" with the specified token.
9. Specify the repository URL.
10. Unmark the checkbox if you don't need to create pull requests.
11. Done.
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:
Code -> Overview -> Your branch -> Branch name -> there should be a commit with your SQL script.
Otherwise, if you selected the 'Create Pull Request' option on the Integration page, go to Pull Requests
