Ignore certain column types in comparrison

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Ignore certain column types in comparrison

Postby jam13007 » Tue Dec 18, 2012 11:30 pm

I want to ignore a certian type of difference.

When one column is varchar and the other is nvarchar. It doeas not affect the changes we are making.

I want to excldue this difference from the results to see other differences as we are comparing abour 120 tables.

Is that possible ?

Thanks
jam13007
 
Posts: 2
Joined: Tue Dec 18, 2012 11:05 pm

Postby Brian Donahue » Tue Jan 15, 2013 11:49 am

There are many options in SQL Compare for ignoring cretain attributes of a table, such as key names and column order, but you cannot ignore the datatype.

Hope this helps.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby madhav20 » Thu Feb 21, 2013 9:18 pm

Hi
I have a date column with same name in all tables in source and target databases, I wanted to exclude the column from data comparison. Is there any option for this requirement in SQL compare 10?

Brian Donahue wrote:There are many options in SQL Compare for ignoring cretain attributes of a table, such as key names and column order, but you cannot ignore the datatype.

Hope this helps.
madhav20
 
Posts: 1
Joined: Thu Feb 21, 2013 9:10 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests