A set of PowerShell cmdlets that will 'diff' two versions of a database and provide a high-level overview of the major database changes made by successive Flyway migrations. You can 'diff' a SQL Server database to the same one on PostgreSQL and find out which objects are the same and which are different.
2021-09-01
Get started with running Flyway migrations on SQLite databases, using PowerShell.
2021-08-27
Phil Factor brings us yet another lesson in Flyway and database migrations. Learn how to use PowerShell with Flyway to run SQL migration scripts that will build, fill and modify a PostgreSQL database.
2021-08-23
During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
2021-08-20
We're thrilled to welcome Microsoft as the Premier Sponsor at this year's PASS Data Community Summit. The Microsoft team will be a fundamental part of the conference program and activities through educational sessions, product deep-dives and announcements, Microsoft-focused workshops, keynotes, and more. We're excited to continue this relationship in support of the global data community.
2021-08-18
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it? Phil Factor explains.
2021-08-16
Describing a database version control system using an Azure DevOps-hosted Team Foundation Version Control repo and SQL Source Control, and a workaround for authentication problems when connecting to multiple Azure DevOps organizations.
2021-08-13
In the Global State of the MSP Report from Datto, cloud and cybersecurity were identified as two key areas for growth. In this blog we cover three wants Managed Service Providers can offer more value in this areas.
2021-08-11
If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed.
2021-08-06
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.
2021-08-04
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Hi everyone. I have this table and this information. (left side of the image)...
I recently created an SSIS package and then converted it to a Package Deployment...
Hi all, So here's the situation. We migrated to a new server as our...