John O'Shea

John O’Shea is a SQL Database Administrator with 10 years of direct SQL experience ranging from SQL 7 to SQL 2008. He currently works for Raymond James, a diversified financial services holding company with subsidiaries engaged primarily in investment and financial planning, in addition to investment banking and asset management located in St Petersburg Florida. His blog SQL, Powershell & Etcetera, can be found here. John is interested in SQL, Powershell, Strength Athletics & Sci-Fi.

24 July 2009
24 July 2009

Doing Schema Comparisons with Production Servers

There are usually strict rules against accessing production servers that generally apply even to the developers of the systems involved. John O'Shea comes up with a very elegant and versatile solution with Powershell that uses SQL Compare's ability to take, and compare, snapshots of databases to enable the developers to then compare development databases against the latest snapshots of production ones. Result? Happy developers!… Read more