{"id":1175,"date":"2022-05-23T14:12:20","date_gmt":"2022-05-23T14:12:20","guid":{"rendered":"https:\/\/www.versionsql.com\/help\/documentation\/release-notes\/versionsql-1-9\/"},"modified":"2022-05-24T16:41:00","modified_gmt":"2022-05-24T16:41:00","slug":"versionsql-1-9-branching","status":"publish","type":"docs","link":"https:\/\/www.versionsql.com\/help\/documentation\/release-notes\/versionsql-1-9-branching\/","title":{"rendered":"VersionSQL 1.9 &#8211; Branching"},"content":{"rendered":"<p>The birds are singing, flowers blooming, and VersionSQL is growing new branches \ud83c\udf33 (in your version control system, that is).\u00a0 Gather up your fertilizer, because it&#8217;s the most agricultural release of VersionSQL yet!<\/p>\n<p>(Got an itchy green thumb? <a href=\"\/download\/?ctaid=19notesTop\" target=\"_blank\" rel=\"noopener\">Download it right now!<\/a> Rather have the highlights in bullet-point form? <a href=\"\/changelog\/\">Click here for a concise changelog<\/a>.)<\/p>\n<p><strong>New growth:<\/strong><\/p>\n<ul>\n<li><strong>Boughs<\/strong>\n<ul>\n<li><a href=\"#branch-switching\">Branch Switching<\/a><\/li>\n<li><a href=\"#branch-creation\">Branch Creation<\/a><\/li>\n<li><a href=\"#extended-properties\">Extended Properties<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Twigs<\/strong>\n<ul>\n<li><a href=\"#branch-specification-at-setup\">Branch Specification at Setup<\/a><\/li>\n<li><a href=\"#commit-entire-server-instance\">Commit Entire Server Instance<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#bugfixes\">Bugfixes<\/a><\/li>\n<li><a href=\"#final-thoughts\">Final Thoughts<\/a><\/li>\n<\/ul>\n<h2>Boughs<\/h2>\n<h3>Branch Switching<\/h3>\n<p>Just like a tree stretches many branches in all directions to build support for the wide canopy of leaves that collect nourishing sunshine, so the database developer enacts many changes in constructing the infrastructure necessary for growth to the business \ud83c\udf1e<\/p>\n<p>To keep things organized, save all of the changes for each discrete project to different branches.\u00a0 By examining individual branches, you&#8217;ll be able to clearly and distinctly monitor the progress of each endeavor, notice any bugs that creep in, and pick out the necessary scripts for deployment.<\/p>\n<p>Far from digging in the weeds, with VersionSQL 1.9 you&#8217;ll leap from branch to branch with the poise and grace of our bushy-tailed friends \ud83d\udc3f\ufe0f<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"padding: 5px;\" src=\"\/help\/wp-content\/uploads\/2022\/05\/wn-1.9-branch-switch.gif\" \/><\/p>\n<div class=\"wedocs-callout callout-yellow\">\ud83d\udc68\u200d\ud83c\udf3e <strong>Master gardener says:<\/strong> In a shared database scenario, many branches connect to the same tree.\u00a0 To avoid cross-pollination, review the list of changes every time you run a commit to ensure only those relevant to the current branch are included.<\/div>\n<p>Thanks to Hilmi E, Phil P, and others for suggesting this feature.<\/p>\n<h3>Branch Creation<\/h3>\n<p>Too many changes happening in trunk \ud83d\ude35?\u00a0 Sprout off new branches for the junior developers to climb around in \ud83d\udc66 \u00a0When they&#8217;re done you can use your version control system&#8217;s tooling to graft the changes back in.\u00a0 And if things get too knotty or gnarly, just lop that branch right off \ud83e\ude93<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"padding: 5px;\" src=\"\/help\/wp-content\/uploads\/2022\/05\/wn-1.9-branch-create.gif\" \/><\/p>\n<div class=\"wedocs-callout callout-yellow\">\ud83d\udcd5 <strong>Farmer&#8217;s Almanac says:<\/strong> Deleting a branch of SQL code will drop changes from your version control repository, but those edits will still be present in the database.\u00a0 Take a look at the branch&#8217;s change history first to see what needs cleared out.<\/div>\n<p>&nbsp;<\/p>\n<h3>Extended Properties<\/h3>\n<p>Hidden as they are, deployment of SQL Server Extended Properties often leaves us stumped.\u00a0 Starting now, VersionSQL scripts out extended properties right along with the object that carries them, making transplanting a breeze \ud83d\udc4d<\/p>\n<p>Thanks Alon R for writing in to ask for this feature.<\/p>\n<h2>Twigs<\/h2>\n<h3>Branch Specification at Setup<\/h3>\n<p>Living in a tree already? \ud83e\udda5 Climb to the right branch from the start by calling its name during connection setup.<br \/>\n<img decoding=\"async\" class=\"aligncenter\" style=\"padding: 5px;\" src=\"\/help\/wp-content\/uploads\/2022\/05\/docs-1.9-branch-setup.png\" \/><\/p>\n<div class=\"wedocs-callout callout-yellow\"><strong>Important:<\/strong> The branch name you enter here must be spelled exactly the same as a branch already existing in the repository.\u00a0 To create a new branch, instead leave the Branch field blank during setup and use the Switch\/Create Branch interface.<\/div>\n<p>&nbsp;<\/p>\n<h3>Commit Entire Server Instance<\/h3>\n<p>Careful branching works great for the arborist, but perhaps you&#8217;re more of a park ranger with an entire forest under your care \ud83c\udfde\ufe0f\u00a0 Catalog the whole thing all at once!<\/p>\n<p>1) Enable the experimental feature under <code>VersionSQL<\/code> \u2192 <code>Settings<\/code>:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" style=\"padding: 5px;\" src=\"https:\/\/www.versionsql.com\/help\/wp-content\/uploads\/2022\/05\/1.9-commit-entire.png\" \/><\/p>\n<p>2) Right click on the server instance and click <code>Commit Entire Instance<\/code>:<br \/>\n<img decoding=\"async\" class=\"aligncenter\" style=\"padding: 5px;\" src=\"https:\/\/www.versionsql.com\/help\/wp-content\/uploads\/2022\/05\/1.9-commit-entire2.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Note that this will skip any databases that have not yet been connected to version control, so do that first.\u00a0 Thanks Mark R. for the request.<\/p>\n<h2>Bugfixes<\/h2>\n<p>\ud83d\udc1e VersionSQL now blocks multiple simultaneous commits for the same database to avoid resource conflicts (file locking, etc.)<\/p>\n<p>\ud83e\udd97 Trial status banner now updates immediately after license activation (thanks Tim!)<\/p>\n<h2>Final Thoughts<\/h2>\n<p>The best time to start version controlling your database was 20 years ago.\u00a0 The second best time is now.\u00a0 Plant a SQL seedling of your own and watch it grow into a beautiful tree: <a href=\"\/download\/?ctaid=19notesBottom\">Download VersionSQL today \ud83c\udf31<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":994,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"doc_tag":[],"class_list":["post-1175","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/comments?post=1175"}],"version-history":[{"count":41,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1175\/revisions"}],"predecessor-version":[{"id":1235,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1175\/revisions\/1235"}],"up":[{"embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/994"}],"next":[{"title":"VersionSQL 2.0","link":"https:\/\/www.versionsql.com\/help\/documentation\/release-notes\/versionsql-2-0\/","href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1278"}],"prev":[{"title":"VersionSQL 1.8 - Scripting","link":"https:\/\/www.versionsql.com\/help\/documentation\/release-notes\/versionsql-1-8-scripting\/","href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/docs\/1124"}],"wp:attachment":[{"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/media?parent=1175"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.versionsql.com\/help\/wp-json\/wp\/v2\/doc_tag?post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}