Is there a way to apply a new design template from one SQL Server Database to another SQL Server Database either through a wizard or automatically generated scripts, and keep the existing data ( as long as the tables / columns are still present) in the target database. The scenarios for this are :
1) Upgrade to Production Database after UAT / Dev work has been tested / accepted.
2) Ensure that your Dev / UAT database, containing test personal data ( "Joseph K Testing", "Darth Solo" etc ) is an accurate representation of the LIVE schema...