SQL Solution center round-up – April 15th, 2014 – SQL Server database refactoring techniques

In the latest SQL Solution center articles, we continued with SQL Server database refactoring techniques.

Having in mind that any change made in a database schema requires all dependences to be updated and changed to reflect the changes you made, we started with solutions for finding and updating internal references. We provided step-by-step instructions to find the internal references using SQL Server Management Studio options, T-SQL code, and ApexSQL Refactor.

To be able to fix all broken constraints, views, triggers, stored procedures, tables, and other database objects after database refactoring, you must find and fix the external references as well. SQL database refactoring – Finding external references by analyzing object dependencies explains database couplings and shows how to find database application dependencies and cross database dependencies using ApexSQL Refactor.

April 15, 2014