Odd partioning behaviour

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

Odd partioning behaviour

Postby Niall » Thu Apr 25, 2013 3:20 pm

Where I have a table that is partioned and this has partitioned indexes if the column used by the index for the partitioning scheme differs from that used by the table then SQL Compare incorectly thinks that column is used by the tables partition.

I will see if I can work out a small sample script for you that demonstrats this.
Niall
 
Posts: 20
Joined: Wed Jul 21, 2010 9:15 am

Postby james.billings » Mon Apr 29, 2013 3:41 pm

Thanks for your post-

This doesn't ring a bell as a known problem, but it's a pretty specific scenario you're describing. If you're able to send an example over to us at support@red-gate.com with F0072294 in the subject line, we can validate the behaviour and log a bug as necessary.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests