SQL Compare 13.1 brings improvements to the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. Read more
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. Read more
Describing SQL Compare's built-in Active Directory Authentication mode, which makes it easier and more secure to, for example, deploy schema changes from version control to an Azure SQL Database. Read more
The Visual Studio extension of SQL Change Automation (SCA) allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with SCA, in Visual Studio, and chere I’m going to show to get up and running when there is already an existing development database. Read more
Jamie Wallis introduces the new Summary View, which is a tab that sits alongside SQL View and provides a more concise breakdown of the differences between two objects. Read more
Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn't. But one particularly common culprit is when deployments go wrong: I don't know a single DBA who hasn't been burned by a bad release. Read more
SQL Compare 12.4 adds the Summary view, a tab that sits alongside SQL view and provides a more concise breakdown of the differences between two objects. Read more
How to use SQL Compare Pro command line with PowerShell to automate the processes of getting a new database into source control, updating the source with the latest database changes, creating a new build script for a database version, and creating a deployment script to synchronize an existing database with source. Read more
How to use the SQL Compare Pro command line to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the source database. Read more