Posts Tagged with SQL Compare
In SQL Server 2016, Microsoft introduced support for system-versioned temporal tables. Temporal tables are a database feature that provides information about data stored at any point in time, rather than only the data that is correct at that specific moment. Why are temporal tables needed? Simply put, they make it much easier to analyze... Read more
The final part of Alex Yates's three-part series tackles the complicated issue of automating deployments when the same table might have a different structure, in different production versions of the database. Read more
How to extract a database migration script, or a database build script, from a DacPac and then use it in a PowerShell-automated database deployment. Read more
How to eliminate false positives, and avoid making unintended changes to a database, when comparing the schema of two SQL Server databases. Read more
When I attended PASS Summit recently, I sat down with Chris Yates, Assistant Vice President and Database Administration Manager of Republic Bank, to understand more about their day-to-day development tasks and how Redgate tools have helped improve their development practices. This is their story. “In a previous life, SQL Server database comparisons and deployments... Read more
In Part 2 of his series, Alex Yates shows how to use a combination of post-deployment scripts to handle cases where a code object exists in multiple production instances, but in different states. Read more
How do you push out the schema changes to ten copies of the database on ten different servers, as part of a deployment? Read more
How to use filters in SQL Compare to avoid deploying objects that exist only in the source to databases where they may not be required or appropriate. Read more
How to compare SQL databases using DACPACs, script out differences and then run a database deployment task to synchronize the schema of the target database. Read more
SQL Compare provides a command line interface (CLI) for running database schema comparisons and generating a deployment script, as part of a scripted process. I'll demonstrate how to do this with a 1-click process, using a batch (.bat) file. Read more
