We can recommend you a our reliable solutions for data and schema comparison for SQL Server: dbForge Schema Compare for SQL Server and dbForge Data Compare for SQL Server. Their main advantages are high speed (up to 3 times quicker than most competitors) and extreme reliability. SQL data compare - Compare SQL data from live databases. Automatically compare and synchronize SQL Server data. Even a difficult update with table, column.
Are you talking about my dynamic script? There is a solution for this problem - we can convert all column values to nvarchar(max) first - most common types can be converted to nvarchar(max) and only some exotic types can not be converted.
You're excluding ClientId column but trying to join columns based on Id. Also, you no longer will be able to join based on the column name. Perhaps you also need to use Ordinal_position and use it for joining instead of the column name (which is not going to match anymore).
Hi Anil, This is however, a Dynamic Query using Cursors, and is always considered to be Resource intensive, degrading Query performance. But, keeping your requirement in mind, this seems to be a feasible approach. KEY_COL is one column that I have added to your table (above questions).