Feature Request: Sql Data Compare-limit what is compared by table

Hot Topic

input validation
Moving On
How can you specify the workspace in TF Checkin
Failed to generate a user instance SQL Server Express 2005
runtime error
Install only MSDN 2005 express Edition ?
Working with threads
Copying Specific Drop files from Development Directory to Staging Directory after approval
Programs using different versions of excel and outlook
Unmodified files are asked to be checked out when checking in changes.

VS Team System

SP1, TF30059, TF53018, inconsistent tiers
Printing in VB.NET. You need the PrintForm component.
How do I convert .NET 2.0 Coding into VB 2005 Express Edition coding?
Best way to insert images or tables into a rich text box
VB 2005 Express Tutorial Files
Form Controls
Number to text
Still a bit slow opening projects
Scanning a Drive
Integration with Rational Robot, Visual Build, DevPartner and Install sheild

Feature Request: Sql Data Compare-limit what is compared by table

CTP5 is great! As a developer, I am excited about the new MSBuild functionality. This will allow us to update our developer DB after each stage build.
However the data compare piece does not appear to have the ability to limit what is compared/updated on a table level (i.e only compare/update Users with age>40). Perhaps a bad example, but when your stage DB is 15GB, it would be great to be able to pull down a sub set of your larger tables to your Dev environment. Typically we only want to pull down data related to specific User Sets (ie. Users in specific companies etc.).


Answer this question

Feature Request: Sql Data Compare-limit what is compared by table

  • dc75

    Thanks for forwarding my table level filters suggestion.
    Not caching identical records will help with the amount of space required locally, thanks. However I still have to read through (in some cases) millions of records in specific tables on the source database to compare with my local database. In reality I only need to compare a few thousand records. This would be a huge time saver if implemented. Of course (while I am creating a wish list), to get the full benefit I may need to be able set these filters via code. Extending my example above, I know which companies I want to filter by, but the million plus records table doesn't include a company ID, although it does contain a User ID. Currently I determine the list of users in this company, and filter by those users. Of course this has to be done via code (read API) and SQL queries. Don't know if it would be possible to map these types of dependencies in the MSBuild properties/config setting/XML etc, but if so that would be great. If not, it would be nice to set these filters via code.
    Anyhow, I recognize this may be asking a lot, so whatever you can do, great.

  • DiZASTiX

    Point well taken that we don't offer any filtering of data compare as you have expressed in your example, but you may look into the advanced data compare options to reduce some data to be cached on the server . These are available at the fist page of data compare connection wizard.

    If one unchecks the option for identical records, Internally, data compare would still fetch all the data from the server, but all the data which is identical, will not be stored / cached by data compare feature.

    I will bring your suggestion forward to the relevant people for future consideration.

    Thanks

    Sachin
  • Feature Request: Sql Data Compare-limit what is compared by table
Answer this question