Product articles SQL Source Control Database Source Control
SQL Source Control v6 now supports SQL…

23 October 2017
23 October 2017

SQL Source Control v6 now supports SQL Server 2017, SQL Graph, and TFS 2018

SQL Source Control v6 offers full support SQL Server 2017, including the ability to version control graph databases. and also adds support for Team Foundation Server 2018.

SQL Server 2017 went on general release a couple of weeks ago and the latest version of SQL Source Control offers full support, as well as support for Team Foundation Server (TFS) 2018.

This brings a whole host of benefits and opens up cross-platform workflows, encompassing both on-premises and cloud, through connections to SQL Server instances on Linux and Azure Active Directory authentication. This is good news if you work for an organization in which departments and divisions host their databases on various servers and systems, owned by teams in different geographical locations. You can continue working in the development environment you’re familiar with, using the tools you always use, only now you’ll have direct connections across the ever-changing server landscape.

Take advantage of SQL Graph

Microsoft SQL Server 2017 features the much-anticipated SQL Graph, which provides new graph database capabilities for representing complex many-to-many relationships. Social media platforms like Facebook and LinkedIn use graph databases extensively, and in the era of big data, use cases are emerging across many industries.

Businesses can explore these relationships to reveal valuable information, as you’re probably aware from changes in the types of structures and query abilities being requested of you and your teams. Whether it’s identifying similarities in customers behind trends in purchasing behavior, or mapping patterns in credit card usage to determine credit limits or risk indicators of defaulting on repayments, the introduction of graph capabilities to SQL Server makes the processes more streamlined.

Today’s release of SQL Source Control v6 joins Redgate’s recently released SQL Compare v13 in fully supporting SQL Graph, so if you’re experimenting with SQL Graph databases, or getting more BI requests through, you can now use a single query across relational and graph database objects, and deploy updated databases with the tools you know and love.

That’s not the end of the story

SQL Source Control v6 also delivers lots of improvements to user experience and workflows, many of which came about as suggestions from you in our Redgate Community Hub. Importantly, it does so with a much smaller footprint, thanks to an overhaul of the entire codebase, resulting in better stability overall.

You can happily explore all the new features in SQL Server 2017, knowing the industry standard for version controlling your databases won’t let you down. To find out more about the improvements in SQL Source Control v6, take a look at our release notes.

And to learn why it’s important to version control the database, read our recent blog post, Six reasons to version control your database.

 

You may also like

  • Article

    Azure SQL Elastic Pools and SQL Monitor

    This article explains the Azure-tailored metrics and alerts in SQL Monitor that track use of the limited compute resources available to an Azure SQL Elastic Pool, and to each of the databases in it.

  • Webinar

    Meltdown and Spectre: what’s the impact on your SQL Server performance?

    Join Bob Pusateri, Microsoft Certified Master (MCM) and Solutions Architect at Heraflux Technologies, as he delves into the scary world of processor vulnerabilities, brought to light recently by the Meltdown and Spectre bugs. Bob will explore the impact these bugs can have on your estate, from initial vulnerability through to performance after patching, and how you can keep on top of it all with SQL Server monitoring.

  • Article

    Proactively monitor your SQL Server estate with SQL Monitor 9

    Faris Hilmi introduces the new Estate pages in SQL Monitor 9, which provide estate-wide views of disk space usage, backups and other jobs, and application of recent SQL Server updates and patches. Using them, a team can review the overall health of all their servers and databases, identify potential issues before they escalate into real problems, and assign priorities, proactively.

  • Article

    Remembering passwords in SQL Compare and SQL Data Compare

    SQL Compare or SQL Data Compare can automatically populate your SQL Server credentials, if you wish. Just check the "Remember credentials" box, and passwords will now be stored in two places: the Windows Credential Store and your project file, if you save one.

  • Forums

    SQL Source Control Forum

    Connect your databases to your source control system