The birds are singing, flowers blooming, and VersionSQL is growing new branches 🌳 (in your version control system, that is). Gather up your fertilizer, because it’s the most agricultural release of VersionSQL yet!
- Final Thoughts
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 🌞
To keep things organized, save all of the changes for each discrete project to different branches. By examining individual branches, you’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.
Far from digging in the weeds, with VersionSQL 1.9 you’ll leap from branch to branch with the poise and grace of our bushy-tailed friends 🐿️
Thanks to Hilmi E, Phil P, and others for suggesting this feature.
Too many changes happening in trunk 😵? Sprout off new branches for the junior developers to climb around in 👦 When they’re done you can use your version control system’s tooling to graft the changes back in. And if things get too knotty or gnarly, just lop that branch right off 🪓
Hidden as they are, deployment of SQL Server Extended Properties often leaves us stumped. Starting now, VersionSQL scripts out extended properties right along with the object that carries them, making transplanting a breeze 👍
Thanks Alon R for writing in to ask for this feature.
Branch Specification at Setup
Living in a tree already? 🦥 Climb to the right branch from the start by calling its name during connection setup.
Commit Entire Server Instance
Careful branching works great for the arborist, but perhaps you’re more of a park ranger with an entire forest under your care 🏞️ Catalog the whole thing all at once!
1) Enable the experimental feature under
2) Right click on the server instance and click
Commit Entire Instance:
Note that this will skip any databases that have not yet been connected to version control, so do that first. Thanks Mark R. for the request.
🐞 VersionSQL now blocks multiple simultaneous commits for the same database to avoid resource conflicts (file locking, etc.)
🦗 Trial status banner now updates immediately after license activation (thanks Tim!)
The best time to start version controlling your database was 20 years ago. The second best time is now. Plant a SQL seedling of your own and watch it grow into a beautiful tree: Download VersionSQL today 🌱