Thursday, June 20, 2013

Compare collation of tables from SQL Server 2000(source) to 2008(target) and create script to alter collation at target

We are always upgrading from lower version to highest version. There may be chances that collation is mismatched from our old version(2000) to new version(2008). I have tried to create script which will use of OPENROWSET command to read system tables from SOURCE database and compare it with TARGET database. This script will return difference from SOURCE to TARGET tables which are exists in TARGET database. We are doing that because it’s possible that we don’t want some table from older version. This script also provides alter script for TARGET database to sync collation with SOURCE database.
Below is script to download.

No comments:

Post a Comment