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.

Related posts:

  1. SQL Solution center round-up – March 15th, 2014 – SQL refactoring techniques
  2. SQL Solution center round-up – February 28th, 2014 – SQL refactoring techniques and SQL Server auditing
  3. SQL Solution center round-up – January 15th, 2014 – SQL code formatting and SQL Server memory performance metrics
  4. SQL Solution center round-up – February 15th, 2014 – SQL formatting, recovery of deleted images, SQL Server auditing, security, and compliance
  5. SQL Solution center round-up – December 15th, 2013 – compliance guidelines for SQL DBAs, SQL Server performance monitoring, rules of SQL formatting
April 15, 2014