Skip to main content

Posts

Showing posts from September, 2012

SQL Restore Dates

The below page gives a good example of DB Restored Log for all the databases from the database "msdb". SQL Query from system database msdb to list Restore History of all databases http://www.sqlusa.com/bestpractices2005/dateoflastrestore/

SSIS Row Migration with identity column automation

Here is a solution for SSIS row migration with sql identity column being correctly referenced in child tables. I started off not thinking about the option of "keep integrity", but later also realized that I need to have the option where the identity column may not match from development to staging, and from staging to production, as I keep having to add and delete multiple times on development and additional administrators working on there stuff on staging. Hope this solution may help out people who need to have similar solution for there projects. Please post a comment or suggestion below.