mapped tables still show as different

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

mapped tables still show as different

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

regualr SQL2008 DB compare, nothgin special

Same fields in tables but in different order in each DB. They are mapped correctly but still show up as a difference. Which I guess is correct but I want to exclude this from my comparison.

I am comparing 120 tables so its allot of signal to read through to find the real differences so I want to remove it.

Any ideas on how ? I cannot see how in teh filter rules.

Thanks

Please Ignore found it
jam13007
 
Posts: 2
Joined: Tue Dec 18, 2012 11:05 pm

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

You can optionally ignore the column ordering using SQL Compare options. I'm glad that you found that.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests